Unable to retrieve text of NETWORK/NCR message 65535
Hi,
I am trying to connect to SQL Server db from Oracle db using db link and gateway on a linux platform.
This how I set it up.
I Installed the oracle database 11g gateway
Configured a new listener.
my Listener.ora file
SID_LIST_LISTENERSQL_FCD =
(SID_LIST =
(SID_DESC =
(SID_NAME=dg4msql)
(ORACLE_HOME=/home/kechrist/Oracle11gr1/product/11.1.0/db_1)
(PROGRAM=dg4msql)
)
)
LISTENERSQL_FCD =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1522))
)
)
my tnsnames.ora file
dg4msql =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ple65110fwks.us.oracle.com)(PORT=1522))
(CONNECT_DATA=(SID=dg4msql))
(HS=OK)
)
script used to create the dblink
Create database link abc
Connect to "Login" identified by "Password"
Using 'dg4msql'
when I say
select * from table_name@abc
I get the following error
Error at Command Line:1 Column:33
Error report:
SQL Error: ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from abc
28545. 0000 - "error diagnosed by Net8 when connecting to an agent"
*Cause: An attempt to call an external procedure or to issue SQL
to a non-Oracle system on a Heterogeneous Services database link
failed at connection initialization. The error diagnosed
by Net8 NCR software is reported separately.
*Action: Refer to the Net8 NCRO error message. If this isn't clear,
check connection administrative setup in tnsnames.ora
and listener.ora for the service associated with the
Heterogeneous Services database link being used, or with
'extproc_connection_data' for an external procedure call.