今天刚装了Oracle 11g,配制好了之后启动数据库时遇到下面的错误:
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
相关阅读:
SPFILE 错误导致数据库无法启动(ORA-01565) http://www.linuxidc.com/Linux/2013-08/88932.htm
ORA-01172、ORA-01151错误处理 http://www.linuxidc.com/Linux/2013-06/86529.htm
ORA-00600 [2662]错误解决 http://www.linuxidc.com/Linux/2013-06/86528.htm
ORA-01078 和 LRM-00109 报错解决方法 http://www.linuxidc.com/Linux/2012-07/66044.htm
更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12