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),包括环境准备、兼容性验证、补丁分析、实际执行与验证步骤。




