数据库无法启动 ORA-27154,27300,27301,27302

 

数据库版本

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

 

 

启动错误

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

 

 

解决办法:

[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

 

 

问题是否解决

SQL> select status from v$instance;

 

STATUS

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

OPEN

 

说明:

 

[oracle@shadow ~]$ cat /proc/sys/kernel/sem

110    10000   100     128

 

以上4个数据分别对应

SEMMSL SEMMNS SEMOPM SEMMNI

 

SEMMSL 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

should 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