ORA-28545: error diagnosed by Net8 when connecting to an agent  Oracle Database Tips by Donald Burleson

 

 

Question: 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 error:

select count(*) from SDC_Cuerpo@MSSQLIISDB

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 scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.