Oracle 19c – Oracle Spatial Bug ORA-13199

I have recently upgraded a database to Oracle 19c with latest patches applied (APRIL 2020)  ….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


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






























Oracle database premier support for Oracle 12cR1,12cR2,18c,19c

Important Note [MAY 2020], the updated dates can be found here:

As a DBA you need to regularly check and review Oracle Support Matrix especially if you have a big infrastructure with mixed Oracle database releases. Also, its very important from a cost perspective as (it depends on your contract with Oracle), to avoid “Paid Extended Support”.

What can be read from different Oracle resource 18c & 19c are considered under 12.2 release umbrella.

To the date of writing this blog (December 15 2018), the following are support dates:

Oracle Support Dates

So 19c is considered the long term support !


Release Schedule of Current Database Releases (Doc ID 742060.1)