3 Replies Latest reply: Mar 20, 2013 12:35 PM by clcarter RSS

    XE crashes

    83752
      Hello ,

      Over the last 2 days I have been getting odd crashes in systems( different servers ) which reside on the same storage ( Netapp filer ). They always happen at the same time ( 5 mins past midnight ) I see in the alert logs messages like

      Wed Mar 20 00:05:12 2013
      System state dump requested by (instance=1, osid=7048 (PMON)), summary=[abnormal instance termination].
      System State dumped to trace file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_diag_7058.trc
      Dumping diagnostic data in directory=[cdmp_20130320000512], requested by (instance=1, osid=7048 (PMON)), summary=[abnormal instance termination].
      Instance terminated by PMON, pid = 7048

      and
      PMON (ospid: 7332): terminating the instance due to error 469
      Tue Mar 19 00:05:19 2013
      System state dump requested by (instance=1, osid=7332 (PMON)), summary=[abnormal instance termination].
      System State dumped to trace file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_diag_7342.trc
      Dumping diagnostic data in directory=[cdmp_20130319000519], requested by (instance=1, osid=7332 (PMON)), summary=[abnormal instance termination].
      Instance terminated by PMON, pid = 7332
      Tue Mar 19 12:11:44 2013


      Has anyone seen similar issues on XE 11.2.0.2

      Connected to:
      Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

      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

      SQL>

      Thanks

      Regardsm
      Alex
        • 1. Re: XE crashes
          TSharma-Oracle
          Find any ORA- error in following trace files and post
          XE_diag_7058.trc
          XE_diag_7342.trc
          • 2. Re: XE crashes
            83752
            Thanks . No ORA- errors in the trace files though . I can see in the trace PMON trace file messages like

            Background process CKPT found dead
            Oracle pid = 15
            OS pid (from detached process) = 7360
            OS pid (from process state) = 7360
            dtp = 0x600258b0, proc = 0x9f5d99c8
            Dump of memory from 0x00000000600258B0 to 0x0000000060025910
            0600258B0 000000C3 00000000 9F5D99C8 00000000 [..........].....]
            0600258C0 00000000 00000000 00000000 54504B43 [............CKPT]
            0600258D0 00000200 00000000 00001CC0 00000000 [................]
            0600258E0 00001D5F 00000000 BBDC0000 00002B44 [_...........D+..]
            .
            .
            .
            Regards,
            Alex
            • 3. Re: XE crashes
              clcarter
              Background process CKPT found dead
              Ok so pmon noticed that the checkpoint process died, and then crashed the instance. Checking processes is pmon's job, the Process MONitor. If your instance is not completing checkpoints the ability to recover and maintain things like data integrity are at risk.

              So we can tell what happened, the why part is usually a bit more difficult.

              Different instances, same storage, same time(s). So there are two things in common, storage and time. Are there any SAN flash copies, cloning, backup, etc. happening at that particular time frame? Are the netapp filers attached via NFS, or fibre channel?