%META:TOPICPARENT{name="ErrorMessagesO"}% ==Error Messages (O)== [[UDAErrorMessages|A]] [[ErrorMessagesB|B]] [[ErrorMessagesC|C]] [[ErrorMessagesD|D]] [[ErrorMessagesE|E]] [[ErrorMessagesF|F]] [[ErrorMessagesG|G]] [[ErrorMessagesH|H]] [[ErrorMessagesI|I]] [[ErrorMessagesJ|J]] [[ErrorMessagesK|K]] [[ErrorMessagesL|L]] [[ErrorMessagesM|M]] [[ErrorMessagesN|N]] [[ErrorMessagesO|O]] [[ErrorMessagesP|P]] [[ErrorMessagesQ|Q]] [[ErrorMessagesR|R]] [[ErrorMessagesS|S]] [[ErrorMessagesT|T]] [[ErrorMessagesU|U]] [[ErrorMessagesV|V]] [[ErrorMessagesW|W]] [[ErrorMessagesX|X]] [[ErrorMessagesY|Y]] [[ErrorMessagesZ|Z]] [[ErrorMessagesSymbols|#]] ===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).