Here I am going to illustrate the procedure to patch oracle 19c database in windows enthronement, to apply APRIL 2021 CPU patches (19.11) RU (release update).
Download Windows Database Bundle Patch (19c) 19.11 from Oracle Support website.
Download the latest OPatch utility:
Ensure your run CMD as administrator:
Check your environment variables:
Stop Distributed Transaction Coordinator:
net stop msdtc
Go to the directory where the patch is downloaded
Apply the patches using the downloaded Opatch utility and copy it under your $ORACLE_HOME/OPatch directory:
Startup the Oracle services again:
sqlplus / as sysdba
SQL> alter pluggable database all open;
In CMD session (run it as administrator):
Then, check the registry that the patch is successfully applied:
select * from dba_registry_sqlpatch;
I have recently upgraded a database to Oracle 19c with latest patches applied (APRIL 2020) 22.214.171.124.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,,
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
The patch Updated August 6 2020: 29789911 is already included in 19.8 RU so there is no need to apply one-off-patch just apply latest RU
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:
So 19c is considered the long term support !
Release Schedule of Current Database Releases (Doc ID 742060.1)