ORA-28545 If PROGRAM=dg4odbc.exe Is Specified In The Gateway LISTENER.ORA

刘泽宇

现象：
Trying to connect to a non-Oracle database using the Database Gateway for ODBC  (DG4ODBC) fails with:

ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535


原因：
There is an entry in the gateway LISTENER.ORA file like this:

(SID_DESC =
   (SID_NAME = dg4odbc)
   (PROGRAM = dg4odbc.exe)
   (ORACLE_HOME = d:\OraHome11\product\11.1.0\db_1)
)

The PROGRAM keyword needs to specify the executable, but it is invalid to use the extension .exe for this parameter.

处理方法：
Correct the entry in the LISTENER.ORA to:

(SID_DESC =
   (SID_NAME = dg4odbc)
   (PROGRAM = dg4odbc)
   (ORACLE_HOME = d:\OraHome11\product\11.1.0\db_1)
)

Stop and start the listener after this modification of the LISTENER.ORA file.