AI智能
改变未来

ORA-27154: post/wait create failed

今天启动数据库报错:

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

赞(0) 打赏
未经允许不得转载:爱站程序员基地 » ORA-27154: post/wait create failed