Oracle 11G Startup failed after altering the number of system processes

oraclestartup

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?

Best Answer

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';

Related Solutions

Testing an Oracle DB connection before it is made – ERROR

The error is telling your user login username or password is incorrect. Remember that from 11g onwards, passwords are case sensitive.

The test & connect button tests if the entered details (TNSName, port etc) are correct & then proceeds to connect to the database. In your case, your credentials are wrong & you're getting the error message.

Oracle – How to Get Meaningful Second String in ORA-02296 Error

Provide a name for the constraint:

SQL> create table monkey(tail_count number);

Table created.

SQL> insert into monkey values (null);

1 row created.

SQL> alter table monkey modify tail_count not null;
alter table monkey modify tail_count not null
*
ERROR at line 1:
ORA-02296: cannot enable (ANIMAL.) - null values found

SQL> alter table monkey modify tail_count constraint tail_count_not_null not null;
alter table monkey modify tail_count constraint tail_count_not_null not null
                                                *
ERROR at line 1:
ORA-02296: cannot enable (ANIMAL.TAIL_COUNT_NOT_NULL) - null values found

Best Answer

Related Solutions

Testing an Oracle DB connection before it is made – ERROR

Oracle – How to Get Meaningful Second String in ORA-02296 Error

Related Question