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