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

Thread: ORA-12516 TNS:listener could not find available handler with matching protocol stack

  1. #1
    Join Date
    Oct 2005
    Posts
    90

    ORA-12516 TNS:listener could not find available handler with matching protocol stack

    How to fix this problem,I am able to connect locally no users are able to connect using tnsentry ,here is the lsnrctl service output.
    Instance "MSBI2", status READY, has 2 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:46 refused:0 state:blocked
    output of lsnrctl status
    Service "MSBI" has 2 instance(s).
    Instance "MSBI1", status READY, has 1 handler(s) for this service...
    Instance "MSBI2", status READY, has 2 handler(s) for this service...
    Service "MSBI_XPT" has 2 instance(s).
    Instance "MSBI1", status READY, has 1 handler(s) for this service...
    Instance "MSBI2", status READY, has 2 handler(s) for this service...
    Thanks in advance

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    post the listener.ora and the tnsnames file

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    delete the *.dat found in $ORACLE_HOME\otrace directory.
    restart the listener.
    ---------------

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