PATCHING AN ORACLE DATABASE WITH OPATCH (Upgrade 19.16 to 19.21)

We must not forget that we have backup the database before continuing with the patching steps.

The steps we will follow are summary below.

• Download patch
• Check the pre-installation steps
• Close the listener
• Close the database
• Apply the patch
• Open the database
• Open the listener
• Post Patch Steps

Oracle Database 19c Important Recommended One-off Patches (Doc ID 555.1) Reference to this document.

We must use the OPatch utility version 12.2.0.1.37 or later to apply this patch so downloaded last opatch version. Oracle Support patch 6880880 referances for opatch version.

[oracle@rac1dbadm01 db_1]$ opatch version
OPatch Version: 12.2.0.1.39
OPatch succeeded.
[oracle@rac1dbadm01 db_1]$ unzip /oracle/install/p6880880_210000_Linux-x86-64.zip
## Note: OPatch directory in this Oracle Software location. Unzip this location 
[oracle@rac1dbadm01 db_1]$ opatch version
OPatch Version: 12.2.0.1.40
OPatch succeeded

Now unzip 19.21 release update patch and control pre-steps command.

[oracle@rac1dbadm01 install]$ unzip p35643107_190000_Linux-x86-64.zip
[oracle@rac1dbadm01 35643107]$ cd /oracle/install/35643107
[oracle@rac1dbadm01 35643107]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/install/35643107

Prereq "checkConflictAgainstOHWithDetail" failed.

Subset Patch 34133642 which has overlay patches [34709932,32847962,34349149,34396210,32295794,34545238,34333986,33838019,33510062,
33195096,34793099,34284147,29213893] and these overlay patches conflict with Superset Patch

The patch failed because conflict bundle patches. Rollback the conflict patches

[oracle@rac1dbadm01 35643107]$ opatch nrollback -id 34709932,32847962,34349149,34396210,32295794,34545238,34333986,33838019,33510062,33195096,34793099,34284147,29213893

[oracle@rac1dbadm01 35643107]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/install/35643107

Oracle Interim Patch Installer version 12.2.0.1.40
Copyright (c) 2023, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /oracle/product/19c/db_1
Central Inventory : /oracle/oraInventory
   from           : /oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.40
OUI version       : 12.2.0.7.0
Log file location : /oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2023-12-27_12-29-25PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@rac1dbadm01 35643107]$ opatch apply

Patching component oracle.perlint, 5.28.1.0.0...

Patching component oracle.rdbms.locator, 19.0.0.0.0...

Patching component oracle.perlint.expat, 2.0.1.0.4...

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.util, 19.0.0.0.0...

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.assistants.acf, 19.0.0.0.0...

Patching component oracle.assistants.deconfig, 19.0.0.0.0...

Patching component oracle.assistants.server, 19.0.0.0.0...

Patching component oracle.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

Patching component oracle.dbjava.ic, 19.0.0.0.0...

Patching component oracle.dbjava.jdbc, 19.0.0.0.0...

Patching component oracle.dbjava.ucp, 19.0.0.0.0...

Patching component oracle.duma, 19.0.0.0.0...
.
.
.
.
.
.
OPatch succeeded.

Now aplying OJVM patch for 19.21.

[oracle@rac1dbadm01 install]$ unzip p35648110_190000_Linux-x86-64.zip
[oracle@rac1dbadm01 install]$ cd 35648110
[oracle@rac1dbadm01 35648110]$ opatch apply
.
.
.
.
.
OPatch succeeded.

Finally open listener services and database.

[oracle@rac1dbadm01 35648110]$lsnrctl start
[oracle@rac1dbadm01 35648110]$ sqlplus / as sysdba
SQL> startup;

and run datapatch verbose.

[oracle@rac1dbadm01 install]$ ./datapatch -verbose
.
.

Check patch list.

[oracle@rac1dbadm01 install]$ opatch lsinventory|grep "Patch description"
Patch description:  "LMS HIT ORA-600[KJBLPGORM !ANTILOCK]"
Patch description:  "THROW A FATAL ERROR IF MEMLOCK LIMITS ARE NOT CONFIGURED AS EXPECTED"
Patch description:  "LNX-23.1 - RM HIT - ORA 600 IPC_RECREATE_QUE_2 WHILE RUNNING STRESS WORKLOAD"
Patch description:  "LSR   MANY SESSIONS HANG WAITING FOR FREE BUFFER WAITS"
Patch description:  "TT23.1ASAN  GLOBAL-BUFFER-OVERFLOW IN PGA AT KWQALOCKQTWITHINFO"
Patch description:  "TRACKING BUG FOR KQR FIXES FOR 19.18 RU"
Patch description:  "OJVM RELEASE UPDATE: 19.21.0.0.231017 (35648110)"
Patch description:  "Database Release Update : 19.21.0.0.231017 (35643107)"
Patch description:  "OCW Interim patch for 34882628"