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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORACLE.EXE (SHAD) process causing ORA-00020: maximum number of processes

MSandicoMay 23 2013 — edited May 23 2013

Hi All,

Oracle 11g R2 on WIndows 20o8 R2 Standard edition

I have a test server that keeps running into ORA-00020: maximum number of processes error each night. Our current setting is '600' processes to be allowed. There are no users to this database except myself. No front end app connects to it either.

I found that ORACLE.EXE (SHAD) process coming from SYSMAN user is the one eating up all the processes and eventually causing that error.

From v$session, the program is OMS.

From v$process, the hostname is the server itself.

I narrowed it down to restarting the ConsoleService, if i do that, then the number of processes drops down. So now im not sure why something within the ConsoleService is logging in, taking a process and not releasing it...any idea what i can check?

Any help is appreciated, thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 20 2013

Added on May 23 2013

#general-database-discussions

3 comments

4,288 views