DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2013

    ORA-12520: TNS:listener could not find available handler for

    ORA-12520: TNS:listener could not find available handler for requested type of server

  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    That isn't very much information. You might have added more lines from the listener.log, the server OS, version of oracle, etc. I'm guessing that someone, possibly you, is trying to connect to a listener looking for a database that the listener is not configured to listen for. However, I can't be sure. Perhaps you could post more information about what you are trying to do.
    this space intentionally left blank

  3. #3
    Join Date
    Oct 2013
    do the following steps;
    1. Verified tnspingracle@cn-me01-ns-isc003$tnsping MISC
    2. Checked sqlplus @/
    if you find error then go n check Tnsnames.ora in must be in the given format
    ORA'database name'
    (ADDRESS = (PROTOCOL = TCP)(HOST = mu-me01-ns-isc003)(PORT = 1521))
    check the server name it ll be clear

  4. #4
    Join Date
    Oct 2013
    paste the contents of listener.ora file and also check all the database services are registered with 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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.