ORA-27154: post/wait create failed
今天启动数据库报错:
SQL> startup
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
看了一下文档,ORA-2715是这么解释的:
ORA-27154: post/wait create failed
Cause: internal error, multiple post/wait creates attempted simultaneously
Action: check errno and contact Oracle Support
上网找了一些资料后,调整了下/etc/sysctl.conf,修改kernel.sem为
kernel.sem =5010 641280 5010 128
使它生效
#sysctl -p
再次启动就正常了
SQL> startup
ORACLE instance started.
Total System Global Area 1536602112 bytes
Fixed Size 2213616 bytes
Variable Size 1040189712 bytes
Database Buffers 486539264 bytes
Redo Buffers 7659520 bytes
Database mounted.
Database opened.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
Elapsed: 00:00:00.01
如果文章对你有帮助,请赞赏
赞赏
0人进行了赞赏支持
更多相关文章
- ack 挂载nas-pvc报错 mount: wrong fs type bad option
- 对linux配置文件的处理----grep&sed
- MySQL5.6 myisam表修复
- 超级简单的应用虚拟化软件 [RemoteApp Tool]
- 基础篇--ES集群部署
- MongoDB Server对于Sort排序能够支持的最大内存限制查看
- 佳能iC MF4712怎么使用按键【扫描到计算机】
- 2021-03-12:go中,如何确定有没有内存泄露,系统里怎么去监控整体的运
- 04- Kuboard v2 部署RabbitMQ服务