Error Messages (O)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

ORA-28546: connection initialization failed, probable Net8 admin error

Error

ERROR at line 1:

ORA-28546: connection initialization failed, probable Net8 admin error

ORA-02068: following severe error from HSODBC

ORA-03113: end-of-file on communication channel

Application: Oracle 9i Release 2 (v 9.2 and up) Heterogeneous Services

Client OS: Unix (Solaris, HP, AIX, etc)>

Cause

When using Oracle Heterogeneous Services on Oracle Release 9.2 and up on Unix systems, the tnsnames.ora entry is incorrectly formatted. Note the following revised syntax required with Oracle 9.2:

hsodbc 

(description

(address_list

(address

(protocol

tcp)(host

hostname)(port

1521))
)
(connect_data

(SID

hsodbc)
)
(HS

)
)

Solution:

Amend your $ORACLE_HOME/network/admin/tnsnames.ora
file as shown above (substitute your actual values for hostname and SID as appropriate).