Uda Wiki Web

  • Topic
  • Discussion

    • 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).