ORA-00020: maximum number of processes (150) exceeded
HelloI'm using 11.2.0.3 entrerprise in linux RH 6.4(Santiago) x84-64.
There are many process "grep LOCAL=NO" created and very quickly I get ORA-00020: maximum number of processes (150) exceeded.
when I try to connect as sys into sqlplus.
It seems that the old processes are not be cleared by the system.
The "select count(*) from v$process" is encreasing continuosly until it reach the limit of 150 then I get ORA-00020 error.
What it is going on? any idea Please?
regards
Giorgio
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 9 17:45:39 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-00020: maximum number of processes (150) exceeded
There are many process "grep LOCAL=NO" created and very quickly I get ORA-00020: maximum number of processes (150) exceeded.
when I try to connect as sys into sqlplus.
It seems that the old processes are not be cleared by the system.
The "select count(*) from v$process" is encreasing continuosly until it reach the limit of 150 then I get ORA-00020 error.
What it is going on? any idea Please?
regards
Giorgio
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 9 17:45:39 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-00020: maximum number of processes (150) exceeded
0