Mir Sayeed Hassan – Oracle Blog

Apply the Latest OPatch (12.2.0.1.40) for Oracle Database 19C

Check the status of Database

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

INSTANCE_NAME       VERSION         OPEN_MODE
----------------------------------------------
testdb1            19.0.0.0.0      READ WRITE

Check the last updated OPatch

[oracle@test19cdb ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.37
Copyright (c) 2023, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version : 12.2.0.1.37
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2023-10-31_14-34-24PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/lsinv/lsinventory2023-10-31_14-34-24PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test19cdb
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 34765931 : applied on Sat Aug 26 15:41:26 IRST 2023
Unique Patch ID: 25098466
Patch description: "DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)"
Created on 27 Jan 2023, 11:25:14 hrs UTC
Bugs fixed:
10123661, 1297945, 14570574, 14735102, 15931756, 15959416, 16662822
16664572, 16750494, 17275499, 17395507, 17428816, 17468475, 17562236
-------------------------------------------------------------------------------
OPatch succeeded.

OR

[oracle@test19cdb ~]$ $ORACLE_HOME/OPatch/opatch lspatches
34765931;DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.

OR

[oracle@test19cdb ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.37

OPatch succeeded.

Download the latest OPatch from Oracle Support

https://updates.oracle.com/download/6880880.html

Transfer the OPATCH Software to directory at OS Level.

[oracle@test19cdb ~]$ cd /u02/source/OPATCH_12.2.0.1.40/

[oracle@test19cdb OPATCH_12.2.0.1.40]$ ls
p6880880_190000_Linux-x86-64.zip

Move the above downloaded OPatch file into the OPatch Home $ORACLE_HOME/OPatch.

[oracle@test19cdb OPATCH_12.2.0.1.40]$ cp p6880880_190000_Linux-x86-64.zip /u01/app/oracle/product/19c/db_1/

[oracle@test19cdb OPATCH_12.2.0.1.40]$ cd /u01/app/oracle/product/19c/db_1/

Take a backup of the existing OPatch file.

[oracle@test19cdb db_1]$ mv OPatch OPatch_BKP1

Start Applying the OPatch by using unzip the file

[oracle@test19cdb db_1]$ unzip p6880880_190000_Linux-x86-64\(1\).zip
Archive: p6880880_190000_Linux-x86-64(1).zip
creating: OPatch/
creating: OPatch/docs/
inflating: OPatch/docs/cversion.txt
inflating: OPatch/docs/Users_Guide.txt
inflating: OPatch/docs/Prereq_Users_Guide.txt
inflating: OPatch/docs/FAQ
inflating: OPatch/emdpatch.pl
creating: OPatch/ocm/
extracting: OPatch/ocm/generic.zip
creating: OPatch/ocm/doc/
creating: OPatch/ocm/lib/
creating: OPatch/ocm/bin/
----
EXTRACTION CONTINUE.....

Verify:

[oracle@test19cdb ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.40
OPatch succeeded.

=====Hence tested & verified in our env=====