在启动DB时报错ORA-27154 ORA-27300 ORA-27301 ORA-27302

在启动DB时报错ORA-27154 ORA-27300 ORA-27301 ORA-27302

这个错误是内核参数设置的问题,测试过程如下。
[oracle@gtlions ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.5.0 - Production on Sat Feb 4 23:47:02 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

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: sskgpsemsper
SQL> 



[root@gtlions ~]# /sbin/sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 2
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 268435456
fs.aio-max-nr = 1048576
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
kernel.sem = 25032000100128

注意上面的最后一个参数kernel.sem = 25032000100128这个值看似很正常的,实际上是有问题的,我测试了修改为下面正常的值后OK,它值与值之间有空格标记的

[root@gtlions ~]# vi /etc/sysctl.conf
[root@gtlions ~]# /sbin/sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 2
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 268435456
fs.aio-max-nr = 1048576
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
kernel.sem = 250 32000 100 128
[root@gtlions ~]#

来看下是否可以正常启动数据库了。
[oracle@gtlions ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.5.0 - Production on Sun Feb 5 00:00:39 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size            1272600 bytes
Variable Size           62915816 bytes
Database Buffers      100663296 bytes
Redo Buffers            2920448 bytes
Database mounted.
Database opened.
SQL>

阅读更多
上一篇Oracle全面优化:如何对Oracle进行系统的全面优化?
下一篇利用emca创建database control
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭