Hello,
SQL> select * from V$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
-bash-4.1$ cat /etc/*-release
CentOS release 6.5 (Final)
LSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch
CentOS release 6.5 (Final)
CentOS release 6.5 (Final)
===================
The alert_XE.log says:
===================
XE instance PID(12806) clashes with (2886)
USER (ospid: 12806): terminating the instance due to error 45301
GEN0 (ospid: 2894): terminating the instance due to error 27157
Instance terminated by USER, pid = 12806
Instance terminated by GEN0, pid = 2894
Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_gen0_2894.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
Sat Apr 26 23:37:29 2014
Instance termination got error 27120 from SGA destruction.
Error cleared. Process exiting.
=================================================================
Here are content of last part of /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_gen0_2894.trc
=================================================================
----- Abridged Call Stack Trace -----
ksedsts()+461<-kjzdsssd()+279<-kjzdechk()+298<-kjzdicrshnfy()+53<-ksuitm()+1325<-ksbrdp()+3344<-opirip()+623<-opidrv()+603<-sou2o()+103<-opimai_real()+266<-ssthrdmain()+252<-main()+201<-__libc_start_main()+253<-_start()+37
----- End of Abridged Call Stack Trace -----
*** 2014-04-26 23:37:28.626
GEN0 (ospid: 2894): terminating the instance due to error 27157
*** 2014-04-26 23:37:29.645
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
skgm error 27120: errno = 22, info = 5, 65537, 0, 0, 65537, 0, 11
Thanks in anticipation