Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> processes not released, got ora-00020 error

processes not released, got ora-00020 error

From: Gary YU <gary.yu_at_istark.com>
Date: 5 Nov 2001 13:36:07 -0800
Message-ID: <5483713a.0111051336.3c9716db@posting.google.com>


Hi experts,

I got some problem with the oracle processes recently, all new connection request through TNS are rejected(ora-00020 error). I checked my init<sid>.ora file, the 'process' parameter was 200, so I doubled it to 400. But I soon ran into the same problem 2 days after.

I checked v$process, there're 397 processes running, and I checked v$session, there're 40-50 sessions. It seemed that some process are not exit/released, I also checked in the Unix command line(HP UX 11.0), ' ps -ef|grep oracle', there are more than 400 process named 'oraclebvprod'(bvprod is my SID) like this:

oracle 23784 1 0 20:58:51 ? 0:00 oraclebvprod (DESCRIPTION=(LOCAL =no)(ADDRESS=(PROTOCOL=BEQ))

we are running BroadVision web-server and eGate(a middle ware) as oracle client.

my question is: should the count in v$process matches the count in v$session, and what reason may cause the process keep growing. Also what are these 'oracle<sid>' processes, and is there a safe way to manully release these process without re-bounce the oracle server.

Thanks a lot! Received on Mon Nov 05 2001 - 15:36:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US