SPATIAL DISTRIBUTED TRANSACTION COMMIT FAILS ORA-13249 ORA-00604 ORA-13236
(Doc ID 3063784.1)
Last updated on DECEMBER 19, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.25.0.0.0 and laterOracle Spatial and Graph - Version 19.25.0.0.0 and later
Information in this document applies to any platform.
Symptoms
SPATIAL DISTRIBUTED TRANSACTION COMMIT FAILS ORA-13249 ORA-00604 ORA-13236
Error 13249 trapped in 2PC on transaction 5.****.02. Cleaning up.
Error stack returned to user:
ORA-13249: begin /* pexec_cmt_idx_chngs */ mdsys.prvt_idx.cmt_idx_chngs(:idxsch, :idxnam, :idxptn, :tsnam, :tabnam, :ins_no, :del_no, :jnl, :sid); end;
ORA-00604: error occurred at recursive SQL level 2
ORA-13236: internal error in R-tree processing: [MDRCNCCMTTXN:13]
ORA-13249: Failure during delete processing
ORA-13249: mdrcncupdidx:3
ORA-13249: Cannot lock table
ORA-06512: at "MDSYS.PRVT_IDX", line 482
ORA-06512: at line 1
Changes
After applying 19.25 DBRU patches
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 |
| Changes |
| Cause |
| Solution |
| References |