Troubleshooting ORA-27154 ORA-27300 ORA-27301 ORA-27302
来源:互联网 发布:java 反射 注解 编辑:程序博客网 时间:2024/05/17 23:38
Troubleshooting 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> !oerr ora 27154
27154, 0000, "post/wait create failed"
// *Cause: internal error, multiple post/wait creates attempted simultaneously
// *Action: check errno and contact Oracle Support
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 = 250 100
注意上面的最后一个参数kernel.sem = 250 100这个不正常的值,现在把这个参数该成正常值。
[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>
吼吼,起来了!
-The End-
这个错误是操作系统设置的问题,测试过程如下。
[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> !oerr ora 27154
27154, 0000, "post/wait create failed"
// *Cause: internal error, multiple post/wait creates attempted simultaneously
// *Action: check errno and contact Oracle Support
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 = 250 100
注意上面的最后一个参数kernel.sem = 250 100这个不正常的值,现在把这个参数该成正常值。
[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>
吼吼,起来了!
-The End-
- Troubleshooting ORA-27154 ORA-27300 ORA-27301 ORA-27302
- ORA-27300 ORA-27301 ORA-27302
- ORA-27300,ORA-27301,ORA-27302
- 在启动DB时报错ORA-27154 ORA-27300 ORA-27301 ORA-27302
- oracle启动的时候报 ORA-27154、ORA-27300、ORA-27301、ORA-27302
- oracle启动的时候报 ORA-27154、ORA-27300、ORA-27301、ORA-27302
- 数据库启动报ORA-27154 ORA-27300 ORA-27301 ORA-27302错误
- dbca建库时遭遇ORA-27154 ORA-27300 ORA-27301 ORA-27302解决方法
- ORA
- ora
- ORA-27300 ORA-27301 ORA-27302: failure occurred at: skgpalive1
- ORA-27300, ORA-27301, ORA-27302错误处理
- 记一次ORA-27300、ORA-27301、ORA-27302错误解决
- Troubleshooting ORA-27300 ORA-27…
- ORA-27300,ORA-27301,ORA-27302,ORA-04030导致crashed database
- ORA-27300,ORA-27301,ORA-27302,ORA-27303导致实例宕的问题分析
- TROUBLESHOOTING GUIDE (TSG) - ORA-1555
- 从ORA-27300,ORA-27301到ORA-00064
- Configure,Makefile.am, Makefile.in, Makefile文件之间
- Steps To Create A New Project in Github
- 凹凸贴图简析(应景之作--写给美术朋友们的凹凸贴图白皮书)
- 【DFS】ZOJ 1580 Sudoku
- 解读新加坡医疗SOA应用
- Troubleshooting ORA-27154 ORA-27300 ORA-27301 ORA-27302
- XML 校验器
- VirtualBox 学习 - 高级课题2 - 自动系统配置
- 医疗行业虚拟化终端管理平台解决方案
- 电子病历编辑器要求
- metro app get json data 文章参考
- 集成医疗保健服务,第 1 部分
- mac 打开和隐藏 系统文件
- LVS & realserve 启动脚本