ORA-600 [kcbz_check_objd_typ_3] Involving WRH$ table ( i.e AWR tables ) (Doc ID 1332838.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Aug-2013***

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



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

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