暂无图片
暂无图片
6
暂无图片
暂无图片
暂无图片

Oracle 19c RAC 19.29 RU 补丁实战指南

原创 孙莹 2025-10-24
889

Oracle 19c RAC 19.29 RU 补丁实战指南

适用版本:Oracle Database 19.3.0 → 19.29.0
环境:RAC 双节点(rac1 / rac2),OS 为 Oracle Linux 7.9
补丁类型:RU (Release Update) 19.29.0.0.251021
工具:opatchauto / opatch


一、补丁简介

Oracle 从 19c 开始采用 Release Update (RU) 模型,每季度发布一次补丁包(通常为 1、4、7、10 月)。本次操作目标:将现有 19.3 RAC 环境升级到 19.29,同步更新 Grid Infrastructure (GI)Database Home。2025年 10 月 21 日,Oracle 2025 年第三季度 RU 补丁发布。如下所示:

补丁号 补丁名 发布日期 文件名
Patch 38291812 DATABASE RELEASE UPDATE 19.29.0.0.0 2025-10-21 p38291812_190000_Linux-x86-64.zip
Patch 38298204 GI RELEASE UPDATE 19.29.0.0.0 2025-10-21 p38298204_190000_Linux-x86-64.zip
Patch 38194382 OJVM RELEASE UPDATE 19.29.0.0.0 2025-10-21 p38194382_190000_Linux-x86-64.zip
Patch 6880880 OPatch 12.2.0.1.47 for DB 23.0.0.0.0 2025-07-16 p6880880_190000_Linux-x86-64.zip

将所有补丁文件上传到rac1、rac2服务器上/root目录下。

[root@rac1 ~]# ls -lh *.zip -rw-r--r-- 1 root root 124M Oct 23 16:44 p38194382_190000_Linux-x86-64.zip -rw-r--r-- 1 root root 2.2G Oct 23 16:44 p38291812_190000_Linux-x86-64.zip -rw-r--r-- 1 root root 3.8G Oct 23 16:45 p38298204_190000_Linux-x86-64.zip -rw-r--r-- 1 root root 70M Oct 23 16:44 p6880880_190000_Linux-x86-64.zip [root@rac1 ~]# pwd /root [root@rac1 ~]#

二、环境检查与备份

在打补丁前,必须确认如下信息:

[grid@rac1:/home/grid]$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [19.0.0.0.0] [grid@rac1:/home/grid]$ # 确认无冲突补丁或旧版本冲突 [grid@rac1:/home/grid]$ opatch lsinventory | grep "Patch description" Patch description: "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)" Patch description: "ACFS RELEASE UPDATE 19.3.0.0.0 (29517247)" Patch description: "Database Release Update : 19.3.0.0.190416 (29517242)" Patch description: "TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)" [grid@rac1:/home/grid]$ opatch lspatches 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247) 29517242;Database Release Update : 19.3.0.0.190416 (29517242) 29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763) OPatch succeeded. [grid@rac1:/home/grid]$ [grid@rac1:/home/grid]$ olsnodes -n rac1 1 rac2 2 [grid@rac1:/home/grid]$ [oracle@rac1:/home/oracle]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 23 19:36:04 2025 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> select * from product_component_version; PRODUCT -------------------------------------------------------------------------------- VERSION -------------------------------------------------------------------------------- VERSION_FULL -------------------------------------------------------------------------------- STATUS -------------------------------------------------------------------------------- Oracle Database 19c Enterprise Edition 19.0.0.0.0 19.3.0.0.0 Production SQL>

备份 CRS 配置:

/u01/app/19.3.0/grid/bin/ocrconfig -showbackuploc /u01/app/19.3.0/grid/bin/ocrconfig -backuploc +DATA /u01/app/19.3.0/grid/bin/ocrconfig -manualbackup [root@rac1 ~]# /u01/app/19.3.0/grid/bin/ocrconfig -showbackuploc The Oracle Cluster Registry backup location is [+OCRVOTE]. [root@rac1 ~]# /u01/app/19.3.0/grid/bin/ocrconfig -backuploc +DATA [root@rac1 ~]# /u01/app/19.3.0/grid/bin/ocrconfig -manualbackup rac1 2025/10/23 19:21:32 +DATA:/rac-cluster/OCRBACKUP/backup_20251023_192132.ocr.279.1215285693 724960844 [root@rac1 ~]#

检查空间:

[grid@rac1:/home/grid]$ df -h /u01/app/19.3.0/grid/
Filesystem           Size  Used Avail Use% Mounted on
/dev/mapper/ol-root   56G   26G   30G  48% /
[grid@rac1:/home/grid]$


三、升级opatch版本

至少预留 10GB 可用空间。

⚠️ 确认两节点环境一致:

  • ORACLE_HOME、GI_HOME 路径相同
  • opatch 工具版本匹配

升级 opatch 工具(必须 ≥ 12.2.0.1.47)双节点grid、oracle用户都做:

cd /u01/app/19.3.0/grid/OPatch ./opatch version cd .. mv OPatch OPatch_bak unzip -q /root/p6880880_190000_Linux-x86-64.zip -d /u01/app/19.3.0/grid chown -R grid:oinstall /u01/app/19.3.0/grid/OPatch su - grid opatch version cd /u01/app/oracle/product/19.3.0/dbhome_1/OPatch ./opatch version cd .. mv OPatch OPatch_bak unzip -q /root/p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19.3.0/dbhome_1 chown -R oracle:oinstall /u01/app/oracle/product/19.3.0/dbhome_1/OPatch su - oracle opatch version [root@rac1 ~]# cd /u01/app/19.3.0/grid/OPatch [root@rac1 OPatch]# ./opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. [root@rac1 OPatch]# cd .. [root@rac1 grid]# mv OPatch OPatch_bak [root@rac1 grid]# unzip -q /soft/p6880880_190000_Linux-x86-64.zip -d /u01/app/19.3.0/grid [root@rac1 grid]# chown -R grid:oinstall /u01/app/19.3.0/grid/OPatch [root@rac1 grid]# su - grid Last login: Thu Oct 23 16:43:05 CST 2025 [grid@rac1:/home/grid]$ opatch version OPatch Version: 12.2.0.1.47 OPatch succeeded. [grid@rac1:/home/grid]$ [root@rac1 ~]# cd /u01/app/oracle/product/19.3.0/dbhome_1/OPatch [root@rac1 OPatch]# ./opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. [root@rac1 OPatch]# cd .. [root@rac1 dbhome_1]# mv OPatch OPatch_bak [root@rac1 dbhome_1]# unzip -q /root/p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19.3.0/dbhome_1 [root@rac1 dbhome_1]# chown -R oracle:oinstall /u01/app/oracle/product/19.3.0/dbhome_1/OPatch [root@rac1 dbhome_1]# su - oracle Last login: Thu Oct 23 20:18:54 CST 2025 on pts/0 [oracle@rac1:/home/oracle]$ opatch version OPatch Version: 12.2.0.1.47 OPatch succeeded. [oracle@rac1:/home/oracle]$ [root@rac2 ~]# cd /u01/app/19.3.0/grid/OPatch [root@rac2 OPatch]# ./opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. [root@rac2 OPatch]# cd .. [root@rac2 grid]# mv OPatch OPatch_bak [root@rac2 grid]# unzip -q /root/p6880880_190000_Linux-x86-64.zip -d /u01/app/19.3.0/grid [root@rac2 grid]# chown -R grid:oinstall /u01/app/19.3.0/grid/OPatch [root@rac2 grid]# su - grid Last login: Thu Oct 23 20:13:32 CST 2025 [grid@rac2:/home/grid]$ opatch version OPatch Version: 12.2.0.1.47 OPatch succeeded. [grid@rac2:/home/grid]$ [root@rac2 ~]# cd /u01/app/oracle/product/19.3.0/dbhome_1/OPatch [root@rac2 OPatch]# ./opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. [root@rac2 OPatch]# cd .. [root@rac2 dbhome_1]# mv OPatch OPatch_bak [root@rac2 dbhome_1]# unzip -q /root/p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19.3.0/dbhome_1 [root@rac2 dbhome_1]# chown -R oracle:oinstall /u01/app/oracle/product/19.3.0/dbhome_1/OPatch [root@rac2 dbhome_1]# su - oracle Last login: Thu Oct 23 15:36:36 CST 2025 on pts/0 [oracle@rac2:/home/oracle]$ opatch version OPatch Version: 12.2.0.1.47 OPatch succeeded. [oracle@rac2:/home/oracle]$

四、解压补丁包

从 MOS 下载的GI、DB、OJVM补丁解压,并授权:

mkdir -p /u01/patch/19.29 unzip -q p38298204_190000_Linux-x86-64.zip -d /u01/patch/19.29 unzip -q p38291812_190000_Linux-x86-64.zip -d /u01/patch/19.29 unzip -q p38194382_190000_Linux-x86-64.zip -d /u01/patch/19.29 ls -lh /u01/patch/19.29/ chown -R grid:oinstall /u01/patch/19.29/38298204 chmod -R 755 /u01/patch/19.29/38298204 chown -R grid:oinstall /u01/patch/19.29/38194382 chmod -R 755 /u01/patch/19.29/38194382 [root@rac1 ~]# mkdir -p /u01/patch/19.29 [root@rac1 ~]# unzip -q p38298204_190000_Linux-x86-64.zip -d /u01/patch/19.29 [root@rac1 ~]# unzip -q p38291812_190000_Linux-x86-64.zip -d /u01/patch/19.29 replace /u01/patch/19.29/PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: y [root@rac1 ~]# unzip -q p38194382_190000_Linux-x86-64.zip -d /u01/patch/19.29 replace /u01/patch/19.29/PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: y [root@rac1 ~]# ls -lh /u01/patch/19.29/ total 32K drwxr-xr-x 4 root root 67 Oct 7 20:59 38194382 drwxr-xr-x 5 root root 81 Oct 7 01:36 38291812 drwxr-x--- 8 root root 4.0K Oct 16 04:59 38298204 -rw-rw-r-- 1 root root 27K Oct 21 23:38 PatchSearch.xml [root@rac1 ~]# chown -R grid:oinstall /u01/patch/19.29/38298204 [root@rac1 ~]# chmod -R 755 /u01/patch/19.29/38298204 [root@rac1 ~]# chown -R grid:oinstall /u01/patch/19.29/38194382 [root@rac1 ~]# chmod -R 755 /u01/patch/19.29/38194382 [root@rac1 ~]# [root@rac2 ~]# mkdir -p /u01/patch/19.29 [root@rac2 ~]# unzip -q p38298204_190000_Linux-x86-64.zip -d /u01/patch/19.29 [root@rac2 ~]# unzip -q p38291812_190000_Linux-x86-64.zip -d /u01/patch/19.29 replace /u01/patch/19.29/PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: y [root@rac2 ~]# unzip -q p38194382_190000_Linux-x86-64.zip -d /u01/patch/19.29 replace /u01/patch/19.29/PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: y [root@rac2 ~]# ls -lh /u01/patch/19.29/ total 32K drwxr-xr-x 4 root root 67 Oct 7 20:59 38194382 drwxr-xr-x 5 root root 81 Oct 7 01:36 38291812 drwxr-x--- 8 root root 4.0K Oct 16 04:59 38298204 -rw-rw-r-- 1 root root 27K Oct 21 23:38 PatchSearch.xml [root@rac2 ~]# chown -R grid:oinstall /u01/patch/19.29/38298204 [root@rac2 ~]# chmod -R 755 /u01/patch/19.29/38298204 [root@rac2 ~]# chown -R grid:oinstall /u01/patch/19.29/38194382 [root@rac2 ~]# chmod -R 755 /u01/patch/19.29/38194382 [root@rac2 ~]#

目录结构示例:

/u01/patch/19.29/ ├── 38298204/ <--- GI ├── 38291812/ <--- DB ├── 38194382/ <--- OJVM └── README.html

五、打补丁前验证

5.1 兼容性检查

验证opatch inventory有效性,两个节点 grid用户

opatch lsinventory -detail -oh $ORACLE_HOME [grid@rac1:/home/grid]$ opatch lsinventory -detail -oh $ORACLE_HOME Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_19-46-53PM_1.log Lsinventory Output file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2025-10-23_19-46-53PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: rac1 ARU platform id: 226 ARU platform description:: Linux x86-64 。。。省略 Patch Location in Inventory: /u01/app/19.3.0/grid/inventory/oneoffs/29401763 Patch Location in Storage area: /u01/app/19.3.0/grid/.patch_storage/29401763_Apr_11_2019_22_26_25 -------------------------------------------------------------------------------- OPatch succeeded. [grid@rac1:/home/grid]$ [grid@rac2:/home/grid]$ opatch lsinventory -detail -oh $ORACLE_HOME Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_20-26-32PM_1.log Lsinventory Output file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2025-10-23_20-26-32PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: rac2 ARU platform id: 226 ARU platform description:: Linux x86-64 。。。省略 Patch Location in Inventory: /u01/app/19.3.0/grid/inventory/oneoffs/29401763 Patch Location in Storage area: /u01/app/19.3.0/grid/.patch_storage/29401763_Apr_11_2019_22_26_25 -------------------------------------------------------------------------------- OPatch succeeded. [grid@rac2:/home/grid]$

5.2 补丁冲突检查

GI子目录的五个patch和OJVM分别在grid和oracle用户下分别执行检查,两个节点都要执行。

opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/36758186 opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38291812 opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38311528 opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38322923 opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38380425 opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38194382 [grid@rac1:/home/grid]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/36758186 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_19-52-00PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@rac1:/home/grid]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38291812 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_19-53-03PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@rac1:/home/grid]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38311528 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_19-53-59PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@rac1:/home/grid]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38322923 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_19-54-06PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@rac1:/home/grid]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38380425 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_19-54-12PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@rac1:/home/grid]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38194382 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_21-05-44PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@rac1:/home/grid]$ [oracle@rac1:/home/oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/36758186 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-10-23_21-06-21PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@rac1:/home/oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38291812 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-10-23_21-06-31PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@rac1:/home/oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38311528 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-10-23_21-06-42PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@rac1:/home/oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38322923 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-10-23_21-06-49PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@rac1:/home/oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38380425 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-10-23_21-06-58PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@rac1:/home/oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38194382 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-10-23_21-07-05PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@rac1:/home/oracle]$ [grid@rac2:/home/grid]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/36758186 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_21-15-29PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@rac2:/home/grid]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38291812 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_21-15-36PM_1.log Invoking prereq "checkconflictagainstohwithdetail" opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38311528 Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@rac2:/home/grid]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38311528 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_21-15-44PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@rac2:/home/grid]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38322923 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_21-15-52PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@rac2:/home/grid]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38380425 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_21-15-57PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@rac2:/home/grid]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38194382 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_21-16-03PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [grid@rac2:/home/grid]$ [oracle@rac2:/home/oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/36758186 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-10-23_21-16-39PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@rac2:/home/oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38291812 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-10-23_21-16-45PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@rac2:/home/oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38311528 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-10-23_21-16-56PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@rac2:/home/oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38322923 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-10-23_21-17-04PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@rac2:/home/oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38298204/38380425 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-10-23_21-17-09PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@rac2:/home/oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patch/19.29/38194382 Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/19.3.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-10-23_21-17-14PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@rac2:/home/oracle]$

5.3 空间检查

grid用户下,两个节点都要执行。

#grid用户下 vi patch_list_gihome.txt #添加如下 /u01/patch/19.29/38298204/36758186 /u01/patch/19.29/38298204/38291812 /u01/patch/19.29/38298204/38311528 /u01/patch/19.29/38298204/38322923 /u01/patch/19.29/38298204/38380425 /u01/patch/19.29/38194382 opatch prereq CheckSystemSpace -phBaseFile /home/grid/patch_list_gihome.txt [grid@rac1:/home/grid]$ opatch prereq CheckSystemSpace -phBaseFile /home/grid/patch_list_gihome.txt Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_19-58-48PM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. [grid@rac1:/home/grid]$ [grid@rac2:/home/grid]$ vi patch_list_gihome.txt [grid@rac2:/home/grid]$ opatch prereq CheckSystemSpace -phBaseFile /home/grid/patch_list_gihome.txt Oracle Interim Patch Installer version 12.2.0.1.47 Copyright (c) 2025, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/19.3.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.3.0/grid/oraInst.loc OPatch version : 12.2.0.1.47 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2025-10-23_21-18-13PM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded. [grid@rac2:/home/grid]$

5.4 补丁分析检查

root用户下执行,两个节点都要执行。

#root执行,不能在/和/root目录下执行 cd /tmp /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/patch/19.29/38298204 -analyze /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/patch/19.29/38194382 -analyze [root@rac1 tmp]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/patch/19.29/38298204 -analyze OPatchauto session is initiated at Thu Oct 23 20:30:44 2025 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-10-23_08-30-48PM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2025-10-23_08-31-03PM.log The id for this session is 951U Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Patch applicability verified successfully on home /u01/app/19.3.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Executing patch validation checks on home /u01/app/19.3.0/grid Patch validation checks successfully completed on home /u01/app/19.3.0/grid Executing patch validation checks on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:rac1 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /u01/patch/19.29/38298204/38322923 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_20-31-19PM_1.log Patch: /u01/patch/19.29/38298204/38311528 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_20-31-19PM_1.log Patch: /u01/patch/19.29/38298204/36758186 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_20-31-19PM_1.log Patch: /u01/patch/19.29/38298204/38380425 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_20-31-19PM_1.log Patch: /u01/patch/19.29/38298204/38291812 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_20-31-19PM_1.log Host:rac1 RAC Home:/u01/app/oracle/product/19.3.0/dbhome_1 Version:19.0.0.0.0 ==Following patches were SKIPPED: Patch: /u01/patch/19.29/38298204/38311528 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /u01/patch/19.29/38298204/36758186 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /u01/patch/19.29/38298204/38380425 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /u01/patch/19.29/38298204/38322923 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_20-32-10PM_1.log Patch: /u01/patch/19.29/38298204/38291812 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_20-32-10PM_1.log OPatchauto session completed at Thu Oct 23 20:33:36 2025 Time taken to complete the session 2 minutes, 49 seconds [root@rac1 tmp]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/patch/19.29/38194382 -analyze OPatchauto session is initiated at Thu Oct 23 21:21:30 2025 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-10-23_09-21-31PM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2025-10-23_09-21-45PM.log The id for this session is YAKW Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Patch applicability verified successfully on home /u01/app/19.3.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Executing patch validation checks on home /u01/app/19.3.0/grid Patch validation checks successfully completed on home /u01/app/19.3.0/grid Executing patch validation checks on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:rac1 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /u01/patch/19.29/38194382 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-21-51PM_1.log Host:rac1 RAC Home:/u01/app/oracle/product/19.3.0/dbhome_1 Version:19.0.0.0.0 ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /u01/patch/19.29/38194382 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-21-55PM_1.log OPatchauto session completed at Thu Oct 23 21:22:33 2025 Time taken to complete the session 1 minute, 3 seconds [root@rac1 tmp]# [root@rac2 ~]# cd /tmp [root@rac2 tmp]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/patch/19.29/38298204 -analyze OPatchauto session is initiated at Thu Oct 23 21:24:00 2025 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-10-23_09-24-04PM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2025-10-23_09-24-17PM.log The id for this session is 8JXF Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Patch applicability verified successfully on home /u01/app/19.3.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Executing patch validation checks on home /u01/app/19.3.0/grid Patch validation checks successfully completed on home /u01/app/19.3.0/grid Executing patch validation checks on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:rac2 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /u01/patch/19.29/38298204/38322923 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-24-35PM_1.log Patch: /u01/patch/19.29/38298204/38311528 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-24-35PM_1.log Patch: /u01/patch/19.29/38298204/36758186 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-24-35PM_1.log Patch: /u01/patch/19.29/38298204/38380425 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-24-35PM_1.log Patch: /u01/patch/19.29/38298204/38291812 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-24-35PM_1.log Host:rac2 RAC Home:/u01/app/oracle/product/19.3.0/dbhome_1 Version:19.0.0.0.0 ==Following patches were SKIPPED: Patch: /u01/patch/19.29/38298204/38311528 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /u01/patch/19.29/38298204/36758186 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /u01/patch/19.29/38298204/38380425 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /u01/patch/19.29/38298204/38322923 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-25-30PM_1.log Patch: /u01/patch/19.29/38298204/38291812 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-25-30PM_1.log OPatchauto session completed at Thu Oct 23 21:26:46 2025 Time taken to complete the session 2 minutes, 42 seconds [root@rac2 tmp]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/patch/19.29/38194382 -analyze OPatchauto session is initiated at Thu Oct 23 21:27:09 2025 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-10-23_09-27-10PM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2025-10-23_09-27-22PM.log The id for this session is 7BJT Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Patch applicability verified successfully on home /u01/app/19.3.0/grid Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Executing patch validation checks on home /u01/app/19.3.0/grid Patch validation checks successfully completed on home /u01/app/19.3.0/grid Executing patch validation checks on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Analysis for applying patches has completed successfully: Host:rac2 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /u01/patch/19.29/38194382 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-27-28PM_1.log Host:rac2 RAC Home:/u01/app/oracle/product/19.3.0/dbhome_1 Version:19.0.0.0.0 ==Following patches were SUCCESSFULLY analyzed to be applied: Patch: /u01/patch/19.29/38194382 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-27-32PM_1.log OPatchauto session completed at Thu Oct 23 21:28:06 2025 Time taken to complete the session 0 minute, 58 seconds [root@rac2 tmp]#

六、GI和OJVM打补丁

注意opatchauto过程会自动关闭数据库和集群,打完补丁后自动启动集群和数据库。第一个节点完成后,打第二个节点。

root用户两个节点都要分别执行。

#OJVM补丁38194382,root执行,不能在/和/root目录下执行 cd /tmp /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/patch/19.29/38194382 -oh /u01/app/19.3.0/grid #GI补丁38298204,root执行,不能在/和/root目录下执行 /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/patch/19.29/38298204 -oh /u01/app/19.3.0/grid #验证打补丁是否成功 su - grid opatch lspatches opatch lsinventory [root@rac1 ~]# cd /tmp [root@rac1 tmp]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/patch/19.29/38194382 -oh /u01/app/19.3.0/grid OPatchauto session is initiated at Thu Oct 23 21:33:52 2025 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-10-23_09-33-54PM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2025-10-23_09-34-01PM.log The id for this session is RJBC Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Patch applicability verified successfully on home /u01/app/19.3.0/grid Executing patch validation checks on home /u01/app/19.3.0/grid Patch validation checks successfully completed on home /u01/app/19.3.0/grid Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.3.0/grid Prepatch operation log file location: /u01/app/grid/crsdata/rac1/crsconfig/crs_prepatch_rac1_2025-10-23_09-34-11PM.log CRS service brought down successfully on home /u01/app/19.3.0/grid Start applying binary patch on home /u01/app/19.3.0/grid Binary patch applied successfully on home /u01/app/19.3.0/grid Running rootadd_rdbms.sh on home /u01/app/19.3.0/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19.3.0/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.3.0/grid Postpatch operation log file location: /u01/app/grid/crsdata/rac1/crsconfig/crs_postpatch_rac1_2025-10-23_09-37-34PM.log CRS service started successfully on home /u01/app/19.3.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:rac1 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u01/patch/19.29/38194382 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-36-56PM_1.log OPatchauto session completed at Thu Oct 23 21:39:44 2025 Time taken to complete the session 5 minutes, 52 seconds [root@rac1 tmp]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/patch/19.29/38298204 -oh /u01/app/19.3.0/grid OPatchauto session is initiated at Thu Oct 23 21:40:00 2025 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-10-23_09-40-07PM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2025-10-23_09-40-14PM.log The id for this session is D7DS Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Patch applicability verified successfully on home /u01/app/19.3.0/grid Executing patch validation checks on home /u01/app/19.3.0/grid Patch validation checks successfully completed on home /u01/app/19.3.0/grid Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.3.0/grid Prepatch operation log file location: /u01/app/grid/crsdata/rac1/crsconfig/crs_prepatch_apply_inplace_rac1_2025-10-23_09-41-36PM.log CRS service brought down successfully on home /u01/app/19.3.0/grid Start applying binary patch on home /u01/app/19.3.0/grid Binary patch applied successfully on home /u01/app/19.3.0/grid Running rootadd_rdbms.sh on home /u01/app/19.3.0/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19.3.0/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.3.0/grid Postpatch operation log file location: /u01/app/grid/crsdata/rac1/crsconfig/crs_postpatch_apply_inplace_rac1_2025-10-23_09-48-21PM.log CRS service started successfully on home /u01/app/19.3.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:rac1 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u01/patch/19.29/38298204/36758186 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-44-00PM_1.log Patch: /u01/patch/19.29/38298204/38291812 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-44-00PM_1.log Patch: /u01/patch/19.29/38298204/38311528 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-44-00PM_1.log Patch: /u01/patch/19.29/38298204/38322923 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-44-00PM_1.log Patch: /u01/patch/19.29/38298204/38380425 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-44-00PM_1.log OPatchauto session completed at Thu Oct 23 21:51:43 2025 Time taken to complete the session 11 minutes, 37 seconds [root@rac1 tmp]# su - grid Last login: Thu Oct 23 21:52:13 CST 2025 [grid@rac1:/home/grid]$ opatch lspatches 38380425;TOMCAT RELEASE UPDATE 19.0.0.0.0 (38380425) 38322923;OCW RELEASE UPDATE 19.29.0.0.0 (38322923) 38311528;ACFS RELEASE UPDATE 19.29.0.0.0 (38311528) 38291812;Database Release Update : 19.29.0.0.251021 (38291812) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) 38194382;OJVM RELEASE UPDATE: 19.29.0.0.251021 (38194382) OPatch succeeded. [grid@rac1:/home/grid]$ [root@rac2 ~]# cd /tmp [root@rac2 tmp]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/patch/19.29/38194382 -oh /u01/app/19.3.0/grid OPatchauto session is initiated at Thu Oct 23 21:51:55 2025 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-10-23_09-51-56PM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2025-10-23_09-52-14PM.log The id for this session is D9QD Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Patch applicability verified successfully on home /u01/app/19.3.0/grid Executing patch validation checks on home /u01/app/19.3.0/grid Patch validation checks successfully completed on home /u01/app/19.3.0/grid Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.3.0/grid Prepatch operation log file location: /u01/app/grid/crsdata/rac2/crsconfig/crs_prepatch_rac2_2025-10-23_09-52-26PM.log CRS service brought down successfully on home /u01/app/19.3.0/grid Start applying binary patch on home /u01/app/19.3.0/grid Binary patch applied successfully on home /u01/app/19.3.0/grid Running rootadd_rdbms.sh on home /u01/app/19.3.0/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19.3.0/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.3.0/grid Postpatch operation log file location: /u01/app/grid/crsdata/rac2/crsconfig/crs_postpatch_rac2_2025-10-23_09-55-48PM.log CRS service started successfully on home /u01/app/19.3.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:rac2 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u01/patch/19.29/38194382 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_21-55-07PM_1.log OPatchauto session completed at Thu Oct 23 21:58:07 2025 Time taken to complete the session 6 minutes, 13 seconds [root@rac2 tmp]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/patch/19.29/38298204 -oh /u01/app/19.3.0/grid OPatchauto session is initiated at Thu Oct 23 21:58:12 2025 System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-10-23_09-58-17PM.log. Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2025-10-23_09-58-32PM.log The id for this session is NZUK Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid Patch applicability verified successfully on home /u01/app/19.3.0/grid Executing patch validation checks on home /u01/app/19.3.0/grid Patch validation checks successfully completed on home /u01/app/19.3.0/grid Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.3.0/grid Prepatch operation log file location: /u01/app/grid/crsdata/rac2/crsconfig/crs_prepatch_apply_inplace_rac2_2025-10-23_10-00-00PM.log CRS service brought down successfully on home /u01/app/19.3.0/grid Start applying binary patch on home /u01/app/19.3.0/grid Binary patch applied successfully on home /u01/app/19.3.0/grid Running rootadd_rdbms.sh on home /u01/app/19.3.0/grid Successfully executed rootadd_rdbms.sh on home /u01/app/19.3.0/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.3.0/grid Postpatch operation log file location: /u01/app/grid/crsdata/rac2/crsconfig/crs_postpatch_apply_inplace_rac2_2025-10-23_10-06-53PM.log CRS service started successfully on home /u01/app/19.3.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:rac2 CRS Home:/u01/app/19.3.0/grid Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u01/patch/19.29/38298204/36758186 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_22-02-24PM_1.log Patch: /u01/patch/19.29/38298204/38291812 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_22-02-24PM_1.log Patch: /u01/patch/19.29/38298204/38311528 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_22-02-24PM_1.log Patch: /u01/patch/19.29/38298204/38322923 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_22-02-24PM_1.log Patch: /u01/patch/19.29/38298204/38380425 Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_22-02-24PM_1.log OPatchauto session completed at Thu Oct 23 22:10:12 2025 Time taken to complete the session 11 minutes, 55 seconds [root@rac2 tmp]# su - grid Last login: Thu Oct 23 22:10:16 CST 2025 [grid@rac2:/home/grid]$ opatch lspatches 38380425;TOMCAT RELEASE UPDATE 19.0.0.0.0 (38380425) 38322923;OCW RELEASE UPDATE 19.29.0.0.0 (38322923) 38311528;ACFS RELEASE UPDATE 19.29.0.0.0 (38311528) 38291812;Database Release Update : 19.29.0.0.251021 (38291812) 36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186) 38194382;OJVM RELEASE UPDATE: 19.29.0.0.251021 (38194382) OPatch succeeded. [grid@rac2:/home/grid]$

七、DB打补丁

注意打补丁前先关闭整个集群和数据库,不然会报错,第一个节点完成后,打第二个节点。

root用户两个节点都要分别执行。

#root在非/和/root目录下执行,关闭整个集群和数据库 cd /tmp /u01/app/19.3.0/grid/bin/crsctl stop crs /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatchauto apply /u01/patch/19.29/38298204/38291812 -oh /u01/app/oracle/product/19.3.0/dbhome_1 /u01/app/19.3.0/grid/bin/crsctl start crs #验证补丁是否打上 su - oracle opatch lspatches [root@rac1 tmp]# /u01/app/19.3.0/grid/bin/crsctl stop crs CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1' CRS-2673: Attempting to stop 'ora.crsd' on 'rac1' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'rac1' CRS-2673: Attempting to stop 'ora.cvu' on 'rac1' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1' CRS-33673: Attempting to stop resource group 'ora.asmgroup' on server 'rac1' CRS-2673: Attempting to stop 'ora.OCRVOTE.dg' on 'rac1' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1' CRS-2673: Attempting to stop 'ora.chad' on 'rac1' CRS-2673: Attempting to stop 'ora.qosmserver' on 'rac1' CRS-2677: Stop of 'ora.OCRVOTE.dg' on 'rac1' succeeded CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac1' CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1' CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac1' CRS-2677: Stop of 'ora.cvu' on 'rac1' succeeded CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1' CRS-2677: Stop of 'ora.chad' on 'rac1' succeeded CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.asmnet1.asmnetwork' on 'rac1' CRS-2677: Stop of 'ora.asmnet1.asmnetwork' on 'rac1' succeeded CRS-33677: Stop of resource group 'ora.asmgroup' on server 'rac1' succeeded. CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded CRS-2677: Stop of 'ora.qosmserver' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.qosmserver' on 'rac2' CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac2' CRS-2672: Attempting to start 'ora.cvu' on 'rac2' CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac2' CRS-2676: Start of 'ora.cvu' on 'rac2' succeeded CRS-2676: Start of 'ora.scan1.vip' on 'rac2' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac2' CRS-2676: Start of 'ora.rac1.vip' on 'rac2' succeeded CRS-2676: Start of 'ora.qosmserver' on 'rac2' succeeded CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'rac1' CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1' CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.storage' on 'rac1' CRS-2673: Attempting to stop 'ora.crf' on 'rac1' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1' CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1' CRS-2677: Stop of 'ora.storage' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac1' CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1' CRS-2673: Attempting to stop 'ora.evmd' on 'rac1' CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rac1' CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1' CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1' CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed CRS-4133: Oracle High Availability Services has been stopped. [root@rac1 tmp]# /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatchauto apply /u01/patch/19.29/38298204/38291812 -oh /u01/app/oracle/product/19.3.0/dbhome_1 OPatchauto session is initiated at Thu Oct 23 22:34:34 2025 System initialization log file is /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2025-10-23_10-34-38PM.log. Session log file is /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/opatchauto2025-10-23_10-34-41PM.log The id for this session is 87GE Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Executing patch validation checks on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.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.3.0/dbhome_1 No step execution required......... Performing prepatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1 Prepatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Start applying binary patch on home /u01/app/oracle/product/19.3.0/dbhome_1 Failed while applying binary patches on home /u01/app/oracle/product/19.3.0/dbhome_1 Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures: Patch Target : rac1->/u01/app/oracle/product/19.3.0/dbhome_1 Type[rac] Details: [ ---------------------------Patching Failed--------------------------------- Command execution failed during patching in home: /u01/app/oracle/product/19.3.0/dbhome_1, host: rac1. Command failed: /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatchauto apply /u01/patch/19.29/38298204/38291812 -oh /u01/app/oracle/product/19.3.0/dbhome_1 -target_type rac_database -binary -invPtrLoc /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc -jre /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/jre -persistresult /u01/app/oracle/product/19.3.0/dbhome_1/opatchautocfg/db/sessioninfo/sessionresult_rac1_rac_2.ser -analyzedresult /u01/app/oracle/product/19.3.0/dbhome_1/opatchautocfg/db/sessioninfo/sessionresult_analyze_rac1_rac_2.ser Command failure output: ==Following patches FAILED in apply: Patch: /u01/patch/19.29/38298204/38291812 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_22-35-37PM_1.log Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: Prerequisite check "CheckActiveFilesAndExecutables" failed. 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 Thu Oct 23 22:36:09 2025 Time taken to complete the session 1 minute, 31 seconds opatchauto failed with error code 42 #报错发现是有一个sqlplus as sysdba登录的进程阻止打补丁了,找到进程9198,并kill继续打补丁 [root@rac1 tmp]# ps -ef|grep ora grid 880 31238 0 21:52 ? 00:00:00 /bin/sh ./OSWatcherFM.sh 48 /u01/app/grid/oracle.ahf/data/repository/suptools/rac1/oswbb/grid/archive root 1200 1282 0 14:52 ? 00:00:00 sshd: oracle [priv] root 1212 1282 0 14:52 ? 00:00:00 sshd: oracle [priv] oracle 1213 1200 0 14:52 ? 00:00:05 sshd: oracle@pts/1 oracle 1215 1213 0 14:52 pts/1 00:00:00 -bash oracle 1261 1212 0 14:52 ? 00:00:00 sshd: oracle@notty oracle 1262 1261 0 14:52 ? 00:00:00 /usr/libexec/openssh/sftp-server oracle 9198 1215 0 15:25 pts/1 00:00:00 sqlplus as sysdba root 25606 31097 0 22:15 pts/0 00:00:00 su - oracle oracle 25607 25606 0 22:15 pts/0 00:00:00 -bash root 28942 1 4 21:51 ? 00:01:51 /opt/oracle.ahf/jre/bin/java -server -Xms32m -Xmx64m -Djava.awt.headless=true -Ddisable.checkForUpdate=true -XX:+UseParallelGC -XX:MinHeapFreeRatio=5 -XX:MaxHeapFreeRatio=15 -Xss256k -XX:+ExitOnOutOfMemoryError oracle.rat.tfa.TFAMain /opt/oracle.ahf/tfa grid 31238 1 0 21:51 ? 00:00:00 /bin/sh ./OSWatcher.sh 30 48 /bin/gzip /u01/app/grid/oracle.ahf/data/repository/suptools/rac1/oswbb/grid/archive root 31609 22696 0 22:37 pts/2 00:00:00 grep --color=auto ora [root@rac1 tmp]# kill -9 9198 [root@rac1 tmp]# /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatchauto apply /u01/patch/19.29/38298204/38291812 -oh /u01/app/oracle/product/19.3.0/dbhome_1 OPatchauto session is initiated at Thu Oct 23 22:38:13 2025 System initialization log file is /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2025-10-23_10-38-18PM.log. Session log file is /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/opatchauto2025-10-23_10-38-20PM.log The id for this session is CA1Z Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Executing patch validation checks on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.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.3.0/dbhome_1 No step execution required......... Performing prepatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1 Prepatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Start applying binary patch on home /u01/app/oracle/product/19.3.0/dbhome_1 Binary patch applied successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Running rootadd_rdbms.sh on home /u01/app/oracle/product/19.3.0/dbhome_1 Successfully executed rootadd_rdbms.sh on home /u01/app/oracle/product/19.3.0/dbhome_1 Performing postpatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1 Postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Preparing home /u01/app/oracle/product/19.3.0/dbhome_1 after database service restarted No step execution required......... Trying to apply SQL patch on home /u01/app/oracle/product/19.3.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:rac1 RAC Home:/u01/app/oracle/product/19.3.0/dbhome_1 Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u01/patch/19.29/38298204/38291812 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_22-39-15PM_1.log OPatchauto session completed at Thu Oct 23 22:44:11 2025 Time taken to complete the session 5 minutes, 54 seconds [root@rac1 tmp]# /u01/app/19.3.0/grid/bin/crsctl start crs CRS-4123: Oracle High Availability Services has been started. [root@rac1 tmp]# su - oracle Last login: Thu Oct 23 22:44:11 CST 2025 [oracle@rac1:/home/oracle]$ opatch lspatches 38291812;Database Release Update : 19.29.0.0.251021 (38291812) 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) OPatch succeeded. [oracle@rac1:/home/oracle]$ [root@rac2 tmp]# /u01/app/19.3.0/grid/bin/crsctl stop crs CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac2' CRS-2673: Attempting to stop 'ora.crsd' on 'rac2' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'rac2' CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac2' CRS-2673: Attempting to stop 'ora.chad' on 'rac2' CRS-2673: Attempting to stop 'ora.qosmserver' on 'rac2' CRS-2673: Attempting to stop 'ora.cvu' on 'rac2' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac2' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac2' CRS-33673: Attempting to stop resource group 'ora.asmgroup' on server 'rac2' CRS-2673: Attempting to stop 'ora.OCRVOTE.dg' on 'rac2' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac2' CRS-2677: Stop of 'ora.DATA.dg' on 'rac2' succeeded CRS-2677: Stop of 'ora.OCRVOTE.dg' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac2' CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac2' CRS-2677: Stop of 'ora.rac1.vip' on 'rac2' succeeded CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac2' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac2' CRS-2677: Stop of 'ora.chad' on 'rac2' succeeded CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.asmnet1.asmnetwork' on 'rac2' CRS-2677: Stop of 'ora.asmnet1.asmnetwork' on 'rac2' succeeded CRS-33677: Stop of resource group 'ora.asmgroup' on server 'rac2' succeeded. CRS-2677: Stop of 'ora.scan1.vip' on 'rac2' succeeded CRS-2677: Stop of 'ora.rac2.vip' on 'rac2' succeeded CRS-2677: Stop of 'ora.cvu' on 'rac2' succeeded CRS-2677: Stop of 'ora.qosmserver' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'rac2' CRS-2677: Stop of 'ora.ons' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rac2' CRS-2677: Stop of 'ora.net1.network' on 'rac2' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac2' has completed CRS-2677: Stop of 'ora.crsd' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.storage' on 'rac2' CRS-2673: Attempting to stop 'ora.crf' on 'rac2' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac2' CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac2' CRS-2677: Stop of 'ora.crf' on 'rac2' succeeded CRS-2677: Stop of 'ora.drivers.acfs' on 'rac2' succeeded CRS-2677: Stop of 'ora.storage' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac2' CRS-2677: Stop of 'ora.mdnsd' on 'rac2' succeeded CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac2' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rac2' CRS-2673: Attempting to stop 'ora.evmd' on 'rac2' CRS-2677: Stop of 'ora.ctssd' on 'rac2' succeeded CRS-2677: Stop of 'ora.evmd' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rac2' CRS-2677: Stop of 'ora.cssd' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'rac2' CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac2' CRS-2677: Stop of 'ora.gipcd' on 'rac2' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'rac2' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac2' has completed CRS-4133: Oracle High Availability Services has been stopped. [root@rac2 tmp]# /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatchauto apply /u01/patch/19.29/38298204/38291812 -oh /u01/app/oracle/product/19.3.0/dbhome_1 OPatchauto session is initiated at Thu Oct 23 22:49:55 2025 System initialization log file is /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2025-10-23_10-49-59PM.log. Session log file is /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/opatchauto2025-10-23_10-50-02PM.log The id for this session is CLSR Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Executing patch validation checks on home /u01/app/oracle/product/19.3.0/dbhome_1 Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/dbhome_1 Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.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.3.0/dbhome_1 No step execution required......... Performing prepatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1 Prepatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Start applying binary patch on home /u01/app/oracle/product/19.3.0/dbhome_1 Binary patch applied successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Running rootadd_rdbms.sh on home /u01/app/oracle/product/19.3.0/dbhome_1 Successfully executed rootadd_rdbms.sh on home /u01/app/oracle/product/19.3.0/dbhome_1 Performing postpatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1 Postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1 Preparing home /u01/app/oracle/product/19.3.0/dbhome_1 after database service restarted No step execution required......... Trying to apply SQL patch on home /u01/app/oracle/product/19.3.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:rac2 RAC Home:/u01/app/oracle/product/19.3.0/dbhome_1 Version:19.0.0.0.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /u01/patch/19.29/38298204/38291812 Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-10-23_22-51-00PM_1.log OPatchauto session completed at Thu Oct 23 22:56:04 2025 Time taken to complete the session 6 minutes, 5 seconds [root@rac2 tmp]# /u01/app/19.3.0/grid/bin/crsctl start crs CRS-4123: Oracle High Availability Services has been started. [root@rac2 tmp]# su - oracle Last login: Thu Oct 23 22:56:04 CST 2025 [oracle@rac2:/home/oracle]$ opatch lspatches 38291812;Database Release Update : 19.29.0.0.251021 (38291812) 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) OPatch succeeded. [oracle@rac2:/home/oracle]$

八、升级后操作

仅在节点1上操作

#在节点1上用oracle用户操作 su - oracle sqlplus / as sysdba startup alter system set cluster_database=false scope=spfile; exit srvctl stop database -d orcl sqlplus / as sysdba startup upgrade #upgrade启动pdb是无法open的,需要关闭后正常startup后才可以open shutdown immediate startup alter system set cluster_database=true scope=spfile sid='*'; shutdown immediate exit #启动所有节点数据库 srvctl start database -d orcl sqlplus / as sysdba #打开所有pdb alter pluggable database all open; show pdbs exit #如果使用了pdb执行前确认两个节点pdb都打开,如果pdb没有打开 可能会出现cdb和pdb RU不一致,导致pdb受限。 datapatch -verbose #如pdb没更新,强制更新ru datapatch -verbose -apply 38291812 -force -pdbs pdbname #编译无效对象 sqlplus / as sysdba @$ORACLE_HOME/rdbms/admin/utlrp.sql exit [root@rac1 ~]# su - oracle Last login: Thu Oct 23 23:01:05 CST 2025 [oracle@rac1:/home/oracle]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 23 23:05:03 2025 Version 19.29.0.0.0 Copyright (c) 1982, 2025, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1241511488 bytes Fixed Size 9180736 bytes Variable Size 637534208 bytes Database Buffers 587202560 bytes Redo Buffers 7593984 bytes Database mounted. Database opened. SQL> alter system set cluster_database=false scope=spfile; System altered. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.29.0.0.0 [oracle@rac1:/home/oracle]$ srvctl stop database -d orcl [oracle@rac1:/home/oracle]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 23 23:08:44 2025 Version 19.29.0.0.0 Copyright (c) 1982, 2025, Oracle. All rights reserved. Connected to an idle instance. SQL> startup upgrade ORACLE instance started. Total System Global Area 1241511488 bytes Fixed Size 9180736 bytes Variable Size 553648128 bytes Database Buffers 671088640 bytes Redo Buffers 7593984 bytes Database mounted. Database opened. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 1241511488 bytes Fixed Size 9180736 bytes Variable Size 553648128 bytes Database Buffers 671088640 bytes Redo Buffers 7593984 bytes Database mounted. Database opened. SQL> alter system set cluster_database=true scope=spfile sid='*'; System altered. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.29.0.0.0 [oracle@rac1:/home/oracle]$ srvctl start database -d orcl [oracle@rac1:/home/oracle]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 23 23:15:15 2025 Version 19.29.0.0.0 Copyright (c) 1982, 2025, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.29.0.0.0 SQL> alter pluggable database all open; Pluggable database altered. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB READ WRITE NO SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.29.0.0.0 [oracle@rac1:/home/oracle]$ datapatch -verbose SQL Patching tool version 19.29.0.0.0 Production on Thu Oct 23 23:16:21 2025 Copyright (c) 2012, 2025, Oracle. All rights reserved. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_22055_2025_10_23_23_16_21/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.29.0.0.0 Release_Update 251002005342: Installed PDB CDB$ROOT: Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 23-OCT-25 03.12.58.188805 PM PDB PDB: Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 23-OCT-25 03.20.35.618385 PM PDB PDB$SEED: Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 23-OCT-25 03.20.35.618385 PM Adding patches to installation queue and performing prereq checks...done Installation queue: For the following PDBs: CDB$ROOT PDB$SEED PDB No interim patches need to be rolled back Patch 38291812 (Database Release Update : 19.29.0.0.251021 (38291812)): Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.29.0.0.0 Release_Update 251002005342 No interim patches need to be applied Installing patches... For the following PDBs: CDB$ROOT PDB$SEED PDB1 PDB2 No interim patches need to be rolled back No release update patches need to be installed No interim patches need to be applied SQL Patching tool complete on Fri Oct 23 23:52:09 2025 [oracle@rac1:/home/oracle]$

九、检查patch情况

sqlplus / as sysdba set lines 200 col action for a15 col status for a15 select patch_id,patch_type,action,status,target_version from dba_registry_sqlpatch; select * from dba_registry_history; [oracle@rac1:/home/oracle]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 24 09:47:12 2025 Version 19.29.0.0.0 Copyright (c) 1982, 2025, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.29.0.0.0 SQL> set lines 200 col action for a15 col status for a15 select patch_id,patch_type,action,status,target_version from dba_registry_sqlpatch;SQL> SQL> SQL> PATCH_ID PATCH_TYPE ACTION STATUS TARGET_VERSION ---------- ---------- --------------- --------------- --------------- 38291812 RU APPLY SUCCESS 19.29.0.0.0 SQL> select * from dba_registry_history; ACTION_TIME ACTION NAMESPACE VERSION ID --------------------------------------------------------------------------- --------------- ------------------------------ ------------------------------ ---------- COMMENTS -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- BUNDLE_SERIES ------------------------------ BOOTSTRAP DATAPATCH 19 RDBMS_19.29.0.0.0DBRU_LINUX.X64_251001 24-OCT-25 09.16.15.611100 AM RU_APPLY SERVER 19.0.0.0.0 Patch applied from 19.3.0.0.0 to 19.29.0.0.0: Release_Update - 251002005342 ACTION_TIME ACTION NAMESPACE VERSION ID --------------------------------------------------------------------------- --------------- ------------------------------ ------------------------------ ---------- COMMENTS -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- BUNDLE_SERIES ------------------------------ SQL>

十、总结

本文《Oracle 19c RAC 19.29 RU 补丁实战指南》是一份完整的生产级打补丁操作手册,系统性地演示了如何将 Oracle 19.3 RAC 环境升级到 19.29 RU (Release Update),包括环境准备、兼容性验证、补丁分析、实际执行与验证步骤。

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论