ORA-04052 and ORA-28501 When Setting Up TG4DRDA To DB2 UDB Database (Doc ID 464019.1)

Last updated on FEBRUARY 23, 2012

Applies to:

Oracle Database Gateway for DRDA - Version: 10.2 to 11.2.0.3 - Release: to 11.2
Information in this document applies to any platform.
Checked for Relavency 05/12/2010 - WLL

Symptoms

User gets the following error while running TG4DRDA bind package:

SQL> exec GTW$_BIND_PKG@udb
BEGIN GTW$_BIND_PKG@udb; END;

*
ERROR at line 1:
ORA-04052: error occurred when looking up remote object
ora11.GTW$_BIND_PKG@UDB.MCI.FS.FED.US
ORA-00604: error occurred at recursive SQL level 1
ORA-28501: communication error on heterogeneous database link
TG4DRDA v10.2.0.2.0 grc=0, drc=-30081 (839C,0001), errp=GDJICRD
errmc=socket() System-Call Failed(10001) Connection refused(111)
ORA-02063: preceding 3 lines from UDB

Changes

Checked for Relevance 02/22/2012

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms