Mir Sayeed Hassan – Oracle Blog

Apply the Latest OPatch (12.2.0.1.37) 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
---------------- ----------------- --------------------
PEPSTAGE 19.0.0.0.0 READ WRITE

Check the last updated OPatch

[oracle@stagdb ~]$ $ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.34
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.34
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2023-05-01_15-45-49PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/lsinv/lsinventory2023-05-01_15-45-49PM.txt
---------------------------------------------------------------------------------------------------------------------------------
Local Machine Information::
Hostname: stagdb
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 34419443 : applied on Mon Feb 20 18:22:29 IRST 2023
Unique Patch ID: 24972075
Patch description: "Database Release Update : 19.17.0.0.221018 (34419443)"
Created on 14 Oct 2022, 05:25:14 hrs UTC
Bugs fixed:
31994298, 32070206, 30373419, 29179097, 32610271, 30398251, 29525467
---
---
OPatch succeeded.

OR

[oracle@stagdb ~]$ $ORACLE_HOME/OPatch/opatch lspatches
34419443;Database Release Update : 19.17.0.0.221018 (34419443)
33815596;OCW RELEASE UPDATE 19.15.0.0.0 (33815596)

OPatch succeeded.

OR

[oracle@stagdb ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.34

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@stagdb ~]$ cd /u01/source/OPATCH_12.2.0.1.37/

[oracle@stagdb OPATCH_12.2.0.1.37]$ ls
p6880880_190000_Linux-x86-64.zip

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

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

Take a backup of the existing OPatch file.

[oracle@stagdb db_1]$ mv OPatch OPatch_bkp_01052023

Start Applying the OPatch by using unzip the file

[oracle@stagdb db_1]$ unzip p6880880_190000_Linux-x86-64.zip

Archive: p6880880_190000_Linux-x86-64.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

Verify:

[oracle@stagdb OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.37
OPatch succeeded.

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