ASM 启动报错 ORA-27300, ORA-27301 and ORA-27302: failure occurred at: sskgpsemsper 解决方法
来源:互联网 发布:unity3d spine2d插件 编辑:程序博客网 时间:2024/05/17 22:11
运维班里一学生做实验,启动ASM实例,结果报错如下:
SQL> startup
ORA-27154: post/wait create failed
ORA-27300: OS system dependentoperation:semget failed with status: 28
ORA-27301: OS failure message: No spaceleft on device
ORA-27302: failure occurred at:sskgpsemsper
OS:Redhat 5.6
OS:11.2.0.1
--查看磁盘信息:
[root@lab01 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 27G 11G 15G 43% /
tmpfs 506M 0 506M 0% /dev/shm
该问题存在与11.2.0.1 之后的版本,导致的原因是因为semmns 的值太低。 该值在/etc/sysctl.conf中配置。
格式如下:
sem = semmsl semmns semopm semmni
kernel.sem = 256 32768 100 228
semaphores 参数的优化原则如下:
1. Calculate the minimum total semaphorerequirements using the following formula:
2*sum (process parameters of all databaseinstances on the system) + overhead for background processes + system and otherapplications.
2. Set semmns (total semaphores systemwide)to this total.
3. Set semmsl (semaphores for each set ) to256
4. Set semmni (total semaphores sets) tosemmns devided by semmsl, rounded up to the nearest multiple of 1024
因此该问题的解决方法就是在/etc/sysctl.conf文件中替换kernel.sem为如下值:
kernel.sem = 256 32768 100 228
--顺便查了一下我自己的测试环境,这个是Oracle preinstall设置的值:
[oracle@dave ~]$ cat /etc/sysctl.conf|grepsem
# oracle-rdbms-server-11gR2-preinstallsetting for kernel.sem is '250 32000 100 128'
kernel.sem = 250 32000 100 128
修改之后,成功启动:
[grid@lab01 dbs]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production onTue Dec 3 06:53:50 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 284565504 bytes
Fixed Size 1336036 bytes
Variable Size 258063644 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
===========================================================
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise EditionRelease 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 -Production
NLSRTL Version 11.2.0.1.0 - Production
------------------------------------------------------------
[grid@lab01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE lab01
ora.FRA.dg ora....up.type ONLINE ONLINE lab01
ora....ER.lsnr ora....er.type ONLINE ONLINE lab01
ora.asm ora.asm.type ONLINE ONLINE lab01
ora.cssd ora.cssd.type ONLINE ONLINE lab01
ora.diskmon ora....on.type ONLINE ONLINE lab01
ora.lab01.db ora....se.type ONLINE ONLINE lab01
--------------------------------------------------------------------------------------------
版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!
QQ: 251097186
Skype: tianlesoftware
Email: tianlesoftware@gmail.com
Blog: http://blog.csdn.net/tianlesoftware
Weibo: http://weibo.com/tianlesoftware
Twitter: http://twitter.com/tianlesoftware
Facebook: http://www.facebook.com/tianlesoftware
Linkedin: http://cn.linkedin.com/in/tianlesoftware
- ASM 启动报错 ORA-27300, ORA-27301 and ORA-27302: failure occurred at: sskgpsemsper 解决方法
- ASM 启动报错 ORA-27300, ORA-27301 and ORA-27302: failure occurred at: sskgpsemsper 解决方法
- ORA-27300 ORA-27301 ORA-27302: failure occurred at: skgpalive1
- ORA-27302: failure occurred at: skgpspawn3
- ASM实例启动报错:ORA-29701、ORA-15110解决方案
- 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错误
- 在启动DB时报错ORA-27154 ORA-27300 ORA-27301 ORA-27302
- ORA-27302: failure occurred at: skgpspawn3 可能的原因及处理
- ORA-09817,ORA-01075报错解决方法
- 数据库启动报错ORA-27154,27300,27301,27302
- Oracle 报错:ORA-00313、ORA-00312、ORA-27047 解决方法
- ASM创建文件报错:ORA-01119 ORA-15045 ORA-17502 ORA-15081
- ORA-27300 ORA-27301 ORA-27302
- ORA-27300,ORA-27301,ORA-27302
- 添加ASM磁盘报错ORA-02097和ORA-15014
- dbca建库时遭遇ORA-27154 ORA-27300 ORA-27301 ORA-27302解决方法
- 堆排序的本质
- 时间序列分析之六:应用
- http://ranfeng0610.blog.163.com/blog/static/185708284201251524110617/
- 斜杠与反斜杠
- ZOJ 3736 Pocket Cube
- ASM 启动报错 ORA-27300, ORA-27301 and ORA-27302: failure occurred at: sskgpsemsper 解决方法
- ActionBar上添加UI
- 菜鸟学SSH(四)——Struts2拦截器
- JUnit4 学习总结
- java自学笔记之抽象类,接口,对象的多态性,instanceof关键字
- Android adb命令,linux中各种命令
- hdu 2255KM算法模板
- cellpadding与cellspacing的区别
- 动态规划:E - Largest Rectangle in a Histogram(即HDU 1506)