ORA-00020: maximum number of processes (%s) exceeded
I got this error. How do I get out of this. I am not able to get a new connection, so I cannot increase the processes in init.
Pl. advice me.
a) learnt to post in the right forum
b) what version? you dont need a connection to update the init.ora file
c) stop other connections if you want to get a connect
To Increase the number of process
Create pfile= /oracle/.... from spfile
Amend that pfile and increase the number of processes
startup the database with new pfile
Create spfile from pfile='/otacle/....'
So that when you startup database next time it will read spfile (new)
Best of luck.
what is wrong with alter system scope=spfile?
why create a pfile???
there is no need, Mr Mahsnj doesnt appear to know fully what to do here
Beacuse you can not change parameter called process by alter system
I have clearly mentioned these steps are to increase the number of process in init.ora file.
Originally Posted by davey23uk
To get rid of connections I think she will have to kill connections so that application can make new connections.and this also calls for Increase of number of process in init.ora file
ANY suggestion DAVEY23UK SIR
Don't be silly, of course you can change it directly in spfile!
Originally Posted by mahsnj
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter system set processes=150 scope=spfile;
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Your are right I was missing scope=Spfile
Originally Posted by jmodic
SQL> alter system set processes=150;
alter system set processes=150
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
Click Here to Expand Forum to Full Width