This discussion is archived
6 Replies Latest reply: Jun 13, 2013 7:10 PM by 988817 RSS

listener in status blocked

Samuel Rabini Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points