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

Thread: ORA-12560: TNS:protocol adapter error

  1. #1
    Join Date
    Jul 2003
    Posts
    136

    Question ORA-12560: TNS:protocol adapter error

    Environment: Windows 2000, Oracle 8.1.6

    We had this windows 2000 server/oracle database working fine. Now I found my oracleServiceDbname stoped and listener service also stopped and are not starting - Message I am getting is 'Access is denied'. I/IT have full access and both get the same message.

    I tried to login from svrmgrl getting getting this protocal adapter error.

    C:\Documents and Settings\singhd>set ORACLE_SID=gen0301p
    C:\Documents and Settings\singhd>svrmgrl

    Oracle Server Manager Release 3.1.7.0.0 - Production
    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    ORA-12560: TNSrotocol adapter error
    SVRMGR> connect internal
    Password:
    ORA-12560: TNSrotocol adapter error

    My sqnet.ora looks like:
    ----------

    #NAMES.DEFAULT_DOMAIN = araccel.com

    SQLNET.AUTHENTICATION_SERVICES= (None)

    USE_DEDICATED_SERVER = ON

    NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, ONAMES, HOSTNAME, NIS, DCE)

    Listener.ora:
    -----------

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

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = F:\oracle\ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = dbname.domain_name)
    (ORACLE_HOME = F:\oracle\ora81)
    (SID_NAME = dbname)
    )
    )


    Please help.

    -D

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You will allways get this error (12560) if your database service is not running. You must first start the service before you are able to connect to that instance (even to an idle one) with svrmgrl.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jul 2003
    Posts
    136
    Originally posted by jmodic
    You will allways get this error (12560) if your database service is not running. You must first start the service before you are able to connect to that instance (even to an idle one) with svrmgrl.
    Oracle service and TNSlistner service both are starting now but still get the same error from within svrmgrl
    ORA-12560: TNSrotocol adapter error

    I get this error when trying to connect using sqlplus (server or client)
    ORA-12537: TNS:connection closed

    Here is the staus of listener:
    ------------------------------

    LSNRCTL> services
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usc1-as04)(PORT=1521)))
    Services Summary...
    PLSExtProc has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
    LOCAL SERVER
    gen0301p has 1 service handler(s)
    DEDICATED SERVER established:2 refused:0
    LOCAL SERVER
    gen0301p has 2 service handler(s)
    DEDICATED SERVER established:1 refused:0
    LOCAL SERVER
    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
    D000
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=usc1-as04.araccel.com)(PORT=1093
    ))(PRESENTATION=oracle.aurora.server.SGiopServer)(SESSION=RAW))
    Presentation: oracle.aurora.server.SGiopServer
    The command completed successfully

  4. #4
    Join Date
    Feb 2003
    Posts
    40
    Check the permission of the user who is passing set command.
    either spelling should be wrong ,or it will be the permission problem

    Login as the user who has the ORA_DBA privilege and set the ORACLE_SID
    K.Chithra
    Oracle DBA

  5. #5
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    On WINDOWS,
    Try this
    net stop oracleservice
    net start oracleservice

    Then check lsnrctl status, listerener should be UP

    Then check svrmgrl

    it should connect

    regards
    anandkl
    anandkl

  6. #6
    Join Date
    Jul 2003
    Posts
    136
    Originally posted by k.chithra
    Check the permission of the user who is passing set command.
    either spelling should be wrong ,or it will be the permission problem

    Login as the user who has the ORA_DBA privilege and set the ORACLE_SID
    I have the ORA_DBA privilege and spelling seems correct. Which spelling specifically you are talking. Any more suggestion. Please help.

  7. #7
    Join Date
    Jul 2003
    Posts
    136
    Originally posted by anandkl
    On WINDOWS,
    Try this
    net stop oracleservice
    net start oracleservice

    Then check lsnrctl status, listerener should be UP

    Then check svrmgrl

    it should connect

    regards
    anandkl
    ---------------

    Tried all that. Didn't help.
    Any more suggestion. Please help.

    -D

  8. #8
    Join Date
    May 2001
    Posts
    73
    Comment out SQLNET.AUTHENTICATION_SERVICES= (None) in the sqlnet.ora and give a try.
    OCP 7.3,8.0,8i,9i

  9. #9
    Join Date
    Jul 2003
    Posts
    136
    Thanks guys for all your help/suggestions.

    It came out to be a DNS issue - some how stopped resolving the server name. Changed it to localhost and it picked up.

    Thanks again.

    -Daljit

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