My Oracle Support Banner

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***


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

ERROR at line 1:
ORA-04052: error occurred when looking up remote object
ORA-00604: error occurred at recursive SQL level 1
ORA-28501: communication error on heterogeneous database link
TG4DRDA v10. 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. 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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.