ORA-27154: post/wait create failed
This error is due to the failure of obtaining the OS semaphore (semaphore can be understood as memory lock) during the startup process, and the process needs to obtain the semaphore before requesting memory for use.
Generally, the processes parameter in oracle is set to processes*2+15 during installation is safer.
Usually the error ORA-27154: post/wait create failed is accompanied by the following errors.
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
These errors are caused by the fact that the processed is too large and the amount of signals to be acquired is not enough.
Check the current settings
[oracle@ebsse oracle]$ cat /proc/sys/kernel/sem
250 32000 100 128
The 4 data items correspond to SEMMSL SEMMNS SEMOPM SEMMNI
Instead of explaining the meaning of the data, let's just talk about the modification.
Change the value of sem to: 5010 641280 5010 128
For automatic application at boot time, add to /etc/sysctl.conf:
kernel.sem =5010 641280 5010 128
sysctl -p
Read More:
- [Solved] MySQL Lock error: Lock wait timeout exceeded; try restarting transaction ; Lock wait timeout
- Oracle Database AWR error: ORA-06502 [How to Solve]
- IDEA maven Config MYSQL Connection Error: Could not create connection to database server.
- [Solved] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
- Oracle-OrcleInstanctClient Install ODBC Error: Oracle ODBC Driver with same name already exists
- Zabbix import MySQL database error ERROR 1046 (3D000) at line 1: No database selected
- [Solved] Mongo Error: cant post the change to mongodb there is transaction error
- [Solved] Rabbitmq Startup Error: Job for rabbitmq-server.service failed because the control process exited with
- [Solved] mariadb Startup Error: Job for mariadb.service failed because the control process exited with error code.
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- The attributes of Oracle batch modification sequence (such as cache)_size, increment_(by et al.)
- Kettle stores data report ora-00600 to Oracle: internal error parameters [KQD object $], [u], [0], [107], [CS], []
- [Solved] MySQL Startup Error: Job for mysqld.service failed because the control process exited with error code
- How to release Oracle PLSQL data lock table
- Oracle creates a job and executes the stored procedure with parameters regularly
- [Solved] C# connecting to MySQL database reports an error
- [Mybatis] How to Solve the problem of Oracle query processing more than 1000 in conditions
- [Solved] Connections could not be acquired from the underlying database
- [Solved] MySQL5.6.44 [Err] 1067 – Invalid default value for create_date settlement programme
- [How to Fix] Database can’t open file (errno:24)