Oracle19.24发布，打补丁到19.24

一. 19.24发布

2024年7月16日 19c，19.24补丁发布

文档编号19202407.9，文档编码规则：

19（版本号）+2024（年份）+07（当季的第一个月01/04/07/10）+.9

一般每个季度的首月中16号左右发布（北美时间），中国时间17号能看到

具体的patch number如下

The Database patch bundles that were released on July 16, 2024 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"

二.打补丁到19.24

1.本次是单实例打补丁，不需要GI，所需的补丁如下

p6880880_190000_Linux-x86-64.zip （.43的opatch）(要求>=.42)

p36414915_190000_Linux-x86-64.zip（OJVM）

p36582781_190000_Linux-x86-64.zip（DB）

p36582629_190000_Linux-x86-64.zip（GI）（rac需要，GI补丁包含DB）

oracle rac打补丁教程参考如下文章

oracle 19c 打补丁教程_19c ojvm补丁下载-CSDN博客

2.备份opatch

mv /u01/app/oracle/product/19.3.0/db/OPatch /u01/app/oracle/product/19.3.0/db/OPatch.bak.41

3.替换高版本opatch

unzip p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOMEchmod -R 755 /u01/app/oracle/product/19.3.0/db/OPatchchown -R oracle:oinstall /u01/app/oracle/product/19.3.0/db/OPatchopatch versionOPatch Version: 12.2.0.1.43OPatch succeeded.

4.打DB patch

4.1打补丁前需要关闭监听和数据库

lsnrctl stopsqlplus / as sysdba如有pdb 先关闭所有pdbalter pluggable database all close immediate;shutdown immediate;

unzip p36582781_190000_Linux-x86-64.zip -d /u01/appchmod -R 755 /u01/app/36582781chown –R oracle:oinstall /u01/app/36582781

4.2补丁检查

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/36582781/Oracle Interim Patch Installer version 12.2.0.1.41Copyright (c) 2024, Oracle Corporation.  All rights reserved.PREREQ sessionOracle Home       : /u01/app/oracle/product/19.3.0/dbCentral Inventory : /u01/app/oraInventoryfrom           : /u01/app/oracle/product/19.3.0/db/oraInst.locOPatch version    : 12.2.0.1.41OUI version       : 12.2.0.7.0Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-07-16_23-08-12PM_1.logInvoking prereq "checkconflictagainstohwithdetail"Prereq "checkConflictAgainstOHWithDetail" passed.OPatch succeeded.

4.3补丁空间检查

Vi /tmp/patch_list_gihome.txt/u01/app/35320081$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txtOracle Interim Patch Installer version 12.2.0.1.41Copyright (c) 2024, Oracle Corporation.  All rights reserved.PREREQ sessionOracle Home       : /u01/app/oracle/product/19.3.0/dbCentral Inventory : /u01/app/oraInventoryfrom           : /u01/app/oracle/product/19.3.0/db/oraInst.locOPatch version    : 12.2.0.1.41OUI version       : 12.2.0.7.0Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-07-16_23-11-17PM_1.logInvoking prereq "checksystemspace"Prereq "checkSystemSpace" passed.</