ORA-28546ConnectionInitializationFailed,ProbableNet8AdminError 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(protocoltcp)(hosthostname)(port1521)) ) (connect_data (SIDhsodbc) ) (HS) ) Solution: Amend your $ORACLE_HOME/network/admin/tnsnames.ora file as shown above (substitute your actual values for hostname and SID as appropriate).