Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When I alter the number of system processes to 100000 and restart the database, I get the error below:

ORA-27154: post/wait create failed 
ORA-27300: OS system dependent operation:semids_per_proc failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: sskgpwcr2
ORA-27303: additional information: semids = 524, maxprocs = 100000

How can I return it to the normal processes?

share|improve this question

migrated from stackoverflow.com Aug 18 '13 at 18:25

This question came from our site for professional and enthusiast programmers.

3  
You can't just set the number of processes to any figure you like. Read this article to understand themore about the pertinent formula. h30507.www3.hp.com/t5/Database-Services-NZ/bg-p/662/label-name/… –  APC Aug 18 '13 at 13:01

1 Answer 1

up vote -1 down vote accepted

First you can try:

STARTUP NOMOUNT
ALTER SYSTEM SET processes=400;
SHUTDOWN IMMEDIATE
STARTUP

If Oracle cannot start even in NOMOUNT mode then you can fetch configuration information from spfile:

strings $ORACLE_HOME/dbs/spfile$SID.ora > /tmp/pfile

Then edit processes in /tmp/pfile cleanup some mess made by strings start Oracle with pfile and recreate spfile:

STARTUP pfile=/tmp/pfile
CREATE spfile FROM pfile='/tmp/pfile';
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.