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.1Information 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
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
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 |