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 6880880 (12.2.0.1.45) issued on Jan-2025 on 19C Database

Posted by Mir Sayeed Hassan on January 29th, 2025

Apply the latest OPatch 6880880 (12.2.0.1.45) issued on Jan-2025 on 19C 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@ora19ctdb ~]$ $ORACLE_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/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.42
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2025-01-29_05-02-32AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2025-01-29_05-02-32AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ora19ctdb
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 Thu Jun 08 06:20:01 EDT 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.
[oracle@ora19ctdb ~]$ $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@ora19ctdb ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.42
OPatch succeeded.
[oracle@ora19ctdb ~]$ cd /u02/source/OPATCH_12.2.0.1.42/
[oracle@ora19ctdb OPATCH_12.2.0.1.45]$ ls
p6880880_190000_Linux-x86-64.zip
[oracle@ora19ctdb OPATCH_12.2.0.1.45]$ cp p6880880_190000_Linux-x86-64.zip $ORACLE_HOME/
[oracle@ora19ctdb OPATCH_12.2.0.1.45]$ cd $ORACLE_HOME/
[oracle@test19cdb db_1]$ mv OPatch OPatch_BKP1
[oracle@ora19ctdb 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/emdpatch.pl
extracting: OPatch/version.txt
creating: OPatch/private/
inflating: OPatch/private/commons-compress-1.26.0.jar
inflating: OPatch/private/jaxb-api-2.2.3.jar
----
----
[oracle@ora19ctdb db_1]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.45
OPatch succeeded.

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

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>