ORA-27033:additional information:maxsems = 4004,verify_semcnt = 0解决办法

ORA-27033:additional information:maxsems = 4004,verify_semcnt = 0解决办法

 

ORA-27154ORA-27300ORA-27301ORA-27302ORA-27303

今天在一个 RAC 上创建 RAC one node 数据库时遇到如下错误：

 

 

 

 

费尽一般周折在网上和MOS上找来找去，发现这个错误代码的原因很多，从 ORA-27302 的输出可以区别，本例是由于内核参数中

kernel.sem 值太小，导致无法操作系统无法分配更多的空间来启动建库时要启动的进程。

改大即解决。

 

[root@slcah434 ~]# sysctl -p | grep sem
kernel.sem = 250 72000 256 512
----------------------------------------
[root@slcah434 ~]# sysctl -p | grep sem
kernel.sem = 250 96000 256 512

 

关于 sem 参数

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, SEMMNI should be twice the maximum number of connections allowed (MAXAGENTS) multiplied by the number of logical partitions on the database server computer plus the number of local application connections on the database server computer.