Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to retrieve text of NETWORK/NCR message 65535

User721734-OracleOct 14 2009 — edited Oct 29 2010
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2010
Added on Oct 14 2009
3 comments
4,033 views