Oracle ORA-600 [kdblkcheckerror]

Format: ORA-600 [kdblkcheckerror] [a] [b] [c] [d] [e]

VERSIONS:

versions X.X to X.X

DESCRIPTION:

--what condition caused the error to be reported

ARGUMENTS:

Arg [a] --described here

Arg [b] --described here

.

.

FUNCTIONALITY:

--NAME description of source code raising the OERI

IMPACT:

--List possible impact - for example :

INSTANCE FAILURE

PROCESS FAILURE

NO IMPACT

MEMORY CORRUPTION

NON CORRUPTIVE - No underlying data corruption.

POSSIBLE PHYSICAL CORRUPTION

NB Bug Fixed Description

17447078 12.1.0.2, 12.2.0.0 Diagnostic enhancement for ORA-600 [kdBlkCheckError] .. [18007] errors

14400110 11.2.0.4, 12.2.0.0 Bad redo / ORA-600 [kdBlkCheckError] .. [6135] for opcode 19.1 redo

12349316 11.2.0.4, 12.2.0.0 DBMS_SPACE_ADMIN.TABLESPACE_FIX_BITMAPS fails with ORA-600 [kddummy_blkchk] / ORA-600

[kdBlkCheckError] / ORA-607

14351566 11.2.0.3.8, 11.2.0.3.BP21, 11.2.0.4, 12.1.0.1 ORA-600 [kclchkblk_4] when doing flash back

16347904 11.2.0.4, 12.2.0.0 Corrupt block with check code 6101, 6110 or 6255 on compressed table with DML workload

17325413 12.1.0.2 Drop column with DEFAULT value and NOT NULL definition ends up with dropped column data hitting

disk leading to corruption

14741727 11.2.0.2.9, 11.2.0.2.BP19, 11.2.0.3.BP12,

11.2.0.3.BP13, 12.1.0.1 Fixes for bug 12326708 and 14624146 can cause problems - backout fix

14551844 11.2.0.4, 12.1.0.1 ORA-600 [kdblkcheckerror] [6126] / ORA-600 [17182] for DELETE / INSERT (QMD / QMI) in

COMPRESS BASIC table due to negative avsp

13804294 11.2.0.3.4, 11.2.0.3.BP07, 11.2.0.4, 12.1.0.1 Internal errors, corruptions, using pipelined function whose rows raise exceptions

13715932 11.2.0.4, 12.1.0.1 CREATE TABLE fails with ORA-600 [kddummy_blkchk] with large datafile

* 13605839 11.2.0.3.8, 11.2.0.3.BP21, 11.2.0.4, 12.1.0.1 ORA-600 [ktbsdp1] ORA-600 [kghfrempty:ds]. Corruption in Rollback with Clusterwide Global

Transactions in RAC

12417369 11.2.0.2.5, 11.2.0.2.BP13, 11.2.0.2.GIPSU05,

11.2.0.3, 12.1.0.1 Block corruption from rollback on compressed table

* 10205230 11.2.0.1.6, 11.2.0.1.BP09, 11.2.0.2.2,

11.2.0.2.BP04, 11.2.0.3, 12.1.0.1 ORA-600 / corruption possible during shutdown in RAC

10180121 11.2.0.3, 12.1.0.1 ORA-600 [kdBlkCheckError] .. [6251] / block corruption during parallel DML

+ 9724970 11.2.0.1.BP08, 11.2.0.2.2, 11.2.0.2.BP02, 11.2.0.3,

12.1.0.1 Block Corruption with PDML UPDATE. ORA_600 [4511] OERI[kdblkcheckerror] by block check

* 9711859 10.2.0.5.1, 11.1.0.7.6, 11.2.0.2, 12.1.0.1 ORA-600 [ktsptrn_fix-extmap] / ORA-600 [kdblkcheckerror] during extent allocation caused by bug

8198906

9541485 11.2.0.4, 12.1.0.1 Create materialized view on views based on CON$ fails with ORA-600 [kdBlkCheckError]

* 9406607 11.2.0.1.3, 11.2.0.1.BP06, 11.2.0.2, 12.1.0.1 Corrupt blocks in 11.2 in table with unique key. OERI[kdBlkCheckError] by block check

9295217 11.2.0.2, 12.1.0.1 ORA-600 [ktsk_dba_to_hwm-1] / corruption during SHRINK of HWM

+ 9019113 11.2.0.1.BP02, 11.2.0.2, 12.1.0.1 ORA-600 [17182] for OLTP COMPRESS table in OLTP Compression REDO during RECOVERY

8720802 10.2.0.5, 11.2.0.1.BP07, 11.2.0.2, 12.1.0.1 Add check for row piece pointing to itself (db_block_checking,dbv,rman,analyze)

* 8331063 11.2.0.3, 12.1.0.1 Corrupt Undo. ORA-600 [2015] during rollback in undo block for COMPRESS table with

SUPPLEMENTAL LOGGING

8277580 11.1.0.7.2, 11.2.0.1, 11.2.0.2, 12.1.0.1 Corruption on compressed tables during Recovery and Quick Multi Delete (QMD).

6523037 11.2.0.1.BP07, 11.2.0.2.2, 11.2.0.2.BP01, 11.2.0.3,

12.1.0.1 Corruption / ORA-600 [kddummy_blkchk] [6110] on update

8437213 10.2.0.4.3, 10.2.0.5, 11.1.0.7.7, 11.2.0.1 ASSM first level bitmap block corruption

8360192 11.1.0.7.6, 11.2.0.1 ORA-600 [kdBlkCheckError] [6110] / corruption from insert

* 8198906 10.2.0.5, 11.2.0.1 OERI [kddummy_blkchk] / OERI [5467] for an aborted transaction of allocating extents

7715244 11.1.0.7.2, 11.2.0.1 Corruption on compressed tables. Error codes 6103 / 6110