ORA-12520: TNS:listener could not find available handler for
ORA-12520: TNS:listener could not find available handler for requested type of server
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
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
(ADDRESS = (PROTOCOL = TCP)(HOST = mu-me01-ns-isc003)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = MISC)
check the server name it ll be clear
paste the contents of listener.ora file and also check all the database services are registered with the listener.
Click Here to Expand Forum to Full Width