Database failed to start ORA-27154, 27300,27301, 27302

 

Database Version

SQL> select * from V $ version

2;

 

Banner

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition release11.2.0.1.0-64bit Production

PL/SQL release 11.2.0.1.0-Production

Core 11.2.0.1.0 Production

TNS for Linux: Version 11.2.0.1.0-Production

Nlsrtl version 11.2.0.1.0-Production

 

 

Startup Error

Connected to an idle instance.

SQL> startup

ORA-27154: Post/Wait create failed.

ORA-27300: OS system dependent operation: semget failedwith status: 28

ORA-27301: OS failure message: no space left on Device

ORA-27302: failure occurred at: sskgpsemsper

 

 

Solution:

[Oracle @ shadow ~] $ Vim/proc/sys/kernel/SEM

[Oracle @ shadow ~] $ Su-Root

Password:

[Root @ shadow ~] # Echo "110 10000 100 128">/proc/sys/kernel/SEM

[Root @ shadow ~] # Exit

Logout

 

 

Is the problem solved?

SQL> select status from V $ instance;

 

Status

------------

Open

 

Note:

 

[Oracle @ shadow ~] $ CAT/proc/sys/kernel/SEM

110 10000 100 128

 

The preceding four data types correspond

Semmsl semmns semopm semmni

 

Semms L 100 defines the minimum recommended value,

For initial installation only

 

Semmns 256 defines the maximum semaphores on thesystem.

This setting is a minimum recommended value,

For initial installation only. The semmns Parameter

Shocould be set to the sum of the processes Parameter

For each Oracle database, adding the largest onetwice,

And then adding an additional 10 for each database.

 

Semopm 100 defines the maximum number of operationsfor each semop call

 

Semmni 100 defines the maximum number ofsemaphore sets in the entire system