Wednesday, November 19, 2008

Oracle Generic Connectivity Errors and Solutions

Here is a list of common Oracle HS errors I've come across. Hopefully these notes will help save time finding the causes.


Oracle Errors: ORA-28545, ORA-02063

SQL> desc my_table@my_db_lnk
ERROR:
ORA-28545: error diagnosed by Net8 when connecting to an agent
NCRO: Failed to make RSLV connection
ORA-02063: preceding 2 lines from MY_DB_LINK

Cause: listener was not restarted. Run lsnrctl reload.

---------------------------------------

Oracle Errors: ORA-28545, ORA-02063

SQL> create database link my_db_lnk connect to "scott" identified by
"tiger" using 'MY_TNS_ALIAS';

Database link created.

SQL> desc my_table@my_db_lnk
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 MY_DB_LNK

Cause: HOST and/or PORT in tnsnames.ora is incorrect

---------------------------------------

Oracle Errors: ORA-28545, ORA-02063

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 MY_DB_LINK


Cause: Problem found on AIX and Oracle10g. Need to add the ENVS=LIBPATH line ( as below) in the listener.ora.

(SID_DESC=
(SID_NAME=MY_SID)
(ORACLE_HOME=/u01/oracle/product/10.2.0.2)
(PROGRAM=hsodbc)
(ENVS=LIBPATH=/u01/oracle/product/10.2.0.2/lib32)
)

---------------------------------------

Oracle Errors: ORA-28500, ORA-02063

select CUSTOMER from my_view
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_InitTdp: errors.h (1997): ;
(SQL State: 00000; SQL Code: 0)
ORA-02063: preceding 3 lines from MY_DB_LINK


Cause: The DSN in the $ORACLE_HOME/hs/admin/init.ora is incorrectly defined.