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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

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

https://geodatamaster.com/2020/04/21/oracle-database-product-life-cycle-support-19c18c-and-now-12cr2-is-extended/

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 !

Resources:

Release Schedule of Current Database Releases (Doc ID 742060.1)

https://mikedietrichde.com/2018/12/14/premier-support-extension-for-oracle-19c-and-more/