A.Oracle19C 19.28补丁发布
北京时间2025年7月16日，oracle发布了新的季度补丁19.28，但是和Q2的19.27类似，本次windows补丁继续delay，预计要到月底才能发布，所以windows系统的补丁，还要再等等。
The Database patch bundles that were released on July 15, 2025 for Release 19c were:
| Name | Download Link |
|---|---|
| Database Release Update 19.28.0.0.250715 | Patch 37960098 |
| Grid Infrastructure Release Update 19.28.0.0.250715 | Patch 37957391 |
| OJVM Release Update 19.28.0.0.250715 | Patch 37847857 |
| Microsoft Windows 32-Bit & x86-64 Bundle Patch 19.28.0.0.250715 | Patch 37962957 |
This is the Known Issues note for the patches listed above. These known issues are in addition to the issues listed:
B.Oracle 19c RAC 打补丁升级到 19.28
本文仅供简明指令和大概用时，方便直接 copy 使用，并了解指令的预期执行时间，减少等待焦虑。
一、补丁包列表
p6880880_190000_Linux-x86-64.zip (更新 OPatch .45)
p37847857_190000_Linux-x86-64.zip (OJVM 19.28)
p37960098_190000_Linux-x86-64.zip (DB 19.28)
p37957391_190000_Linux-x86-64.zip (GI 19.28)
二、更新 OPatch (grid/oracle)
【root】
mv OPatch OPatch.bak unzip -q p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME chmod -R 755 OPatch chown -R grid:oinstall / oracle:oinstall opatch version # 检查新版本
三、解压 patch 包
【root】
unzip p37957391_190000_Linux-x86-64.zip -d /u01/app/ unzip p37847857_190000_Linux-x86-64.zip -d /u01/app/ chown -R grid:oinstall /u01/app/37957391 /u01/app/37847857 chmod -R 755
四、OPatch 兼容性检查
【grid】
$GRID_HOME/OPatch/opatch lsinventory -detail
五、补丁冲突检查
【grid/oracle】
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/37957391/[subdir] opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/37847857
六、空间检查
vi /tmp/patch_list_gihome.txt /u01/app/37957391 /u01/app/37847857 opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
七、补丁分析 (Analyze)
opatchauto apply /u01/app/37847857 -analyze # 约7分钟 opatchauto apply /u01/app/37957391 -analyze # 约13分钟
八、GRID 升级
opatchauto apply /u01/app/37847857 -oh $GRID_HOME # OJVM, 7min opatchauto apply /u01/app/37957391 -oh $GRID_HOME # GI, 13min opatch lspatches # 确认 patch 状态
九、DB 升级 (Oracle home)
srvctl stop database -d <dbname> opatchauto apply /u01/app/37957391/37960098 -oh $ORACLE_HOME # 约6.5分钟
十、升级后操作 (only node1)
sqlplus / as sysdba STARTUP alter system set cluster_database=false scope=spfile; srvctl stop db -d <dbname> STARTUP UPGRADE; SHUTDOWN; STARTUP; alter system set cluster_database=true scope=spfile sid='*'; SHUTDOWN; srvctl start database -d <dbname> alter pluggable database all open; -- 确认 PDB 全部打开 -- 执行 datapatch $ORACLE_HOME/OPatch/datapatch -verbose # 约35min -- 如有未更新 PDB $ORACLE_HOME/OPatch/datapatch -verbose -apply 37960098 -force -pdbs <pdbname> -- 编译无效对象 @$ORACLE_HOME/rdbms/admin/utlrp.sql
十一、查看补丁实际状态
set linesize 180 col action for a15 col status for a15 select PATCH_ID,PATCH_TYPE,ACTION,STATUS,TARGET_VERSION from dba_registry_sqlpatch;
至此，19c RAC 升级至19.28 完成。
