Oracle 19c – Oracle Spatial Bug ORA-13199

I have recently upgraded a database to Oracle 19c with latest patches applied (APRIL 2020) 19.7.0.0.200414  ….as you know by now Oracle 19c is the long-term release.

After editing and committing the SQL transaction on an Oracle Spatial Table using ESRI ArcGIS Desktop Applicaiton….the following errors were thrown to the end-user:

ORA-03114: not connected to ORACLE

ORA-00603: Oracle server session terminated

ORA-00600: internal error code arguments[6006],[1],[]

ORA-13199: Spatila index commit Failure

Process ID: 90662
Session ID: 392 serial number: 27690

Solution:

This is a bug and you will need to download and apply the patch from Oracle Support.

Patch 29789911: ORA-13199: SPATIAL COMMIT FAILURE

*** Updated August 6 2020: The patch 29789911 is already included in 19.8 RU so there is no need to apply one-off-patch just apply latest RU