转载

ORA-27154,ORA-27300,ORA-27301,ORA-27302: failure occurred at: sskgpcreates

Linux 6.5 , Oracle 11.2.0.4 , 12c GI . 

使用EM 12c DB Cloud自助创建数据库的时候,  数据库创建完成,在开启步骤时报错,报错信息如下:  
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

看提示,会误以为是磁盘空间不足 (No space left on device), 但是仔细看最后的提示(一般报错最后的错误才是根源), 发现是信号量参数设置问题。 

调整了下/etc/sysctl.conf,修改kernel.sem为
kernel.sem =250 32000 100 128
修改为
kernel.sem =250 32000 100 300 

问题解决。 


正文到此结束
Loading...