ORA-00600 [ktsptrn_fix-extmap] Errors when trying to Insert into a Partitioned Table (Doc ID 1948331.1)

Last updated on NOVEMBER 26, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

1.  The following errors are reported in the alert log:

Mon Oct 13 17:30:16 2014
Errors in file /oraifd/oracle/admin/diag/rdbms/ifd/ifd/trace/ifd_ora_7227.trc (incident=35710):
ORA-00600: internal error code, arguments: [ktsptrn_fix-extmap], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oraifd/oracle/admin/diag/rdbms/ifd/ifd/incident/incdir_35710/ifd_ora_7227_i35710.trc
Use ADRCI or Support Workbench to package the incident.

2.  The incident trace file has the following details:

BH (0x199ef0c70) file#: 7 rdba: 0x007cfd04 (1024/8191236) class: 9 ba: 0x1983fc000
  set: 65 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25
  dbwrid: 0 obj: 99615 objn: 98602 tsn: 7 afn: 7 hint: f
  hash: [0x35bdb0928,0x35bdb0928] lru: [0x257ecc6d0,0x221f438f0]
  ckptq: [NULL] fileq: [NULL] objq: [0x3485c9c08,0x3485c9c08] objaq: [0x3485c9bf8,0x3485c9bf8]

OBJD MISMATCH typ=6, seg.obj=-2, diskobj=100859, dsflg=4, dsobj=99615, tid=99615, cls=8

The bitmap block looks to be pointing at a data block instead of a bitmap:

Block header dump:  0x00840000
Object id on Block? Y
seg/obj: 0x189fb  csc: 0x78c.e012407d  itc: 3  flg: E  typ: 1 - DATA
  brn: 0  bdba: 0x83ff01 ver: 0x01 opc: 0
  inc: 0  exflg: 0

3.  The Failing SQL is similar to:
insert into documents_xml_content PARTITION (P_20141012_1)
SELECT 141012228121822, dxc_xml
FROM ifd.documents_xml_content PARTITION (P_20141007_1) a
where dxc_id=141007128121822

4.  The failing functions and the callstack is similar to:

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp  <- ksfdmp <- dbgexPhaseII <- dbgexExplicitEndInc <- dbgeEndDDEInvocatio <- nImpl <- dbgeEndDDEInvocatio <- ktsptrn_fixbmbs <- ktspisc <- ktspgsp_main <- kdlgsp_init <- kdl_write1 <- kdl_copy <- kdlf_copy <- kokliclo <- koklcre <- kokleva <- evaopn2 <- qesltcEvalOutofLine <- Cols <- qesltcBeforeRowProc <- essing <- qerltcNoKdtBuffered <- InsRowCBK <- qerltcLoadStateMach <- ine <- qerltcInsertSelectR <- qertbFetchByRowID <- qergiFetch <- rwsfcd <- qerltcFetch <- insexe <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main <- libc_start_main  <- start

5. The analyze and RMAN validation check may not trigger the error ORA-00600 [ktsptrn_fix-extmap] and this issue can be reproduced from SQL Plus TOAD and SQLNavigator

SQL> analyze table ifd.documents_xml_content_bad partition (P_20141012_1) validate structure cascade;
Table analyzed.

SQL> select * from invalid_rows;
no rows selected

SQL> analyze table ifd.documents_xml_content_bad validate structure cascade;
Table analyzed.

SQL> select * from invalid_rows;
no rows selected

SQL> insert into ifd.documents_xml_content_bad PARTITION (P_20141012_1)
          SELECT 141012127596978, dxc_xml
          FROM ifd.documents_xml_content_bad PARTITION (P_20141007_1) a where dxc_id=141007127596978;
insert into ifd.documents_xml_content_bad PARTITION (P_20141012_1)
               *
ERROR at line 1:
ORA-00600: internal error code, arguments: [ktsptrn_fix-extmap], [], [], [],[], [], [], [], [], [], [], [] 

 

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