My Oracle Support Banner

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

Last updated on MAY 11, 2022

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

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@DBLINK;
BEGIN GTW$_BIND_PKG@DBLINK; END;
                    *
ERROR at line 1:
ORA-04052: error occurred when looking up remote object
ORADRDA.GTW$_BIND_PKG@DRDA.DOMAIN
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 DBLINK



SQL> select * from whereami@DBLINK;
select * from whereami@DBLINK
                       *
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 DBLINK



Cause

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
Symptoms
Cause
Solution

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