DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-12560: TNS:protocol adapter error

  1. #1
    Join Date
    Feb 2004
    Location
    Philippines
    Posts
    9

    Angry ORA-12560: TNS:protocol adapter error

    Hi i have read all the other posts about this error but i cant seem to find on how can i fix this problem. i already tried all the suggestions you told to other people encountering this but it seems it doesnt work on me. here are the details:

    (tnsnames.ora)
    TREE =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = tree)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = tree)(SERVER = DEDICATED))
    )

    TREE.PH.ENTERWORKS.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = tree)(PORT = 1521))
    )
    (CONNECT_DATA = (SERVICE_NAME = TREE))
    )

    (listener.ora)
    # LISTENER.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = tree)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = tree)(PORT = 2481))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\Oracle\Ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = tree)
    (ORACLE_HOME = C:\Oracle\Ora81)
    (SID_NAME = tree)
    )
    )

    TREE.PH.ENTERWORKS.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = tree)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = TREE)
    )
    )

    (sqlnet.ora)
    # SQLNET.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.DEFAULT_DOMAIN = tree.ph.enterworks.com

    #SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
    ====================================================================
    I was trying to export a table thru Enterprise Manager Console and i always got failed. Also, i tried exporting using a DOS command: "exp userid=ora_88836/ora_88836 file=wyndat.dmp owner=ora_88836" and thru this i get to have an error ORA-12560: TNSrotocol adapter error. Then i tried logging thru the SQL Plus using (ora_88836/ora_88836) with a Host string as tree i got connected then i exited the SQL Plus. Then i tried logging in SQL Plus using (ora_88836/ora_88836) without a Host String i get the error TNSrotocol adapter error.

    Thank you!

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Set Oracle_Sid in environment variable to default to TREE
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    May 2002
    Location
    England
    Posts
    78
    The default domain is wrong...

    NAMES.DEFAULT_DOMAIN = tree.ph.enterworks.com

    should be

    NAMES.DEFAULT_DOMAIN = ph.enterworks.com

  4. #4
    Join Date
    Feb 2004
    Location
    India
    Posts
    4
    I am not sure this will solve your problem.
    Since you are getting protocol adapter error while using sqlplus without net service names, please check this..
    If you have 2 oracle homes in your machine, make the two tnsnames.ora files identical. (ORACLE_HOMEx\network\admin)
    Database Administrator
    Convergys, Hyderabad, India

  5. #5
    Join Date
    Feb 2004
    Location
    Philippines
    Posts
    9

    Wink

    Thanks guys! i did all your suggestions..it worked..

Posting Permissions

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


Click Here to Expand Forum to Full Width