Ora-28500 Error Link To DG4DB2 - Remote Database not found (Doc ID 1400442.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms


I had created a dblink to db2 via DRDA or DG4DB2 Gateway 11.2
After configuring the listener.ora ,tnsnames.ora,init*.ora to test the dblink, this error occurs.
ORA-28500
[Oracle] [ODBC DB2 Wire protocol driver] Remote Database not found

Gateway trace file shows:

hgopoer, line 231: got native error 1242 and sqlstate HY000; message follows...
[Oracle][ODBC DB2 Wire Protocol driver]Remote Database Not Found: CRPDTA {HY000,NativeErr = 1242}
Exiting hgopoer, rc=0 at 2011/12/30-09:59:51
hgocont, line 2754: calling SqlDriverConnect got sqlstate HY000
Exiting hgocont, rc=28500 at 2011/12/30-09:59:51 with error ptr FILE:hgocont.c LINE:2774 FUNCTION:hgocont() ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2011/12/30-09:59:51 with error ptr FILE:hgolgon.c LINE:801 FUNCTION:hgolgon() ID:Calling hgocont
Entered hgoexit at 2011/12/30-09:59:51
Exiting hgoexit, rc=0

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