ORA-00600: internal error code, arguments: [kdodsc2] (Doc ID 1328756.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

Instance crashed due to ORA-00600: internal error code, arguments: [kdodsc2]

Alert log :

Doing block recovery for file 8 block 3663613
Doing block recovery for file 8 block 3663613
Resuming block recovery (PMON) for file 8 block 3663613
Block recovery from logseq 29288, block 18817 to scn 280824041940
Recovery of Online Redo Log: Thread 1 Group 2 Seq 29288 Reading mem 0
Mem# 0: /n01/oradata1/ord314/ord314a1_redo2_01.log
Block recovery stopped at EOT rba 29288.18867.16
Block recovery completed at rba 29288.18867.16, scn 65.1651167679
Errors in file /n01/oraadmin1/diag/rdbms/ord314a/ord314a1/trace/ord314a1_pmon_1060.trc (incident=328238):
ORA-00600: internal error code, arguments: [kdodsc2], [0], [18], [], [], [], [], [], [], [], [], []

Call Stack :
ksfdmp dbgexPhaseII dbgexProcessError dbgeExecuteForError dbgePostErrorKGE kgeade kgerem kxfpProcessError kxfpProcessMsg kxfpqidqr kxfpqtstr ktprsched kturec kturax ktprbeg ktmmon
ktmSmonMain ksbrdp opirip opidrv sou2o opimai_real ssthrdmain main start

Find the object which is corrupted by using below command
SQL> SELECT tablespace_name, segment_type, owner, segment_name, partition_name
FROM dba_extents
WHERE file_id = < File Id > ## in our case file_id is 8
and < Block Id> between block_id AND block_id + blocks - 1; ## in our case block_id is 3663613

SQL> SELECT tablespace_name, segment_type, owner, segment_name, partition_name
FROM dba_extents
WHERE file_id = 8
and 3663613 between block_id AND block_id + blocks - 1;
2 3 4
TABLESPACE_NAME SEGMENT_TYPE OWNER SEGMENT_NAME PARTITION_NAME
------------------------------ ------------------ ------------------------------ ------------------------------ ------------------------------
TEST TABLE USR1 FACT1


Try to analyze the object:


SQL> ANALYZE TABLE USR1.FACT1 VALIDATE STRUCTURE CASCADE;
ANALYZE TABLE PERF_DB_DATA.LIT_FACT_DATAMART VALIDATE STRUCTURE CASCADE
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kdodsc2]



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