ORA-27033:additional information:maxsems = 4004,verify_semcnt = 0 解决办法
来源:互联网 发布:带着淘宝混异世 编辑:程序博客网 时间:2024/05/29 04:00
今天在一个 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
- ORA-27033:additional information:maxsems = 4004,verify_semcnt = 0 解决办法
- 删除 theme508 Additional Information
- VS2010 no additional information available troubleshooting intellisense
- Security Tutorials系列文章第八章:Storing Additional User Information
- Storing Additional User Information in membership db - ASP.NET
- SQL server 2005 无法连接到 additional information
- the server did not provide any additional information
- JAR creation failed. See details for additional information解决方案
- JAR creation failed. See details for additional information解决方案
- JAR creation failed. See details for additional information
- JAR creation failed. See details for additional information解决方案大全
- JAR export finished with warnings. See details for additional information
- JAR creation failed. See details for additional information解决方案大全
- additional
- 【ORA】ORA-16629解决办法
- “Additional information: 您必须有许可证才能使用此 ActiveX 控件”的错误解决方法
- Additional information: A potentially dangerous Request.Form value was detected from the client
- oracle 11g RAC start crs 失败 CLSU-00104: additional error information: no exe permission
- A Game
- 基于Java Mina 通信框架的JT/T809转发服务器设计
- Android 4.0之后的网络连接
- GIS、GPS监控界面设计
- 转:ACPI规范阅读笔记
- ORA-27033:additional information:maxsems = 4004,verify_semcnt = 0 解决办法
- 解决win7类系统远程桌面反应慢的问题
- ObjectiveC - 类的声明和实现(二)
- HTML5的最简单模板
- 简单易用的jquery表单验证-EasyValidator
- jquery 实现原理九:css
- 设置Android设备按Power按键不休眠
- 浅谈CSRF攻击方式(上)
- 使用SVCUTIL生成客户端代理类时:元数据包含无法解析的引用:“https: 无法为 SSL/TLS 安全通道与颁发机构“localhost”建立信任关系。基础连接已经关闭: 未能为 SSL/TL