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:

This is the Known Issues note for the patches listed above. These known issues are in addition to the issues listed:

• in the README file for each individual Release Update (RU),, or Bundle Patch (BP).
• in Note 555.1, "Oracle Database 19c Important Recommended One-off Patches"

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 完成。