HOW INCREASE PROCESS INITIALIZATION PARAMETER
623156Apr 10 2008 — edited Apr 10 2008Hello everybody.
After starting a standar procedure I get the following error: ORA-00020 maximum number of processes exceeded. The PROCESS PARAMETER's value in the v$parameter is set to 150. I need to increase it to 300 but i don't know how. I tried as follow from SQLPLUS:
show parameter processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
processes integer 150
SQL> select count(*) from v$process;
COUNT(*)
----------
149
SQL> alter system set processes=300 scope=spfile;
alter system set processes=300 scope=spfile
*
ERRORE alla riga 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup
but it doesn't work. Can anyone help me in this please?
i'm working on 9.i release.
Thanks in advance.