David Dai -- Focus on Oracle

The important thing in life is to have a great aim ,and the determination to attain it!

ASM 启动报错 ORA-27300, ORA-27301 and ORA-27302: failure occurred at: sskgpsemsper 解决方法




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





[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




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 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;




Oracle Database 11g Enterprise EditionRelease - Production

PL/SQL Release - Production

CORE      Production

TNS for Linux: Version -Production

NLSRTL Version - 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










Blog:  http://www.cndba.cn/dave

Weibo:    http://weibo.com/tianlesoftware

Twitter:  http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

Linkedin: http://cn.linkedin.com/in/tianlesoftware

版权声明: https://blog.csdn.net/tianlesoftware/article/details/17084259
个人分类: Oracle Troubleshooting
上一篇Oracle INS-32025 INS-52001 解决方法
下一篇Oracle DBMS_ROWID 与 ORA-01446 说明
想对作者说点什么? 我来说一句