ORA-28545: error diagnosed by Net8 when connecting to an agent
Oracle Tips by Burleson Consulting
I have configured listener.ora and tnsnames.ora in
$ORACLE_HOME/network/admin and I have created an
initMSSQLIISDB.ora in $ORACLE_HOME/hs/admin. I attached this
files at the bottom. I also created the dblink and restarted the
listener. The problem is that when I try to retrieve data using
the dblink with a simple select statement I get the following
select count(*) from
ORA-28545: error diagnosticado por Net8 al conectar a un agente
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: 2 lines precediendo a MSSQLIISDB
I have been trying to find out what's wrong. I have checked the
HS_FDS_INST and there's no instance referenced there, so I think
the problem is that the odbc is not registered. As far as I
know, it should auto-register.
ORA-28545: 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.
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts.