Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00020: maximum number of processes exceeded

832104Feb 26 2013 — edited Feb 28 2013
Greetings All,

I installed Oracle 11gR2 on a new box (2008R2). I used the universal installer and created a database at that time also.

The number of processes was 150, I increased it to 250 ready. Yet I have a production box (that is being used) with processes set to 150 and I don't get the ORA-00020 error.

I run the sql below on the new box:

SELECT MACHINE, PROGRAM, COUNT(*) FROM V$SESSION
HAVING COUNT(*) > 1
GROUP BY MACHINE, PROGRAM ORDER BY 1,2;

The machine is the computer name ie. 4732##-db1 (the db1 is lower case)

The program is OMS.

The count keeps climbing till the total number of processes hits the limit. I’ve seen it as high as 215.

There is another machine listed called 4732##-DB1 (the DB1 is uppercase here however) this count does not change. The program is ORACLE.EXE and various

When I run the same SQL on my production box I get the same 2 machines (different number for the computer name) yet the lower case machine lists only 5. The upper case machine seems to range from 31 to 44-46 only


The production DB is being used. The new box has no one on it.

I have read many other posts on this forum that say to keep increasing the value until the error stops. I can’t accept this as a solution because our production box which is being used isn’t having this issue.

Thanks for your time,
Bob
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2013
Added on Feb 26 2013
8 comments
2,586 views