Patching Oracle 19c Database in Windows OS

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:

set PATH=%ORACLE_HOME%\perl\bin;%PATH%

set ORACLE_HOME=D:\WINDOWS.X64_193000_db_home

set PERL5LIB=

Stop Distributed Transaction Coordinator:

net stop msdtc

Go to the directory where the patch is downloaded

D:

cd D:\19.11.windows_patch\32409154

Apply the patches using the downloaded Opatch utility and copy it under your $ORACLE_HOME/OPatch directory:

D:\WINDOWS.X64_193000_db_home\OPatch\opatch.bat apply

Startup the Oracle services again:

Post-Patch activity:

sqlplus / as sysdba

SQL> startup

SQL> alter pluggable database all open;

SQL> exit;

In CMD session (run it as administrator):

D:

cd D:\WINDOWS.X64_193000_db_home\OPatch\

datapatch -verbose

Then, check the registry that the patch is successfully applied:

select * from dba_registry_sqlpatch;

Advertisement

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/