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

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

  1. #1
    Join Date
    Sep 2013
    Posts
    1

    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
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

  3. #3
    Join Date
    Oct 2013
    Posts
    1
    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'
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = mu-me01-ns-isc003)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = MISC)
    )
    )
    check the server name it ll be clear

  4. #4
    Join Date
    Oct 2013
    Posts
    1
    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