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.