本文主要是介绍oracle max(0 ),ORA-27033:additional information:maxsems = 4004,verify_semcnt = 0解决办法-Oracle，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
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.
这篇关于oracle max(0 ),ORA-27033:additional information:maxsems = 4004,verify_semcnt = 0解决办法-Oracle的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
