今天启动数据库报错:
SQL> startup
ORA-27154: post/wait create failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpcreates
看了一下文档,ORA-2715是这么解释的:
ORA-27154: post/wait create failed
Cause: internal error, multiple post/wait creates attempted simultaneously
Action: check errno and contact Oracle Support
上网找了一些资料后,调整了下/etc/sysctl.conf,修改kernel.sem为
kernel.sem =5010 641280 5010 128
使它生效
#sysctl -p
再次启动就正常了
SQL> startup
ORACLE instance started.
Total System Global Area 1536602112 bytes
Fixed Size 2213616 bytes
Variable Size 1040189712 bytes
Database Buffers 486539264 bytes
Redo Buffers 7659520 bytes
Database mounted.
Database opened.
SQL> select open_mode from v$database;
OPEN_MODE
——————–
READ WRITE
Elapsed: 00:00:00.01