Hi,
I don't really have Oracle background. I'm using Oracle 9i. May I know how to increase maximum number of processes? I need to increase it to 400. I got this ORA-00020: maximum number of processes (150) exceeded. Thanks.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
hmm, now i've checked http://download-uk.oracle.
1.
try alter system set processes=200 scope=spfile and restart database
or if doesn't work
2.
create pfile from spfile
edit pfile, chnge value of processes
create spfile from pfile
shutdown
rename created spfile to actual spfile which will be used at startup
startup
check details how to create pfile, spfile:
http://download-uk.oracle.
http://download-uk.oracle.
http://download-uk.oracle.
Hi rospcc,
Let me try to be as simple as possible.
This parameter is not modifiable online. So a database restart is required for this change to be effected.
Your database could have either been running with the pfile (a text file) or an spfile (binary file) as the base.
First find out how your database has been started:
SQL> show parameter spfile;
If you get the path of the spfile in the output, then the db is running with an spfile. Else, it has been started with a pfile
I. If using an spfile:
SQL> alter system set processes=500 scope=spfile;
SQL> shutdown immediate;
Login again
SQL> startup;
2. If not using an spfile:
Locate the pfile. The default location of the pfile is:
Under windows : $ORACLE_HOME\database
Under Unix/Linux: $ORACLE_HOME/dbs
The name of the pfile is usually of the form init<database SID>.ora
Edit the processes parameter to 500
Login to SQL as sysdba
SQL> shutdown immediate
Login again
SQL> startup pfile ='<path to your pfile>'
Finally verify the current value of the parameter by,
SQL> show parameter processes.
Be sure to modify the sessions parameter aslo to a value equal to: (1.1*processes)+5
This is a thumb rule, your requirements could vary though.
Thats it !
Regards,
Ganesh
Business Accounts
Answer for Membership
by: konektorPosted on 2007-10-14 at 23:40:12ID: 20076324
connect as user with DBA privileges
SQL> conn / as sysdba
SQL> alter system set processes = 200 scope=both
using "scope=both" in "alter system" command means, that system variable is changed immediately and is written to spfile - the value will remain as you have changed across oracle sthutdown and startup