1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

TNS-12560: TNS:protocol adapter error

Discussion in 'Server Administration and Options' started by jay_pink_elephant, Apr 8, 2009.

  1. jay_pink_elephant

    jay_pink_elephant Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    55
    i am getting error in starting service tnslistner80
    Code (Text):

    tnslsnr80 generated erros u need to restart ur program
     
    following is the error log from cmd prompt when i started the listener
    Code (Text):

    LSNRCTL> start
    Starting tnslsnr80: please wait...

    Service OracleTNSListener80 start pending.
    Failed to start service, error 997.
    TNS-12560: TNS:protocol adapter error
    TNS-00530: Protocol adapter error
    32-bit Windows Error: 61: Unknown system error
     
    please advice

    regards
     
  2. simply_dba

    simply_dba Forum Advisor

    Messages:
    95
    Likes Received:
    5
    Trophy Points:
    140
    Location:
    Kolkata, India
    Restart the server and start the service from service control panel.
     
  3. jay_pink_elephant

    jay_pink_elephant Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    55
    yes i restarted the server and it is working now, thank you.

    any idea why this happened suddenly?
     
  4. simply_dba

    simply_dba Forum Advisor

    Messages:
    95
    Likes Received:
    5
    Trophy Points:
    140
    Location:
    Kolkata, India
    Error 997 is a typical windows error. (google it and you'll know). Oracle can't do much about it, so restart (as in case of all other windows errors :) )
     
  5. Arju

    Arju Forum Expert

    Messages:
    107
    Likes Received:
    5
    Trophy Points:
    240
    Location:
    Bangladesh
    Post the output of ,
    lsnrctl status