重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: ORA-28545 If PROGRAM=dg4odbc.exe Is Specified In The Gateway LISTENER.ORA [打印本页]

作者: 刘泽宇 时间: 3 天前
标题: 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.

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)