Mir Sayeed Hassan – Oracle Blog

APPLY THE LATEST OPTACH 6880880 (12.2.0.1.45) ON Grid Infrastructure 19C DATABASE

Check the status of database

SQL> select instance_name, version, open_mode from v$database, v$instance;

INSTANCE_NAME    VERSION      OPEN_MODE
------------------------------------------
ora19ctdb1     19.0.0.0.0    READ WRITE

Check existing OPatch applied.

[oracle@payment-dbs ~]$ $GRID_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.42
Copyright (c) 2025, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/19c/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19c/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.42
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2025-02-11_14-12-01PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2025-02-11_14-12-01PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: payment-dbs
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):
Oracle Database 19c 19.0.0.0.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 36240578 : applied on Wed Aug 28 16:57:41 IRST 2024
Unique Patch ID: 25625545
Patch description: "OCW RELEASE UPDATE 19.23.0.0.0 (36240578)"
Created on 1 Apr 2024, 03:00:31 hrs PST8PDT
Bugs fixed:
13742922, 17787434, 23320062, 24611963, 24677421, 24943214, 25642320
25736599, 25738437, 26305045, 26496292, 26615554, 26615581, 26675491
--------------------------------------------------------------------------------
OPatch succeeded.

Check the last/previous  patch applied

[oracle@payment-dbs ~]$ $GRID_HOME/OPatch/opatch lspatches
36240578;OCW RELEASE UPDATE 19.23.0.0.0 (36240578)
36233263;Database Release Update : 19.23.0.0.240416 (36233263)

OPatch succeeded.

or

[oracle@payment-dbs ~]$ $GRID_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.42
OPatch succeeded.

Transfer the downloaded OPatch to some location

[oracle@payment-dbs ~]$ cd /u02/source/PATCH_19.25/OPATCH_12.2.0.1.45/

[oracle@payment-dbs OPATCH_12.2.0.1.45]$ ls
p6880880_190000_Linux-x86-64.zip

[oracle@payment-dbs OPATCH_12.2.0.1.45]$ cp p6880880_190000_Linux-x86-64.zip $GRID_HOME/

[oracle@payment-dbs OPATCH_12.2.0.1.45]$ cd $GRID_HOME

[oracle@payment-dbs grid]$ ll p6880880_190000_Linux-x86-64.zip
-rwxr-xr-x. 1 oracle oinstall 131979857 Feb 11 14:16 p6880880_190000_Linux-x86-64.zip

[oracle@payment-dbs grid]$ mv OPatch OPatch_BKP_11FEB25

Unzip the OPatch into the GRID Home location 

[oracle@payment-dbs grid]$ unzip p6880880_190000_Linux-x86-64.zip
Archive: p6880880_190000_Linux-x86-64.zip
creating: OPatch/
inflating: OPatch/opatchauto
creating: OPatch/ocm/
creating: OPatch/ocm/doc/
creating: OPatch/ocm/bin/
creating: OPatch/ocm/lib/
extracting: OPatch/ocm/generic.zip
inflating: OPatch/emdpatch.pl
extracting: OPatch/version.txt
creating: OPatch/private/

----
----

Verify the Applied OPatch 

[oracle@payment-dbs ~]$ $GRID_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.45
OPatch succeeded.

=====Hence tested and verified in our test env=====