oracle实例启动错误 环境 oracle 11g linux
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: sskgpbitsper
查看当前信号量参数设置
$ sysctl kernel.sem
kernel.sem = 250 32000 100 200
$ ipcs -su
------ Semaphore Status --------
used arrays = 196
allocated semaphores = 31642
当前信号量使用196已接近200，修改参数 kernel.sem = 250 64000 100 256 之后，数据库成功启动
附带mos上相关参数介绍
kernel.sem = <semmsl> <semmns> <semopm> <semmni>
1. Calculate the minimum total semaphore requirements using the following formula
2 x sum(processes parameter of all database instances on the system) + overhead for background processes + system and other applications
2. Set semmns (total semaphores systemwide) to this total
3. Set semmsl (semaphores for each set) to 250
4. Set semmni (total semaphore sets) to semmns divided by semmsl, rounded up to the nearest multiple of 1024.
