Errmc=Gethostbyname() Temporary Error, Retry Operation(20002) Bad File Number(9) Using DG4DRDA (Doc ID 466171.1)

Last updated on JULY 07, 2011

Applies to:

Oracle Database Gateway for DRDA - Version: 10.1 to 11.1
Information in this document applies to any platform.
Oracle Transparent Gateway for IBM DRDA - Version: 10.1.0 to 11.1.0
***Checked for relevance on 07-Jul-2011***

Symptoms

The following errors occur while running the bind package or selecting from a remote table using TG4DRDA or DG4DRDA:

SQL> exec GTW$_BIND_PKG@DRDA;
BEGIN GTW$_BIND_PKG@DRDA; END;
                    *
ERROR at line 1:
ORA-04052: error occurred when looking up remote object
ORADRDA.GTW$_BIND_PKG@DRDA.CA.CIBCWM.COM
ORA-00604: error occurred at recursive SQL level 1
ORA-28501: communication error on heterogeneous database link
TG4DRDA v10.2.0.1.0 grc=0, drc=-30081 (839C,0001), errp=r(9) RD
errmc=gethostbyname() Temporary error, retry operation(20002) Bad file number(9)
ORA-02063: preceding 3 lines from DRDA



SQL> select * from whereami@nldrda11;
select * from whereami@nldrda11
                       *
ERROR at line 1:
ORA-28501: communication error on heterogeneous database link
DG4DRDA v11.1.0.5.0 grc=0, drc=-30081 (839C,0001), errp=GDJICRD
errmc=gethostbyname() No such host is known(20001) Bad file descriptor(9)
ORA-02063: preceding 3 lines from NLDRDA11


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