Listener in state blocked
Hi,
I'm working on an Oracle Database 11g Release 11.1.0.6.0 - 64bit Production With the Real Application Clusters option.
Few mins ago I go from my web app the
ORA-12520: TNS:listener could not find available handler for requested type of server
Checking the service, it seemed online, but the lsnrctl service showed it as blocked:
Service "EVOREAD" has 1 instance(s).
Instance "EVODB2", status READY, has 3 handler(s) for this service...
Handler(s):
"N000" established:673 refused:0 current:679 max:679 state:blocked
CMON <machine: dcsrv-evodb02, pid: 21517>
(ADDRESS=(PROTOCOL=tcp)(HOST=dcsrv-evodb02.altea.net)(PORT=18577))
"DEDICATED" established:697 refused:0 state:blocked
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=dcsrv-evodb02-vip.altea.net)(PORT=1521))
"DEDICATED" established:2586 refused:0 state:blocked
LOCAL SERVER
I noticed that current session reached the max level.
I suppos this is the reason why it has been blocked.
Where I can see/set that limit (session per service)?
Thanks in advance,
Samuel