6 Replies Latest reply: Jun 13, 2013 9:10 PM by 988817 RSS

    listener in status blocked

    Samuel Rabini

      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