4 Replies Latest reply: Nov 12, 2007 7:57 AM by user589325 RSS

    terminating instance due to error -  CKPT process terminated with error

    542687
      Hi Folks !

      i have a problem with my oracle 10g it works under an debain 3.1. In my alert.log i have see an error-message, the database terminating.

      Thu Feb 15 13:01:21 2007
      Errors in file /u01/app/oracle/admin/tlp/bdump/tlp_pmon_9689.trc:
      ORA-00469: CKPT process terminated with error
      Thu Feb 15 13:01:21 2007
      PMON: terminating instance due to error 469
      Instance terminated by PMON, pid = 9689

      A look into the trace file:

      /u01/app/oracle/admin/tlp/bdump/tlp_pmon_9689.trc
      Oracle Database 10g Release 10.2.0.1.0 - Production
      ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
      System name: Linux
      Node name: hyperion
      Release: 2.6.18.1-vs2.1.1-rc48-vserver
      Version: #1 SMP PREEMPT Wed Nov 15 16:53:41 CET 2006
      Machine: i686
      Instance name: tlp
      Redo thread mounted by this instance: 1
      Oracle process number: 2
      Unix process pid: 9689, image: oracle@hyperion (PMON)

      *** 2007-02-15 13:01:21.813
      *** SERVICE NAME:(SYS$BACKGROUND) 2007-02-15 13:01:21.813
      *** SESSION ID:(170.1) 2007-02-15 13:01:21.813
      Background process CKPT found dead
      Oracle pid = 7
      OS pid (from detached process) = 9700
      OS pid (from process state) = 9700
      dtp = 0x2000c9ac, proc = 0x672b14c4
      Dump of memory from 0x2000C9AC to 0x2000C9D8
      2000C9A0 00000076 [v...]
      2000C9B0 672B14C4 00000000 00000000 54504B43 [..+g........CKPT]
      2000C9C0 00000200 000025E4 0A8BA210 00000001 [.....%..........]
      2000C9D0 70F2A67F 00040081 [...p....]
      Dump of memory from 0x672B14C4 to 0x672B1A78
      672B14C0 00000102 00000000 00000000 [............]
      672B14D0 00000000 00000000 65621FF8 67825F00 [..........be._.g]
      672B14E0 673C0034 678250A4 00000000 67825108 [4.<g.P.g.....Q.g]
      672B14F0 67825108 67825EF4 01000601 673AB4A0 [.Q.g.^.g......:g]
      672B1500 673C0034 00000007 00000000 00000000 [4.<g............]
      672B1510 00000000 674CB40C 674CC04C 00000000 [......LgL.Lg....]
      672B1520 00000000 00000000 00000000 00000000 [................]
      Repeat 3 times
      ..
      .
      .
      .
      672B1A70 00000003 00000005 [........]
      error 469 detected in background process
      ORA-00469: CKPT process terminated with error

      What can i do ? Have you any ideas to fix the problem ?

      #################
      Problem 2:
      After the error message i start my server and see in my alert.log:

      .
      .
      .

      Starting background process QMNC
      QMNC started with pid=17, OS id=17164
      Thu Feb 15 14:33:45 2007
      Errors in file /u01/app/oracle/admin/tlp/udump/tlp_ora_17122.trc:
      ORA-00604: error occurred at recursive SQL level 1
      ORA-12663: Services required by client not available on the server
      ORA-36961: Oracle OLAP is not available.
      ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
      ORA-06512: at line 15
      Thu Feb 15 14:33:45 2007
      db_recovery_file_dest_size of 5120 MB is 0.00% used. This is a
      user-specified limit on the amount of space that will be used by this
      database for recovery-related files, and does not reflect the amount of
      space available in the underlying filesystem or ASM diskgroup.
      Thu Feb 15 14:33:46 2007
      Completed: ALTER DATABASE OPEN


      hyperion:/u01/app/oracle/logs# less /u01/app/oracle/admin/tlp/udump/tlp_ora_17122.trc

      Node name: hyperion
      Release: 2.6.18.1-vs2.1.1-rc48-vserver
      Version: #1 SMP PREEMPT Wed Nov 15 16:53:41 CET 2006
      Machine: i686
      Instance name: tlp
      Redo thread mounted by this instance: 1
      Oracle process number: 15
      Unix process pid: 17122, image: oracle@hyperion (TNS V1-V3)

      *** SERVICE NAME:() 2007-02-15 14:33:39.169
      *** SESSION ID:(159.7) 2007-02-15 14:33:39.169
      Thread 1 checkpoint: logseq 204, block 3873, scn 6263056
      cache-low rba: logseq 204, block 63015
      on-disk rba: logseq 204, block 66596, scn 6301195
      start recovery at logseq 204, block 63015, scn 0
      ----- Redo read statistics for thread 1 -----
      Read rate (ASYNC): 1790Kb in 0.18s => 9.71 Mb/sec
      Total physical reads: 4096Kb
      Longest record: 20Kb, moves: 0/2889 (0%)
      Change moves: 0/32 (0%), moved: 0Mb
      Longest LWN: 299Kb, moves: 0/503 (0%), moved: 0Mb
      Last redo scn: 0x0000.0060260a (6301194)
      ----------------------------------------------
      ----- Recovery Hash Table Statistics ---------
      Hash table buckets = 32768
      Longest hash chain = 2
      Average hash chain = 477/472 = 1.0
      Max compares per lookup = 1
      Avg compares per lookup = 8228/8877 = 0.9
      ----------------------------------------------
      *** 2007-02-15 14:33:39.382
      KCRA: start recovery claims for 477 data blocks
      *** 2007-02-15 14:33:39.398
      KCRA: blocks processed = 477/477, claimed = 477, eliminated = 0
      *** 2007-02-15 14:33:39.403
      Recovery of Online Redo Log: Thread 1 Group 2 Seq 204 Reading mem 0
      ----- Recovery Hash Table Statistics ---------
      Hash table buckets = 32768
      Longest hash chain = 2
      Average hash chain = 477/472 = 1.0
      Max compares per lookup = 2
      Avg compares per lookup = 7619/8700 = 0.9
      ----------------------------------------------
      Error in executing triggers on database startup
      *** 2007-02-15 14:33:45.811
      ksedmp: internal or fatal error
      ORA-00604: error occurred at recursive SQL level 1
      ORA-12663: Services required by client not available on the server
      ORA-36961: Oracle OLAP is not available.
      ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
      ORA-06512: at line 15

      Any ideas ?

      Thanks
      Blue