Patching
July 11, 2026
27 min read
26 views
Apply Oracle 19.27 patch only on Grid Home
Apply 19.27 patch only on GRID_HOME
Based on the detailed patching evidence you provided, this can be documented as a successful Oracle 19c RAC Grid Infrastructure and Database RU 19.27 patching activity on AIX using OPatchAuto, with one expected MGMTDB datapatch warning on the second node. Environment -Oracle RAC 19c on AIX -2-node cluster (node01 and node02) -Current version before patching: -GI RU: 19.17 -DB RU: 19.27 already present on RDBMS Home Target RU: -19.27.0.0 1] Check opatch lspatches output (node01) [grid]$ /u01/app/19.0.0/grid/OPatch/opatch lspatches 34580338;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34580338) 34444834;OCW RELEASE UPDATE 19.17.0.0.0 (34444834) 34428761;ACFS RELEASE UPDATE 19.17.0.0.0 (34428761) 34419443;Database Release Update : 19.17.0.0.221018 (34419443) 33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402) (node01) [oracle]$ /u01/app/oracle/product/19.0.0/dbhome_1/OPatch > opatch lspatches 37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975) 37642901;Database Release Update : 19.27.0.0.250415 (37642901) 37499406;OJVM RELEASE UPDATE: 19.27.0.0.250415 (37499406) (node02) [grid]$ /u01/app/19.0.0/grid/OPatch/opatch lspatches 34580338;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34580338) 34444834;OCW RELEASE UPDATE 19.17.0.0.0 (34444834) 34428761;ACFS RELEASE UPDATE 19.17.0.0.0 (34428761) 34419443;Database Release Update : 19.17.0.0.221018 (34419443) 33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402) (node02) [oracle]$ /u01/app/oracle/product/19.0.0/dbhome_1/OPatch > opatch lspatches 37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975) 37642901;Database Release Update : 19.27.0.0.250415 (37642901) 37499406;OJVM RELEASE UPDATE: 19.27.0.0.250415 (37499406) 2] Check whether Oracle Inventory is consistent on each GRID_HOME and RDBMS_HOME: (node01) [grid]$ $GRID_HOME/OPatch/opatch lsinventory -detail -oh $GRID_HOME ARU platform description:: IBM_AIX Patch description: "TOMCAT RELEASE UPDATE 19.0.0.0.0 (34580338)" Patch description: "OCW RELEASE UPDATE 19.17.0.0.0 (34444834)" Patch description: "ACFS RELEASE UPDATE 19.17.0.0.0 (34428761)" Patch description: "Database Release Update : 19.17.0.0.221018 (34419443)" Patch description: "DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)" (node01) [oracle] $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME Patch description: "OCW RELEASE UPDATE 19.27.0.0.0 (37654975)" Patch description: "ORA-06502 PL/SQL NUMERIC OR VALUE ERROR CHARACTER STRING BUFFER TOO SMALL FOR DBMS_AQADM.MOVE_QUEUE_TABLE" Patch description: "FAILED TO ELEVATE VKTMS PRIORITY IN AIX WITH EVENT 10795 SET" Patch description: "Database Release Update : 19.27.0.0.250415 (37642901)" Patch description: "OJVM RELEASE UPDATE: 19.27.0.0.250415 (37499406)" 3] Patch stage folder permission and owner. Folder must have 755 permission and owner oracle. (node01) [grid]$ ls -latr /u03/19c_patch/37641958 drwxr-xr-x 5 oracle dba 4096 Apr 24 2025 37643161 drwxr-xr-x 4 oracle dba 4096 Apr 24 2025 37642901 drwxr-xr-x 5 oracle dba 4096 Apr 24 2025 37654975 drwxr-xr-x 4 oracle dba 4096 Apr 24 2025 36758186 drwxr-x--- 2 oracle dba 4096 Apr 24 2025 automation -rw-r--r-- 1 oracle dba 0 Apr 24 2025 README.txt drwxr-xr-x 4 oracle dba 4096 Apr 24 2025 37762426 -rw-r--r-- 1 oracle dba 152522 Apr 24 2025 README.html -rw-rw-r-- 1 oracle dba 5824 Apr 24 2025 bundle.xml 4] OPatch upgrade on both grid and oracle home on both the nodes 4.1 Grid home OPatch upgrade. (node01) [root]$ $GRID_HOME/OPatch/opatch version (node01) [root]$ cp /home/oracle/Patches/p6880880_190000_Linux-x86–64.zip /u01/app/19.0.0/grid/ (node01) [root]$ cd /u01/app/19.0.0/grid/ (node01) [root]$ ls -ld OPatch (node01) [root]$ mv OPatch OPatch_bkp_date (node01) [root]$ unzip p6880880_190000_Linux-x86–64.zip Archive: p6880880_190000_AIX64-5L.zip creating: OPatch/ creating: OPatch/oracle_common/ creating: OPatch/oracle_common/modules/ (node01) [root]$ chown -R grid:dba OPatch (node01) [grid]$ $GRID_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.49 OPatch succeeded. 4.2 Oracle home OPatch upgrade. (node01) [oracle]$ $ORACLE_HOME/OPatch/opatch version (node01) [oracle]$ cp /home/oracle/Patches/p6880880_190000_Linux-x86–64.zip /u01/app/oracle/product/19.0.0/dbhome_1 (node01) [oracle]$ cd /u01/app/oracle/product/19.0.0/dbhome_1 (node01) [oracle]$ ls -ld OPatch (node01) [oracle]$ mv OPatch OPatch_bkp_date (node01) [oracle]$ unzip p6880880_190000_Linux-x86–64.zip Archive: p6880880_190000_AIX64-5L.zip creating: OPatch/ creating: OPatch/oracle_common/ creating: OPatch/oracle_common/modules/ (node01) [oracle]$ $ORACLE_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.49 OPatch succeeded. 4.3 Grid home OPatch upgrade. (node02) [root]$ $ORACLE_HOME/OPatch/opatch version (node02) [root]$ cp /home/oracle/Patches/p6880880_190000_Linux-x86–64.zip /u01/app/19.0.0/grid/ (node02) [root]$ cd /u01/app/19.0.0/grid/ (node02) [root]$ ls -ld OPatch (node02) [root]$ mv OPatch OPatch_bkp_date (node02) [root]$ unzip p6880880_190000_Linux-x86–64.zip Archive: p6880880_190000_AIX64-5L.zip creating: OPatch/ creating: OPatch/oracle_common/ creating: OPatch/oracle_common/modules/ (node02) [root]$ chown -R grid:dba OPatch (node02) [grid]$ $GRID_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.49 OPatch succeeded. 4.4 Oracle home OPatch upgrade. (node02) [oracle]$ $ORACLE_HOME/OPatch/opatch version (node02) [oracle]$ cp /home/oracle/Patches/p6880880_190000_Linux-x86–64.zip /u01/app/oracle/product/19.0.0/dbhome_1 (node02) [oracle]$ cd /u01/app/oracle/product/19.0.0/dbhome_1 (node02) [oracle]$ ls -ld OPatch (node02) [oracle]$ mv OPatch OPatch_bkp_date (node02) [oracle]$ unzip p6880880_190000_Linux-x86–64.zip Archive: p6880880_190000_AIX64-5L.zip creating: OPatch/ creating: OPatch/oracle_common/ creating: OPatch/oracle_common/modules/ (node02) [oracle]$ $ORACLE_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.49 OPatch succeeded. 5] Copy below patch details in the text file on both the nodes. (node01) [grid]$ vi /tmp/patch_conflict.txt /u03/19c_patch/37641958/37643161 /u03/19c_patch/37641958/37642901 /u03/19c_patch/37641958/37654975 /u03/19c_patch/37641958/36758186 /u03/19c_patch/37641958/37762426 6] As grid owner check the OPatch Conflict for GRID_HOME (node01) [grid]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u03/19c_patch/37641958/37643161 -oh /u01/app/19.0.0/grid Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2026-03-15_11-39-42AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. (node01) [grid]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u03/19c_patch/37641958/37642901 -oh /u01/app/19.0.0/grid Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2026-03-15_11-55-18AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. (node01) [grid]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u03/19c_patch/37641958/37654975 -oh /u01/app/19.0.0/grid Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2026-03-15_12-23-51PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. (node01) [grid]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u03/19c_patch/37641958/36758186 -oh /u01/app/19.0.0/grid Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2026-03-15_12-41-16PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. (node01) [grid]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u03/19c_patch/37641958/37762426 -oh /u01/app/19.0.0/grid Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2026-03-15_12-58-34PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. 7] As oracle owner check the OPatch Conflict for ORACLE_HOME. (node01) [oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u03/19c_patch/37641958/37643161 -oh /u01/app/oracle/product/19.0.0/dbhome_1 Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-03-15_01-10-28PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. (node01) [oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u03/19c_patch/37641958/37642901 -oh /u01/app/oracle/product/19.0.0/dbhome_1 Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-03-15_01-28-44PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. (node01) [oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u03/19c_patch/37641958/37654975 -oh /u01/app/oracle/product/19.0.0/dbhome_1 Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-03-15_01-43-57PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. (node01) [oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u03/19c_patch/37641958/36758186 -oh /u01/app/oracle/product/19.0.0/dbhome_1 Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-03-15_01-57-11PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. 8] Check the free space in the GRID and ORACLE_HOME. (node01) [grid]$ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_conflict.txt -oh /u01/app/19.0.0/grid Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2026-06-10_02-07-28PM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. (node01) [oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_conflict.txt -oh /u01/app/oracle/product/19.0.0/dbhome_1 Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-06-10_02-21-46PM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. (node02) [grid]$ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_conflict.txt -oh /u01/app/19.0.0/grid Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.0.0/grid Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/19.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2026-06-10_02-35-28PM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. (node02) [oracle]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_conflict.txt -oh /u01/app/oracle/product/19.0.0/dbhome_1 Oracle Interim Patch Installer version 12.2.0.1.49 Copyright (c) 2026, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 Central Inventory : /u01/app/19.0.0/oraInventory from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.49 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-06-10_02-43-46PM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. 9] As a root owner execute analyze on node01 (node01) [root]$ $GRID_HOME/OPatch/opatchauto apply /u03/19c_patch/37641958 -analyze OPatchauto session is initiated at Sun Mar 15 03:04:56 2026 System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2026-03-15_03-06-16PM.log. Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2026-03-15_03-08-18PM.log The id for this session is HUHK Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid Patch applicability verified successfully on home /u01/app/19.0.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/dbhome_1 Executing patch validation checks on home /u01/app/19.0.0/grid Patch validation checks successfully completed on home /u01/app/19.0.0/grid Executing patch validation checks on home /u01/app/oracle/product/19.0.0/dbhome_1 Patch validation checks successfully completed on home /u01/app/oracle/product/19.0.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:node01 CRS Home:/u01/app/19.0.0/grid Version:19.0.0.0.0 ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /u03/19c_patch/37641958/37654975 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_03-09-15PM_1.log Patch: /u03/19c_patch/37641958/37643161 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_03-09-15PM_1.log Patch: /u03/19c_patch/37641958/36758186 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_03-09-15PM_1.log Patch: /u03/19c_patch/37641958/37762426 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_03-09-15PM_1.log Patch: /u03/19c_patch/37641958/37642901 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_03-09-15PM_1.log Host:node01 RAC Home:/u01/app/oracle/product/19.0.0/dbhome_1 Version:19.0.0.0.0 ==Following patches were SKIPPED: Patch: /u03/19c_patch/37641958/37643161 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /u03/19c_patch/37641958/36758186 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /u03/19c_patch/37641958/37762426 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /u03/19c_patch/37641958/37642901 Log: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_03-11-53PM_1.log Reason: /u03/19c_patch/37641958/37642901 is not required to be applied to oracle home /u01/app/oracle/product/19.0.0/dbhome_1 ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /u03/19c_patch/37641958/37654975 Log: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_03-11-53PM_1.log OPatchauto session completed at Sun Mar 15 03:23:24 2026 Time taken to complete the session 17 minutes, 9 seconds OPatchauto session completed Time taken to complete the session 12 minutes, 44 seconds [root] /home/root > 10] Apply patch using opatchauto on node01 (node01) [root]# $GRID_HOME/OPatch/opatchauto apply /u03/19c_patch/37641958 -skip_datapatch OPatchauto session is initiated at Sun Mar 15 04:46:53 2026 System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2026-03--48-29PM.log. 15_04 Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2026-03-15_04-50-38PM.log The id for this session is GTX6 Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid Patch applicability verified successfully on home /u01/app/19.0.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/dbhome_1 Executing patch validation checks on home /u01/app/19.0.0/grid Patch validation checks successfully completed on home /u01/app/19.0.0/grid Executing patch validation checks on home /u01/app/oracle/product/19.0.0/dbhome_1 Patch validation checks successfully completed on home /u01/app/oracle/product/19.0.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1 No sqlpatch prereq operations are required on the local node for this home No step execution required......... Preparing to bring down database service on home /u01/app/oracle/product/19.0.0/dbhome_1 No step execution required......... Bringing down database service on home /u01/app/oracle/product/19.0.0/dbhome_1 Following database(s) and/or service(s) are stopped and will be restarted later during the session: LISTENER_TEST Database service successfully brought down on home /u01/app/oracle/product/19.0.0/dbhome_1 Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0/grid Prepatch operation log file location: /u01/app/19.0.0/oraclebase/crsdata/node01/crsconfig/crs_prepatch_apply_inplace_node01_2026-03-15_01-06-35PM.log CRS service brought down successfully on home /u01/app/19.0.0/grid Performing prepatch operation on home /u01/app/oracle/product/19.0.0/dbhome_1 Prepatch operation completed successfully on home /u01/app/oracle/product/19.0.0/dbhome_1 Start applying binary patch on home /u01/app/oracle/product/19.0.0/dbhome_1 Successfully executed command: /usr/sbin/slibclean Binary patch applied successfully on home /u01/app/oracle/product/19.0.0/dbhome_1 Running rootadd_rdbms.sh on home /u01/app/oracle/product/19.0.0/dbhome_1 Successfully executed rootadd_rdbms.sh on home /u01/app/oracle/product/19.0.0/dbhome_1 Performing postpatch operation on home /u01/app/oracle/product/19.0.0/dbhome_1 Postpatch operation completed successfully on home /u01/app/oracle/product/19.0.0/dbhome_1 Start applying binary patch on home /u01/app/19.0.0/grid Successfully executed command: /usr/sbin/slibclean Binary patch applied successfully on home /u01/app/19.0.0/grid Running rootadd_rdbms.sh on home /u01/app/19.0.0/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19.0.0/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.0.0/grid Postpatch operation log file location: /u01/app/19.0.0/oraclebase/crsdata/node01/crsconfig/crs_postpatch_apply_inplace_node01_2026-03-15_04-55-41PM.log CRS service started successfully on home /u01/app/19.0.0/grid Starting database service on home /u01/app/oracle/product/19.0.0/dbhome_1 Database service successfully started on home /u01/app/oracle/product/19.0.0/dbhome_1 Preparing home /u01/app/oracle/product/19.0.0/dbhome_1 after database service restarted No step execution required......... Trying to apply SQL patch on home /u01/app/oracle/product/19.0.0/dbhome_1 No SQL patch operations are required on local node for this home OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:node01 RAC Home:/u01/app/oracle/product/19.0.0/dbhome_1 Version:19.0.0.0.0 Summary: ==Following patches were SKIPPED: Patch: /u03/19c_patch/37641958/37643161 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /u03/19c_patch/37641958/36758186 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /u03/19c_patch/37641958/37762426 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /u03/19c_patch/37641958/37642901 Log: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_04-54-43PM_1.log Reason: /u03/19c_patch/37641958/37642901 is not required to be applied to oracle home /u01/app/oracle/product/19.0.0/dbhome_1 ==Following patches were SUCCESSFULLY applied: Patch: /u03/19c_patch/37641958/37654975 Log: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_05-09-52PM_1.log Host:node01 CRS Home:/u01/app/19.0.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u03/19c_patch/37641958/36758186 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_05-19-04PM_1.log Patch: /u03/19c_patch/37641958/37642901 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_05-19-04PM_1.log Patch: /u03/19c_patch/37641958/37643161 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_05-19-04PM_1.log Patch: /u03/19c_patch/37641958/37654975 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_05-19-04PM_1.log Patch: /u03/19c_patch/37641958/37762426 Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2026-03-15_05-19-04PM_1.log OPatchauto session completed
11] Result on Node01 (node01) [grid]$ $GRID_HOME/OPatch/opatch lspatches 37762426;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37762426) 37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975) 37643161;ACFS RELEASE UPDATE 19.27.0.0.0 (37643161) 37642901;Database Release Update : 19.27.0.0.250415 (37642901) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) (node01) [oracle]$ $ORACLE_HOME/OPatch/opatch lspatches 37762426;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37762426) 37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975) 37643161;ACFS RELEASE UPDATE 19.27.0.0.0 (37643161) 37642901;Database Release Update : 19.27.0.0.250415 (37642901) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) 12] Apply patch Grid patch on node02: [root]# $GRID_HOME/OPatch/opatchauto apply /u03/19c_patch/37641958 -skip_datapatch OPatchauto session is initiated at Sun Mar 15 05:28:17 2026 System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2026-03-15_05-30-08PM.log. Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2026-03-15_05-32-12PM.log The id for this session is ELBM Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid Patch applicability verified successfully on home /u01/app/19.0.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/dbhome_1 Executing patch validation checks on home /u01/app/19.0.0/grid Patch validation checks successfully completed on home /u01/app/19.0.0/grid Executing patch validation checks on home /u01/app/oracle/product/19.0.0/dbhome_1 Patch validation checks successfully completed on home /u01/app/oracle/product/19.0.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/dbhome_1 No sqlpatch prereq operations are required on the local node for this home No step execution required......... Preparing to bring down database service on home /u01/app/oracle/product/19.0.0/dbhome_1 No step execution required......... Bringing down database service on home /u01/app/oracle/product/19.0.0/dbhome_1 Following database(s) and/or service(s) are stopped and will be restarted later during the session: LISTENER_EAA,lara_eaa Database service successfully brought down on home /u01/app/oracle/product/19.0.0/dbhome_1 Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0/grid Prepatch operation log file location: /u01/app/19.0.0/oraclebase/crsdata/mrsda00204/crsconfig/crs_prepatch_apply_inplace_mrsda00204_2026-03-15_03-43-26PM.log CRS service brought down successfully on home /u01/app/19.0.0/grid Performing prepatch operation on home /u01/app/oracle/product/19.0.0/dbhome_1 Prepatch operation completed successfully on home /u01/app/oracle/product/19.0.0/dbhome_1 Start applying binary patch on home /u01/app/oracle/product/19.0.0/dbhome_1 Successfully executed command: /usr/sbin/slibclean Binary patch applied successfully on home /u01/app/oracle/product/19.0.0/dbhome_1 Running rootadd_rdbms.sh on home /u01/app/oracle/product/19.0.0/dbhome_1 Successfully executed rootadd_rdbms.sh on home /u01/app/oracle/product/19.0.0/dbhome_1 Performing postpatch operation on home /u01/app/oracle/product/19.0.0/dbhome_1 Postpatch operation completed successfully on home /u01/app/oracle/product/19.0.0/dbhome_1 Start applying binary patch on home /u01/app/19.0.0/grid Successfully executed command: /usr/sbin/slibclean Binary patch applied successfully on home /u01/app/19.0.0/grid Running rootadd_rdbms.sh on home /u01/app/19.0.0/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19.0.0/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.0.0/grid Postpatch operation log file location: /u01/app/19.0.0/oraclebase/crsdata/node02/crsconfig/crs_postpatch_apply_inplace_node02_2026-03-15_05-30-18PM.log Log file for this invocation: /u01/app/19.0.0/oraclebase/cfgtoollogs/sqlpatch/sqlpatch_66585236_2026_06_08_05_36_08/sqlpatch_invocation.log Connecting to database...OK Gathering database info...done Note: Datapatch will only apply or rollback SQL fixes for PDBs that are in an open state, no patches will be applied to closed PDBs. Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation (Doc ID 1585822.1) Bootstrapping registry and package to current versions...done Determining current state...done Current state of interim SQL patches: No interim patches found Current state of release update SQL patches: Binary registry: 19.27.0.0.0 Release_Update 250411104622: Installed PDB CDB$ROOT: Applied 19.17.0.0.0 Release_Update 220928055956 successfully on 20-NOV-23 02.52.40.002730 PM PDB GIMR_DSCREP_10: Applied 19.17.0.0.0 Release_Update 220928055956 successfully on 20-NOV-23 02.52.50.994227 PM PDB PDB$SEED: Applied 19.17.0.0.0 Release_Update 220928055956 successfully on 20-NOV-23 02.52.45.436857 PM Adding patches to installation queue and performing prereq checks...done Installation queue: For the following PDBs: CDB$ROOT PDB$SEED GIMR_DSCREP_10 No interim patches need to be rolled back Patch 37642901 (Database Release Update : 19.27.0.0.250415 (37642901)): Apply from 19.17.0.0.0 Release_Update 220928055956 to 19.27.0.0.0 Release_Update 250411104622 No interim patches need to be applied Installing patches... Patch installation complete. Total patches installed: 3 Validating logfiles...done Patch 37642901 apply (pdb CDB$ROOT): SUCCESS logfile: /u01/app/19.0.0/oraclebase/cfgtoollogs/sqlpatch/37642901/27283941/37642901_apply__MGMTDB_CDBROOT_2026Mar15_05_37_42.log (no errors) Patch 37642901 apply (pdb PDB$SEED): SUCCESS logfile: /u01/app/19.0.0/oraclebase/cfgtoollogs/sqlpatch/37642901/27283941/37642901_apply__MGMTDB_PDBSEED_2026Mar15_05_40_42.log (no errors) Patch 37642901 apply (pdb GIMR_DSCREP_10): SUCCESS logfile: /u01/app/19.0.0/oraclebase/cfgtoollogs/sqlpatch/37642901/27283941/37642901_apply__MGMTDB_GIMR_DSCREP_10_2026Mar15_05_40_42.log (no errors) SQL Patching tool complete on Sun Mar 15 14:43:06 2026 Calling datapatch SQL Patching tool version 19.27.0.0.0 Production on Sun Mar 15 05:43:51 2026 Copyright (c) 2012, 2025, Oracle. All rights reserved. Log file for this invocation: /u01/app/19.0.0/oraclebase/cfgtoollogs/sqlpatch/sqlpatch_57147740_2026_06_08_05_43_51/sqlpatch_invocation.log Connecting to database... Error: prereq checks failed! Database connect failed with: ORA-12162: TNS:net service name is incorrectly specified (DBD ERROR: OCIServerAttach)====> (MGMTDB Datapatch Warning) Please refer to MOS Note 1609718.1 and/or the invocation log /u01/app/19.0.0/oraclebase/cfgtoollogs/sqlpatch/sqlpatch_57147740_2026_06_08_05_43_51/sqlpatch_invocation.log for information on how to resolve the above errors. SQL Patching tool complete on Sun Mar 15 05:43:51 2026 Datapatch exits with code 1 2026/06/08 14:43:53 CLSRSC-180: An error occurred while executing the command '/u01/app/19.0.0/grid/bin/mgmtca applysql' After fixing the cause of failure Run opatchauto resume OPATCHAUTO-68061: The orchestration engine failed. OPATCHAUTO-68061: The orchestration engine failed with return code 1 OPATCHAUTO-68061: Check the log for more details. OPatchAuto failed. OPatchauto session completed at Sun Mar 15 14:44:02 2026 Time taken to complete the session 73 minutes, 21 seconds opatchauto failed with error code 42 Note: Above error can be ignored because its failed while applying datapatch on MGMTDB. 12] Final Patch verification on both Grid and Oracle home on node02. (node02) [grid]$ $GRID_HOME/OPatch/opatch lspatches 37762426;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37762426) 37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975) 37643161;ACFS RELEASE UPDATE 19.27.0.0.0 (37643161) 37642901;Database Release Update : 19.27.0.0.250415 (37642901) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) (node02) [grid]$ $GRID_HOME/OPatch/opatch lspatches 37762426;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37762426) 37654975;OCW RELEASE UPDATE 19.27.0.0.0 (37654975) 37643161;ACFS RELEASE UPDATE 19.27.0.0.0 (37643161) 37642901;Database Release Update : 19.27.0.0.250415 (37642901) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) 13] Final Outcome -OPatch upgraded successfully on all homes -Patch conflict checks passed -Space validation passed -OPatchAuto analysis passed -Grid Infrastructure patched to 19.27 -CRS services restored successfully -Patch inventory synchronized across cluster nodes -Cluster ready for post-patch validation and datapatch execution on application databases Patch sucessfully applied on Grid Home – Oracle RAC GI and DB upgraded to RU 19.27.0.0
Community Discussion
Be the first to share your thoughts on this technical deep dive.
