ORA-12520: TNS:listener could not find available handler .. not resolving.
726648Oct 8 2009 — edited Oct 8 2009I am trying to resolve this strange listener problem. It resolves and soon appears again. I noticed that the database is up but the connections were not going through when logging in from outside.
ERROR:
ORA-12520: TNS:listener could not find available handler for requested type of
server
Listener is up and running.
lsnrctl services show that the service was blocked.
Service "dbtest2" has 1 instance(s).
Instance "dbtest2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:199 refused:0 state:blocked
LOCAL SERVER
The command completed successfully
I ran this in the database, bounced the database.
alter system set local_listener= '(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=1521))' scope=spfile;
Listener services show it as ready bow, connections work.... In a few minutes, I get the
ERROR:
ORA-12520: TNS:listener could not find available handler for requested type of
server
again upon connecting ...
Service "dbtest2" has 1 instance(s).
Instance "dbtest2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:12 refused:0 state:ready
LOCAL SERVER
The command completed successfully
Have you had any experiences with this error? Thanks for any answers.