Mir Sayeed Hassan – Oracle Blog

APPLY THE LATEST OPTACH (12.2.0.1.42) ON 19C DATABASE

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@testdb ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.40
Copyright (c) 2024, 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.40
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2024-05-12_12-33-02PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/lsinv/lsinventory2024-05-12_12-33-02PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: testdb
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 35320081 : applied on Tue Oct 31 18:18:34 IRST 2023
Unique Patch ID: 25314491
Patch description: "Database Release Update : 19.20.0.0.230718 (35320081)"
Created on 15 Jul 2023, 12:54:11 hrs UTC
Bugs fixed:
10123661, 1297945, 14570574, 14735102, 15931756, 15959416, 16662822
16664572, 16750494, 17275499, 17395507, 17428816, 17468475, 17562236
-------------------------------------------------------------------------------
OPatch succeeded.

OR

[oracle@testdb ~]$ $ORACLE_HOME/OPatch/opatch lspatches
35320081;Database Release Update : 19.20.0.0.230718 (35320081)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.

OR

[oracle@testdb ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.40

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@testdb ~]$ cd /u02/source/OPATCH_12.2.0.1.42/

[oracle@testdb OPATCH_12.2.0.1.42]$ ls
p6880880_190000_Linux-x86-64.zip

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

[oracle@testdb OPATCH_12.2.0.1.42]$ cp p6880880_190000_Linux-x86-64.zip $ORACLE_HOME/

[oracle@testdb OPATCH_12.2.0.1.42]$ cd $ORACLE_HOME/

Take a backup of the existing OPatch file.

[oracle@test19cdb db_1]$ mv OPatch OPatch_BKP_40

Start Applying the OPatch by using unzip the file

[oracle@testdb db_1]$ 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/datapatch.bat
inflating: OPatch/emdpatch.pl
extracting: OPatch/version.txt
creating: OPatch/private/

----
----

Verify:

[oracle@testdb db_1]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.42
OPatch succeeded.

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