ORA-12520: TNS:listener could not find available handler for requested type of server
Printable View
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.
do the following steps;
1. Verified tnsping:oracle@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
paste the contents of listener.ora file and also check all the database services are registered with the listener.