ORA-600 [kcbz_check_objd_typ_3] Involving WRH$ table ( i.e AWR tables )
(Doc ID 1332838.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.5 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
You receive the below error message in the alert log.
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], []
It may also be accompanied by other errors such as:
ORA-00600: internal error code, arguments: [13013], [5001]
From trace file , we observe
The object information:
OBJD MISMATCH typ=6, seg.obj=-2, diskobj=78585, dsflg=0, dsobj=78579, tid=78579, cls=1
Input data (nil), 0, 0
Formatted dump of block:
buffer tsn: 2 rdba: 0x00c05552 (3/21842)
scn: 0x0000.088a079f seq: 0x01 flg: 0x06 tail: 0x079f0601
frmt: 0x02 chkval: 0xab95 type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
06B75DFF0 80018001 80018001 80018001 079F0601 [................]
Block header dump: 0x00c05552
Object id on Block? Y
seg/obj: 0x132f9 csc: 0x00.889fda5 itc: 2 flg: E typ: 1 - DATA
brn: 1 bdba: 0xc05529 ver: 0x01 opc: 0
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0005.010.0000b429 0x008273f9.0ed3.04 --U- 151 fsc 0x0000.088a079f
0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
Input data (nil), 0, 0
Formatted dump of block:
buffer tsn: 2 rdba: 0x00c05552 (3/21842)
scn: 0x0000.088a079f seq: 0x01 flg: 0x06 tail: 0x079f0601
frmt: 0x02 chkval: 0xab95 type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
06B75DFF0 80018001 80018001 80018001 079F0601 [................]
Block header dump: 0x00c05552
Object id on Block? Y
seg/obj: 0x132f9 csc: 0x00.889fda5 itc: 2 flg: E typ: 1 - DATA
brn: 1 bdba: 0xc05529 ver: 0x01 opc: 0
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0005.010.0000b429 0x008273f9.0ed3.04 --U- 151 fsc 0x0000.088a079f
0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
The call stack will show the following:
kcbassertbd3 <- kcbz_check_objd_typ <- kcbzib <- kcbget <- ktbxchg <- kdifind <- kdiins0 <- kauxsin <- insidx .....
The current SQL statement for this session run on against the WRH$ table(s) , (i.e. AWR tables)
insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro from v$system_event order by event_id
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |