Hello,
I investigated and found the following in alert_XE.log
Instance terminated by DBW0, pid = 46808
Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_dbw0_46808.trc:
ORA-27300: OS system dependent operation:semctl failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwrm1
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1
Thu Jun 22 09:02:40 2017
Instance termination got error 27120 from SGA destruction.
Error cleared. Process exiting.
- I have 64 GB RAM with 500 SSD disk space on dedicated server.
- I am running Plesk and Oracle both on CentOS 6.7
- This error is occurred when I edit any Plesk utility and Oracle become auto shutdown
- I know CentOS is not recommended system for Oracle but Plesk is not supporting Oracle Linux that's why I am working on CentOS that is Plesk recommended OS.
- Here is my show sga result
SQL> show sga
Total System Global Area 1068937216 bytes
Fixed Size 2233344 bytes
Variable Size 859835392 bytes
Database Buffers 201326592 bytes
Redo Buffers 5541888 bytes
How can I fix this errors?
Please advise