My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.