Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2010
    Posts
    5

    Unanswered: ODBC connection error - ORA-28547

    Hi All,

    I encounter the below error while I tried to make ODBC connection settings from my client to the Oracle DB server(Oracle 10G). The user ID are active as I had tried to login the ID with 3rd party Oracle client(Aqua Studio).

    Unable to connect
    SQLState=S1000
    [Oracle][ODBC][Ora]ORA-28547: connection to server failed, probable Oracle Net admin error

    I had tried make ODBC connection to 3 different Oracle DB servers(Oracle 10G) and there is only one failed and the other two was fine.

    Anyone has the idea to solve the above issue?
    Is there any files which I need to look into?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    28547, 0000, "connection to server failed, probable Oracle Net admin error"
    // *Cause:   A failure occurred during initialization of a network connection
    //           from a client process to the Oracle server.  The connection
    //           was completed but a disconnect occurred while trying to
    //           perform protocol-specific initialization, usually due to
    //           use of different network protocols by opposite sides
    //           of the connection.  This usually is caused by incorrect
    //           Oracle Net administrative setup for database links or external
    //           procedure calls.   The most frequent specific causes are:
    //           --  The connection uses a connect string which refers
    //               to a Heterogeneous Services agent instead of
    //               an Oracle server.
    //           --  The connection uses a connect string which includes
    //               an (HS=) specification.
    //           --  Hitting Ctrl+C before connection initialization is
    //               complete.
    //           --  Using DRCP on Windows with SQLNET.AUTHENTICATION_SERVICES
    //               set to NTS.
    //           --  Connection timeout due to SQLNET.INBOUND_CONNECT_TIMEOUT
    //               parameter when all shared servers are busy in
    //               shared server configuration.
    // *Action:  Check Oracle Net administration in the following ways:
    //           --  When using TNSNAMES.ORA or an Oracle Names server, make sure
    //               that the client connection to the Oracle server uses
    //               the correct service name or SID.
    //           --  Check LISTENER.ORA on the connection end point's host machine
    //               to assure that this service name or SID refers
    //               to the correct server.
    //           --  Confirm in TNSNAMES.ORA or the equivalent service definition
    //               that the connect string does not contain (HS=).
    //           --  Set SQLNET.AUTHENTICATION_SERVICES to NONE when using DRCP
    //               on Windows.
    //
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2010
    Posts
    5
    Can I know how to check the below? I had posted the listener.ora and tnsnames.ora files. Is there any problem for the settings below?

    1) The connection uses a connect string which refers to a Heterogeneous Services agent instead of an Oracle server.

    2) The connection uses a connect string which includes an (HS=) specification.

    ==========
    listener.ora
    ==========
    # listener.ora Network Configuration File: /oracle/product/10.2.0/db_1/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /oracle/product/10.2.0/db_1)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (SID_NAME = testdb)
    (ORACLE_HOME = /oracle/product/10.2.0/db_1)
    (PROGRAM = extproc)
    )
    )


    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = testserver)(PORT = 1521))
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    )

    ==========
    tnsnames.ora
    ==========
    # tnsnames.ora Network Configuration File: /oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

    EPONE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = testserver)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = testdb)
    )
    )

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = testserver)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = ORCL)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    ================================================== =======

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >and there is only one failed and the other two was fine.
    Make the 1 with a problem configured like the 2 that work.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jul 2010
    Posts
    5
    The two was working fine with the default configuration in the Oracle client side. In this case what are the ares which I need to look into on the Oracle DB server which failed? listener.ora, tnsnames.ora or some other files?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •