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

今天在一个 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.

转载请注明作者出处及原文链接，否则将追究法律责任：
作者：xiangsir
原文链接：http://blog.csdn.net/xiangsir/article/details/13769995
QQ：444367417
MSN：xiangsir@hotmail.com