解决ORA-27154，ORA-27300，ORA-27301：No space left on device

利用DBCA创建数据库，重启数据库，都可能会出现此类错误,主要原因可能是数据库实例太多，需要比较多的信号量

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: sskgpcreates

解决的办法就是利用 root 登陆修改 Linux 内核参数

 

[root@linuxserver ~]# /sbin/sysctl -a | grep sem
kernel.sem = 250 1024 100 128

[root@linuxserver ~]# vi /etc/sysctl.conf

# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128

然后执行命令
/sbin/sysctl -p

下面一段是关于一点关于信号量的系统参数的解释：

The kernel parameter sem consists of 4 tokens, SEMMSL, SEMMNS, SEMOPM and SEMMNI. SEMMNS is the result of SEMMSL multiplied by SEMMNI. The database manager requires that the number of arrays (SEMMNI) be increased as necessary. Typically, S