Hi,
I'm working on an
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
With the Real Application Clusters option.
I've 2 serivces, IPGW running on node 1 (EVODB1) and EVOREAD running on node 2 (EVODB2).
During last few days I'm experiencing a service block state:
{code}
Instance "EVODB2", status READY, has 2 handler(s) for this service...
Handler(s):
"N000" established:669 refused:0 current:679 max:679 state:blocked
CMON <machine: dcsrv-evodb02, pid: 26749>
(ADDRESS=(PROTOCOL=tcp)(HOST=dcsrv-evodb02.altea.net)(PORT=20836))
"DEDICATED" established:118 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=dcsrv-evodb02-vip.altea.net)(PORT=1521))
Service "EVOREAD" has 1 instance(s).
Instance "EVODB2", status READY, has 3 handler(s) for this service...
Handler(s):
"N000" established:695 refused:0 current:679 max:679 state:blocked
CMON <machine: dcsrv-evodb02, pid: 26749>
(ADDRESS=(PROTOCOL=tcp)(HOST=dcsrv-evodb02.altea.net)(PORT=20836))
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=dcsrv-evodb02-vip.altea.net)(PORT=1521))
"DEDICATED" established:1483 refused:0 state:ready
LOCAL SERVER
{code}
Reading into the web I read that could be due to to less values of sessions and processes parameter. Their values are:
NAME TYPE VALUE
------------ -------------- -----------------
sessions integer 885
processes integer 800
Higer than 679.
Where's that value? What should I reaise to avoid to happens again?
Thanks in advance,
Samuel