Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

Apply the Latest OPatch (12.2.0.1.34) Nov-2022 for Oracle Database 19c

Posted by Mir Sayeed Hassan on December 6th, 2022

Apply the Latest OPatch (12.2.0.1.34) Nov-2022 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
---------------- --------------
oemswdb 19.0.0.0.0 READ WRITE

Check the last updated OPatch

[oracle@PROD-DB ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2022, 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.17
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-12-06_12-07-07PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/lsinv/lsinventory2022-12-06_12-07-07PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: PROD-DB
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) :
---
---
OPatch succeeded.

or

[oracle@PROD-DB ~]$ $ORACLE_HOME/OPatch/opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)

OPatch succeeded.

or

[oracle@PROD-DB ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.

Download the latest OPatch from Oracle Support

https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=19u5iirfot_4&_afrLoop=181282236396168

Move the above downloaded OPatch file into the OPatch Home

[oracle@PROD-DB ~]$ cd /u01/source/
[oracle@PROD-DB source]$ cp p6880880_190000_Linux-x86-64.zip $ORACLE_HOME/OPatch

[oracle@PROD-DB ~]$ cp $ORACLE_HOME/OPatch  $ORACLE_HOME/OPatch_BACKUP
Provide the permission to run the OPatch

[oracle@PROD-DB ~]$ cd $ORACLE_HOME/OPatch/

[oracle@PROD-DB OPatch]$ ll p6880880_190000_Linux-x86-64.zip
-rw-r–r–. 1 oracle oinstall 125736027 Dec 6 12:18 p6880880_190000_Linux-x86-64.zip

[oracle@PROD-DB OPatch]$ chmod 777 p6880880_190000_Linux-x86-64.zip

Copy the OPatch to Backup

Start Applying the OPatch

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

Verify the Last updated OPatch Applied on Oracle Database 19c

[oracle@PROD-DB OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.34
OPatch succeeded.

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