数据库日常案例学习20240219-Oracle不能启动，提示设备空间不足，实际上是信号量不够（ORA-27300,ORA-27301,ORA-27302）_ora-27154 ora-27300 ora-27301 ora-27302-CSDN博客

1 问题现象

ORA-27154: post/wait create failedORA-27300: OS system dependent operation:semget failed with status: 28ORA-27301: OS failure message: No space left on deviceORA-27302: failure occurred at: sskgpcreates

数据库无法正常启动。

乍一看以为是硬盘空间不够，使用du进行检查，发现空间没有问题。而且这个错误是在实例启动到nomount状态时出现的，这个过程中只需要访问数据库的参数文件，并不涉及到硬盘空间的问题。

在rman中启动dummy实例（export ORACLE_SID=dummy）试试，也出现了同样的错误：

$ export ORACLE_SID=dummy$ rman target /Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jan 9 10:14:24 2024Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
connected to target database: DUMMY (not mounted)RMAN> startup nomount;startup failed:0RA-01078:failure inprocessing systemparametersLRM-00109:could notopen parameter 
file'/u01/app/oracle/product/19.3.0/db/dbs/initdummy.orastarting Oracleinstance without parameter file forretrieval of spfileRMAN-00571:===================================================================RMAN-00569:============ERROR MESSAGE STACK FOLLOWS============================RMAN-00571:===================================================================RMAN-03002:fatlure of startup command at 01/03/2024 14:48:06RMAN-04014:startup failed: 0RA-27154: post/wait create failedORA-27300:OS system dependent operation:semget failed with status:28ORA-27301:Os failuremessage:No spaceleft on deviceoRA-27302:failure 0ccurred at:sskgpcreatesRMAN>