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

[jalgarroba]

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

[gandolf989]

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.

[abhijit sen]

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

[Amitava Roy]

paste the contents of listener.ora file and also check all the database services are registered with the listener.