Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: tns-12560, TNS:protocol adapter error

    server:redhat linux enterpridse(v2.1)
    oracle:8.1.7

    on server,all is ok.
    but client tnsping ,there is errer:tns-12560:TNSrotocol adapter error;
    why?

    listener.ora:
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 202.195.140.39)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /home/oracle/product/8.1.7)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = school1.202.195.140.39)
    (ORACLE_HOME = /home/oracle/product/8.1.7)
    (SID_NAME = school1)
    )
    )



    tnsnames.ora:
    ####################################
    # TNSNAMES.ORA Configuration File:/home/oracle/product/8.1.7/network/admin/tnsnames.ora
    # Generated by Oracle Enterprise Manager V2
    # Date..........: Fri Sep 12 21:57:54 CDT 2003
    ####################################

    SCHOOL1.202.195.140.39 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 202.195.140.39)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = school1)(SERVER = DEDICATED))
    )

    # TNSNAMES.ORA Network Configuration File: /home/oracle/product/8.1.7/network/admin/tnsnames.ora




    sqlnet.ora:
    # SQLNET.ORA Network Configuration File: /home/oracle/product/8.1.7/network/admin/sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.DEFAULT_DOMAIN = localhost.localdomain
    NAMES.DIRECTORY_PATH= (HOSTNAME, TNSNAMES)

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    try : omitting the ipaddress suffixing the SID Entry,
    or change the sqlnet.ora entry names.default_domain to the ipaddress

    what's you hosts file translating to localhost?

Posting Permissions

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