ORA-13236: Internal Error In R-tree Processing: [MDRCNCCMTTXNg] (Doc ID 1953302.1)

Last updated on DECEMBER 11, 2014

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

A massive load of data into tables with Spatial indexes fails with errors
ORA-12012: error on auto execute of job "EDD_DM_ADMIN"."EDD_DM_ADMIN_043256_2"
ORA-13236: internal error in R-tree processing: [MDRCNCCMTTXNg]
ORA-13249: mdrcncupdidx:3
ORA-06512: at "EDD_DM_ADMIN.ETL_UTIL", line 1293
ORA-06512: at line 1
Wed Nov 20 07:21:47 2013
Errors in file /n01/oraadmin1/diag/rdbms/rfp04a/rfp04a1/trace/rfp04a1_j000_35900.trc:
ORA-12012: error on auto execute of job "EDD_DM_ADMIN"."APPLY_APPLY_DIMNSIONS_10341304"
ORA-20000: ORA-20000: Error during etl_util.execute_parallel for batch: EDD_DM_ADMIN_043256 job_name: EDD_DM_ADMIN_043256_2
Exception executing job: EDD_DM_ADMIN_043256_2.
Error: ORA-13236: internal error in R-tree processing: [MDRCNCCMTTXNg]
ORA-13249: mdrcncupdidx:3.
ORA-06512: at "EDD_DM_ADMIN.APPLY", line 513
ORA-06512: at line 2
ORA-06512: at "EDD_DM_ADMIN.ETL_UTIL", line 581
ORA-06512: at "EDD_DM_ADMIN.ETL_UTIL", line 1254
ORA-06512: at "EDD_DM_ADMIN.APPLY", line 371
ORA-20000: Error during etl_util.execute_parallel for batch: EDD_DM_ADMIN_043256 job_name: EDD_DM_ADMIN_043256_2
Exception executing job: EDD_DM_ADMIN_043256_2.
Error: ORA-13236: internal error in R-tree processing: [MDRCNCCMTTXNg]
ORA-13249: mdrcncupdidx:3.
ORA-06512: at "EDD_DM_ADMIN.APPLY", line 513
ORA-06512: at line 2
ORA-06512: at "EDD_DM_ADMIN.ETL_UTIL", line 581
ORA-06512: at "EDD_DM_ADMIN.ETL_UTIL", line 1254
ORA-06512: at "EDD_DM_ADMIN.APPLY"
Wed Nov 20 07:26:55 2013
Thread 1 cannot allocate new log, sequence 21939
Private strand flush not complete


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