4 Replies Latest reply: Apr 28, 2014 11:58 AM by Christy H. RSS

    My Oracle XE is crashing after couple of days

    Christy H.

      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