代码改变世界

ORA-27300 ORA-27301 ORA-27302 sskgpcreates

2019-01-29 10:02  WWJD_DBA  阅读(514)  评论(0)  编辑  收藏  举报

1、环境信息

OS:SUSE 12SP3
DB:12.2.0.1.0

2、数据库启动失败

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

3、MOS

诊断 ORA-27300 ORA-27301 ORA-27302 错误 (文档 ID 2179478.1)

4、调整主机参数

vim /etc/sysctl.conf
kernel.sem = 250 32000 100 128       >>>>>>>>>>>>> kernel.sem = 250 32000 100 200

sysctl -p

5、正常启动数据库