-
ORA-00020: maximum number of processes (%s) exceeded
Hi,
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.
Thanks
Sathidevi
-
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
Step-1
Create pfile= /oracle/.... from spfile
Step 2
Shutdown database
Step-3
Amend that pfile and increase the number of processes
Step -4
startup the database with new pfile
startup pfile='/oracle/....'
Step-5
Create spfile from pfile='/otacle/....'
So that when you startup database next time it will read spfile (new)
Best of luck.
Regards
-
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
-
Originally Posted by davey23uk
there is no need, Mr Mahsnj doesnt appear to know fully what to do here
I have clearly mentioned these steps are to increase the number of process in init.ora file.
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
-
Originally Posted by mahsnj
Beacuse you can not change parameter called process by alter system
Don't be silly, of course you can change it directly in spfile!
Code:
Connected to:
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;
System altered.
SQL>
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Originally Posted by jmodic
Don't be silly, of course you can change it directly in spfile!
Code:
Connected to:
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;
System altered.
SQL>
Your are right I was missing scope=Spfile
SQL> alter system set processes=150;
alter system set processes=150
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|