Ora-600 [4193] When Opening Or Shutting Down A Database (Doc ID 452662.1)

Last updated on DECEMBER 18, 2015

Applies to:

Oracle Database - Standard Edition - Version 9.0.1.0 to 11.2.0.2.0 [Release 9.0.1 to 11.2]
Oracle Database - Personal Edition - Version 9.0.1.0 to 11.2.0.2.0 [Release 9.0.1 to 11.2]
Oracle Database - Enterprise Edition - Version 9.0.1.0 to 11.2.0.2.0 [Release 9.0.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 15-Oct-2014***


Symptoms

Errors in alert.log:

Tue Jul 17 13:38:13 2007
Errors in file /home/oracle/oracle/product/10.2.0/yms/rdbms/log/yms_smon_8337.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [3552], [3554], [], [], []


yms_smon_8337.trc:

SO: 0xdfaec728, type: 24, owner: 0xdf266580, flag: INIT/-/-/0x00
          (buffer) PR: 0xdf1f1338 FLG: 0x1000
          class bit: 0x80000
          kcbbfbp: [BH: 0xded4bf40, LINK: 0xdfaec768]
          kcbbfbx[0]: [BH: 0xdece41d8, LINK: 0xdfaec788]
          where: ktuwh01: ktugus, why: 0
        buffer tsn: 2 rdba: 0x00c00002 (3/2)
        scn: 0x0000.03c95628 seq: 0x01 flg: 0x00 tail: 0x56280e01
        frmt: 0x02 chkval: 0x0000 type: 0x0e=KTU UNDO HEADER W/UNLIMITED EXTENTS
      BH (0xdece41d8) file#: 3 rdba: 0x00c003b6 (3/950) class: 20 ba: 0x11d6ba000
        set: 6 blksize: 8192 bsi: 0 set-flg: 0 pwbcnt: 0
        dbwrid: 0 obj: -1 objn: 0 tsn: 2 afn: 3
        hash: [df870f70,df870f70] lru: [dece4488,dece4028]
        obj-flags: object_ckpt_list
        ckptq: [dedac4a0,ded47cb8] fileq: [dedac500,ded47cc8] objq: [ded47d78,db7bfd78]
        use: [dfaec788,dfaec788] wait: [NULL]
        st: XCURRENT md: EXCL tch: 0
        flags: mod_started gotten_in_current_mode block_written_once
        change state: ACTIVE
        change count: 1
        LRBA: [0xac3.4de07.0] HSCN: [0xffff.ffffffff] HSUB: [65535]
        Using State Objects
          ----------------------------------------
          SO: 0xdfaec728, type: 24, owner: 0xdf266580, flag: INIT/-/-/0x00
          (buffer) PR: 0xdf1f1338 FLG: 0x1000
          class bit: 0x80000
          kcbbfbp: [BH: 0xded4bf40, LINK: 0xdfaec768]
          kcbbfbx[0]: [BH: 0xdece41d8, LINK: 0xdfaec788]
          where: ktuwh01: ktugus, why: 0
        buffer tsn: 2 rdba: 0x00c003b6 (3/950)
        scn: 0x0000.03be3c7d seq: 0x5a flg: 0x04 tail: 0x3c7d025a
        frmt: 0x02 chkval: 0x0868 type: 0x02=KTU UNDO BLOCK
      ----------------------------------------
Error 607 in redo application callback
TYP:0 CLS:20 AFN:3 DBA:0x00c003b6 OBJ:4294967295 SCN:0x0000.03be3c7d SEQ: 90 OP:5.1
ktudb redo: siz: 132 spc: 4462 flg: 0x0012 seq: 0x0de2 rec: 0x09  
UNDO BLK:
xid: 0x0008.045.00006c61 seq: 0xde0 cnt: 0x60 irb: 0x60 icl: 0x0 flg: 0x0000

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms