Oracle19.25发布，如何打补丁到19.25

一. 19.25发布

2024年10月16日 19c 19.25补丁发布

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

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

一般每个季度的首月中15号左右发布（北美时间）

具体的patch number如下

The Database patch bundles that were released on October 15, 2024 for Release 19c were:

Name	Download Link
Database Release Update 19.25.0.0.241015	Patch 36912597
Grid Infrastructure Release Update 19.25.0.0.241015	Patch 36916690
OJVM Release Update 19.25.0.0.241015	Patch 36878697
Microsoft Windows 32-Bit & x86-64 Bundle Patch 19.25.0.0.241015	Patch 36878821

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"

1 Known Issues

设计和修复的bug如下

#	Date Added	Applies to	Issue	Fix or Workaround	More Details
1.7	September 16, 2024	DB RU 19.25.0.0.241015	Products using third-party JDBC Drivers encounter connection errors after applying the 19.25 DBRU. This problem does not replicate with Oracle-provided JDBC drivers. After applying the 19.25 database release update, several third-party products using third-party JDBC drivers, including IBM Change Data Capture (CDC) and Informatica, experienced connectivity issues. Both IBM and Informatica have released patches to address the compatibility issue. Customers experiencing this issue should contact the vendor directly for assistance and any needed patches. Oracle made several updates in the recent release update 19.25 of Oracle Database. Oracle's normal quality testing activities include validating that these updates would not adversely impact the Oracle-provided JDBC drivers. However, Oracle does not have the ability to test, certify, or support third-party JDBC drivers or products that use non-Oracle drivers.	Oracle recommends that you either contact the third-party vendor themselves and determine whether they can provide a fix for their third-party driver that would enable continued compatibility with current versions of Oracle Database, or encourage those vendors to leverage the Oracle-provided JDBC drivers.	Note 3044094.1
1.6	September 06, 2024	DB RU 19.25.0.0.241015	The fix for bug 31626438 was initially introduced in version 19.11 and was disabled by default until version 19.17. To address query performance issues (bug 33803836), the fix for bug 31626438 was enabled by default in 19.18 and remains enabled in 19.19. However, due to further performance problems reported in bug 35383562, the fix for bug 31626438 was disabled again in 19.20 and remains disabled in subsequent versions. Thus, the fix for bug 31626438 is enabled by default only in 19.18 and 19.19 version. Impact: If you are upgrading from version 19.18 or 19.19 to 19.20 or later, you may encounter the original issues addressed by the bug 31626438 fix.	To restore the behavior of version 19.18 and 19.19, you can enable the fix for bug 31626438 by running - ALTER SYSTEM SET "_fix_control"='31626438:1" Additional Information: • The original bug 31626438 fixes issue with serial scan of partitioned tables with large buffer cache skipping offload smart scan. • The performance issue reported in bug 33803836 is related to higher elapsed time and cpu time for certain queries. • The performance issue reported in bug 35383562 is a performance problem on Exadata where cell storage index optimization drops severely after applying fix 33803836 and disabling fix control 31626438 restores performance.
1.5	April 17, 2024	DB RU 19.25.0.0.241015	"show database" command may hang or timeout after REINSTATE is completed The cause of this problem is bug 34802312, which was included in 19.21. Bug 36405353 addresses the problem and also disables 34802312 by default. To enable 34802312, please review the Workaround section.	Please enable "ConfigurationEventFlags" using below command DGMGRL> edit configuration set property ConfigurationEventFlags=1;
1.4	April 17, 2024	DB RU 19.25.0.0.241015	Starting 19.21, Fix for bug 31061145 is included in the bundle and it is by default disabled . Below mentioned steps can be followed to enable or disable the fix.	1) Fix can be Enabled/Disabled by setting below config parameter _lm_adrm_options=7 to enable the feature _lm_adrm_options=3 to disables the feature 2) Fix also can be enabled by applying the 19.21 One-Off patch of bug 31061145	Note 31061145.8
1.3	April 16, 2024	DB RU 19.25.0.0.241015	During patching from an RU version < 19.17 to a version >= 19.17, the following error(s) might occur: ora-7445 [kxfpqrfdb] ORA-600 [kxttCIS:0.9] ORA-600 [kttcnts-no-ts-1] and ORA-600 [15801]	This is because of a binary level mismatch between RAC nodes. Meaning some nodes have patched to 19.17 or later and some do not specifically affect the parallel queries that have with clause which have multiple query coordinators as some "PQ Server Process" will be on different nodes (different RU < 19.17) than the QC and other "PQ Server Processes This error is benign and will self resolve on re-try. It does not have any functional impact and hence can be safely ignored. The probability of this happening is more on BIG ENDIAN platforms like SPARC, HPUX and AIX. | In order to fix this issue, Patch all nodes with the same RU and also the following workaround works until applying the RUs on all nodes: a. Stop "Automatic Report Capturing Feature" that runs WITH MONITOR_DATA AS (SELECT * FROM TABLE(GV$(CURSOR( SELECT ... alter system set "_report_capture_cycle_time"=0; use sid=* ; so that it is set on all instances b. The following can workaround the issue alter system set "_in_memory_cdt"=OFF; Reference Bug 35172593	Note 2954175.1
1.2	August 02, 2023	GI RU 19.25.0.0.241015 (AIX only)	Out of place (OOP) patching of 19.23.0 GI RU fails on AIX if using “opatchauto” OOP and “gridSetup.sh -applyRU” or "runinstaller -applyRU" commands on AIX.	Oracle recommends that customers planning to install 19.23 GI RU on AIX platform use the steps listed in MOS (similar to 19.19 RU) Note 2948468.1 - Out of place (OOP) patching of 19c Release Update (RU) fails on AIX	Note 2948468.1 , Note 2949881.1
1.1	November 21, 2022	WIN DBBP 19.25.0.0.241015	The Windows Bundle patch 34468114 inadvertently included a few perl files that will be reported as a conflict if Perl patch 33912872 is being installed after the Oct2022 Windows Bundle patch. There is no issue if the Perl patch was installed prior to install of the Oct2022 Windows Bundle patch. This issue was first identified in the Oct2022 quarter.	An updated version without the perl files has now been uploaded as of Thur 17-Nov-2022 8am PST. If perl file conflict is reported, then please download latest Windows Bundle Patch 34468114 from My Oracle Support. Reference Bug 34803142

二.打补丁到19.25

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

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

p36878697_190000_Linux-x86-64.zip（OJVM）

p36912597_190000_Linux-x86-64.zip（DB）

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

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

oracle19C rac打patch到19.14_19c rac datapatch-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/OPatch opatch versionOPatch Version: 12.2.0.1.43​OPatch succeeded.​

4.打DB patch

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

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

unzip p36912597_190000_Linux-x86-64.zip -d /u01/appchmod -R 755 /u01/app/36912597chown  oracle:oinstall /u01/app/36912597

4.2补丁检查

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/36912597/Oracle Interim Patch Installer version 12.2.0.1.43Copyright (c) 2024, Oracle Corporation.  All rights reserved.​PREREQ session​Oracle Home       : /u01/app/oracle/product/19.3.0/dbCentral Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/19.3.0/db/oraInst.locOPatch version    : 12.2.0.1.43OUI version       : 12.2.0.7.0Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-10-16_11-21-06AM_1.log​Invoking prereq "checkconflictagainstohwithdetail"​Prereq "checkConflictAgainstOHWithDetail" passed.​OPatch succeeded.​

4.3补丁空间检查

vi /tmp/patch_list_gihome.txt/u01/app/36912597$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txtOracle Interim Patch Installer version 12.2.0.1.43Copyright (c) 2024, Oracle Corporation.  All rights reserved.​PREREQ session​Oracle Home       : /u01/app/oracle/product/19.3.0/dbCentral Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/19.3.0/db/oraInst.locOPatch version    : 12.2.0.1.43OUI version       : 12.2.0.7.0Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-10-16_11-24-45AM_1.log​Invoking prereq "checksystemspace"​Prereq "checkSystemSpace" passed.​OPatch succeeded.​

4.4打补丁

[oracle@19ocm ~]$ cd /u01/app[oracle@19ocm app]$ cd 36912597/[oracle@19ocm 36912597]$[oracle@19ocm 36912597]$ /u01/app/oracle/product/19.3.0/db/OPatch/opatch applyOracle Interim Patch Installer version 12.2.0.1.43Copyright (c) 2024, Oracle Corporation.  All rights reserved.​​Oracle Home       : /u01/app/oracle/product/19.3.0/dbCentral Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/19.3.0/db/oraInst.locOPatch version    : 12.2.0.1.43OUI version       : 12.2.0.7.0Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-10-16_11-29-47AM_1.log​Verifying environment and performing prerequisite checks...OPatch continues with these patches:   36912597  ​Do you want to proceed? [y|n]yUser Responded with: YAll checks passed.​Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.(Oracle Home = '/u01/app/oracle/product/19.3.0/db')​​Is the local system ready for patching? [y|n]yUser Responded with: YBacking up files...Applying interim patch '36912597' to OH '/u01/app/oracle/product/19.3.0/db'ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.​Patching component oracle.rdbms, 19.0.0.0.0...​Patching component oracle.rdbms.util, 19.0.0.0.0...​Patching component oracle.rdbms.rsf, 19.0.0.0.0...​Patching component oracle.assistants.acf, 19.0.0.0.0...​Patching component oracle.assistants.deconfig, 19.0.0.0.0...​Patching component oracle.assistants.server, 19.0.0.0.0...​Patching component oracle.blaslapack, 19.0.0.0.0...​Patching component oracle.buildtools.rsf, 19.0.0.0.0...​Patching component oracle.ctx, 19.0.0.0.0...​Patching component oracle.dbdev, 19.0.0.0.0...​Patching component oracle.dbjava.ic, 19.0.0.0.0...​Patching component oracle.dbjava.jdbc, 19.0.0.0.0...​Patching component oracle.dbjava.ucp, 19.0.0.0.0...​Patching component oracle.duma, 19.0.0.0.0...​Patching component oracle.javavm.client, 19.0.0.0.0...​Patching component oracle.ldap.owm, 19.0.0.0.0...​Patching component oracle.ldap.rsf, 19.0.0.0.0...​Patching component oracle.ldap.security.osdt, 19.0.0.0.0...​Patching component oracle.marvel, 19.0.0.0.0...​Patching component oracle.network.rsf, 19.0.0.0.0...​Patching component oracle.odbc.ic, 19.0.0.0.0...​Patching component oracle.ons, 19.0.0.0.0...​Patching component oracle.ons.ic, 19.0.0.0.0...​Patching component oracle.oracore.rsf, 19.0.0.0.0...​Patching component oracle.perlint, 5.28.1.0.0...​Patching component oracle.precomp.common.core, 19.0.0.0.0...​Patching component oracle.precomp.rsf, 19.0.0.0.0...​Patching component oracle.rdbms.crs, 19.0.0.0.0...​Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...​Patching component oracle.rdbms.deconfig, 19.0.0.0.0...​Patching component oracle.rdbms.oci, 19.0.0.0.0...​Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...​Patching component oracle.rdbms.scheduler, 19.0.0.0.0...​Patching component oracle.rhp.db, 19.0.0.0.0...​Patching component oracle.rsf, 19.0.0.0.0...​Patching component oracle.sdo, 19.0.0.0.0...​Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...​Patching component oracle.sqlplus, 19.0.0.0.0...​Patching component oracle.sqlplus.ic, 19.0.0.0.0...​Patching component oracle.wwg.plsql, 19.0.0.0.0...​Patching component oracle.xdk.rsf, 19.0.0.0.0...​Patching component oracle.javavm.server, 19.0.0.0.0...​Patching component oracle.xdk.xquery, 19.0.0.0.0...​Patching component oracle.ctx.rsf, 19.0.0.0.0...​Patching component oracle.ovm, 19.0.0.0.0...​Patching component oracle.oraolap, 19.0.0.0.0...​Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...​Patching component oracle.rdbms.rat, 19.0.0.0.0...​Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...​Patching component oracle.rdbms.dv, 19.0.0.0.0...​Patching component oracle.xdk, 19.0.0.0.0...​Patching component oracle.mgw.common, 19.0.0.0.0...​Patching component oracle.ldap.client, 19.0.0.0.0...​Patching component oracle.install.deinstalltool, 19.0.0.0.0...​Patching component oracle.rdbms.rman, 19.0.0.0.0...​Patching component oracle.oraolap.api, 19.0.0.0.0...​Patching component oracle.dbtoolslistener, 19.0.0.0.0...​Patching component oracle.rdbms.drdaas, 19.0.0.0.0...​Patching component oracle.rdbms.hs_common, 19.0.0.0.0...​Patching component oracle.rdbms.lbac, 19.0.0.0.0...​Patching component oracle.sdo.locator, 19.0.0.0.0...​Patching component oracle.rdbms.dm, 19.0.0.0.0...​Patching component oracle.ldap.ssl, 19.0.0.0.0...​Patching component oracle.xdk.parser.java, 19.0.0.0.0...​Patching component oracle.odbc, 19.0.0.0.0...​Patching component oracle.network.listener, 19.0.0.0.0...​Patching component oracle.ctx.atg, 19.0.0.0.0...​Patching component oracle.rdbms.install.common, 19.0.0.0.0...​Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...​Patching component oracle.network.aso, 19.0.0.0.0...​Patching component oracle.rdbms.locator, 19.0.0.0.0...​Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...​Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...​Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...​Patching component oracle.nlsrtl.rsf.ic, 19.0.0.0.0...​Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...​Patching component oracle.network.client, 19.0.0.0.0...​Patching component oracle.precomp.common, 19.0.0.0.0...​Patching component oracle.precomp.lang, 19.0.0.0.0...​Patching component oracle.jdk, 1.8.0.201.0...Patch 36912597 successfully applied.Sub-set patch [29517242] has become inactive due to the application of a super-set patch [36912597].Please refer to Doc ID 2161861.1 for any possible further required actions.Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-10-16_11-29-47AM_1.log​OPatch succeeded.

opatch 后补丁检查

OPatch succeeded.[oracle@19ocm 36912597]$ opatch lspatches36912597;Database Release Update : 19.25.0.0.241015 (36912597)29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)​OPatch succeeded.​

4.5打补丁常见报错

  非rac环境使用opatchauto会报错

/u01/app/oracle/product/19.3.0/db/OPatch/opatchauto apply /u01/app/35320081 -oh /u01/app/oracle/product/19.3.0/dbOPatchauto session is initiated at Thu Aug 10 09:51:58 2023OPATCHAUTO-72083: Performing bootstrap operations failed.OPATCHAUTO-72083: The bootstrap execution failed because Cannot detect any valid Grid Infrastructure setup..OPATCHAUTO-72083: Fix the reported problem and re-run opatchauto.OPatchauto session completed at Thu Aug 10 09:51:58 2023Time taken to complete the session 0 minute, 0 secondopatchauto bootstrapping failed with error code 255.错误原因，非RAC环境不可以使用opatchauto

缺少fuser，需要安装psmisc包

Oracle Interim Patch Installer version 12.2.0.1.43Copyright (c) 2023, Oracle Corporation. All rights reserved.Oracle 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.43OUI version : 12.2.0.7.0Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2023-08-10_10-02-32AM_1.logVerifying environment and performing prerequisite checks...Prerequisite check "CheckSystemCommandAvailable" failed.The details are:Missing command :fuserUtilSession failed:Prerequisite check "CheckSystemCommandAvailable" failed.Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2023-08-10_10-02-32AM_1.logOPatch failed with error code 73这个报错是因为缺少fuser命令yum search fuserLoaded plugins: fastestmirrorDetermining fastest mirrors====================================================================== Matched: fuser =======================================================================psmisc.x86_64 : Utilities for managing processes on your systemyum install -y psmisc #安装这个包​​

5.OJVM补丁

基本和上面的步骤一致

unzip p36878697_190000_Linux-x86-64.zip -d /u01/app/chmod -R 755 /u01/app/36878697chown -R oracle:oinstall /u01/app/36878697cd /u01/app/36878697/u01/app/oracle/product/19.3.0/db/OPatch/opatch apply---------------------------------Oracle Interim Patch Installer version 12.2.0.1.43Copyright (c) 2024, Oracle Corporation.  All rights reserved.​​Oracle Home       : /u01/app/oracle/product/19.3.0/dbCentral Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/19.3.0/db/oraInst.locOPatch version    : 12.2.0.1.43OUI version       : 12.2.0.7.0Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-10-16_12-06-57PM_1.log​Verifying environment and performing prerequisite checks...OPatch continues with these patches:   36878697  ​Do you want to proceed? [y|n]yUser Responded with: YAll checks passed.​Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.(Oracle Home = '/u01/app/oracle/product/19.3.0/db')​​Is the local system ready for patching? [y|n]yUser Responded with: YBacking up files...Applying interim patch '36878697' to OH '/u01/app/oracle/product/19.3.0/db'​Patching component oracle.javavm.server, 19.0.0.0.0...​Patching component oracle.javavm.server.core, 19.0.0.0.0...​Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...​Patching component oracle.rdbms, 19.0.0.0.0...​Patching component oracle.javavm.client, 19.0.0.0.0...Patch 36878697 successfully applied.Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-10-16_12-06-57PM_1.log​OPatch succeeded.

检查补丁结果

[oracle@19ocm 36878697]$ opatch lspatches36878697;OJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697)36912597;Database Release Update : 19.25.0.0.241015 (36912597)29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)​OPatch succeeded.​

6.补完丁后操作

6.1 非pdbs

[oracle@19ocm 36878697]$ sqlplus / as sysdba​SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 16 09:28:24 2024Version 19.25.0.0.0​Copyright (c) 1982, 2024, Oracle.  All rights reserved.​Connected to an idle instance.​SQL> startup upgradeORACLE instance started.​Total System Global Area 1073739904 bytesFixed Size                  8947840 bytesVariable Size             855638016 bytesDatabase Buffers          201326592 bytesRedo Buffers                7827456 bytesDatabase mounted.Database opened.SQL>SQL> show pdbs;SQL>SQL>​

6.2 pdb模式

STARTUP UPGRADEORACLE instance started.Total System Global Area 1.0100E+10 bytesFixed Size 13893832 bytesVariable Size 1610612736 bytesDatabase Buffers 8455716864 bytesRedo Buffers 19656704 bytesDatabase mounted.Database opened.SQL> show pdbsCON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ----------2 PDB$SEED MIGRATE YES3 YZCCREP MOUNTEDSQL>alter pluggable database all open;alter pluggable database all open*ERROR at line 1:ORA-65054: Cannot open a pluggable database in the desired mode.这时候PDB是无法启动的，需要先关闭数据库 然后正常startupSQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 1.0100E+10 bytesFixed Size 13893832 bytesVariable Size 1610612736 bytesDatabase Buffers 8455716864 bytesRedo Buffers 19656704 bytesDatabase mounted.Database opened.SQL> show pdbsCON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO3 YZCCREP READ WRITE NOSQL>SQL>SQL> exit

6.3 datapatch 

PDB模式下要确认所有的pdb都是open的,不然可能会出现pdb和cdb版本不一致而引起的pdb状态受限

pdb状态受限处理办法参考文章

19C打完补丁后PDB状态受限Warning: PDB altered with errors

datapatch -verbose

[oracle@19ocm 36878697]$ datapatch -verboseSQL Patching tool version 19.25.0.0.0 Production on Wed Oct 16 12:13:25 2024Copyright (c) 2012, 2024, Oracle.  All rights reserved.​Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_20699_2024_10_16_12_13_25/sqlpatch_invocation.log​Connecting to database...OKGathering 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...doneDetermining current state...done​Current state of interim SQL patches:Interim patch 36878697 (OJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697)):  Binary registry: Installed  PDB CDB$ROOT: Not installed  PDB MESTEST: Not installed  PDB PDB$SEED: Not installed​Current state of release update SQL patches:  Binary registry:    19.25.0.0.0 Release_Update 241010184253: Installed  PDB CDB$ROOT:    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 16-OCT-23 01.31.09.382782 PM  PDB MESTEST:    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 16-OCT-23 01.37.47.678419 PM  PDB PDB$SEED:    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 16-OCT-23 01.37.47.678419 PM​Adding patches to installation queue and performing prereq checks...doneInstallation queue:  For the following PDBs: CDB$ROOT PDB$SEED MESTEST    No interim patches need to be rolled back    Patch 36912597 (Database Release Update : 19.25.0.0.241015 (36912597)):      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.25.0.0.0 Release_Update 241010184253    The following interim patches will be applied:      36878697 (OJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697))​​WARNING: Following components are NOT in a valid state.         This could cause patching failure. If it does, consider         running utlrp.sql to bring components to VALID state.         Then, re-run datapatch.​         PDB$SEED : SDO [INVALID]​Installing patches...Patch installation complete.  Total patches installed: 6​Validating logfiles...donePatch 36912597 apply (pdb CDB$ROOT): SUCCESS  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36912597/25871884/36912597_apply_YCSMTEST_CDBROOT_2024Oct16_12_15_56.log (no errors)Patch 36878697 apply (pdb CDB$ROOT): SUCCESS  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36878697/25797620/36878697_apply_YCSMTEST_CDBROOT_2024Oct16_12_15_07.log (no errors)Patch 36912597 apply (pdb PDB$SEED): SUCCESS  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36912597/25871884/36912597_apply_YCSMTEST_PDBSEED_2024Oct16_12_21_48.log (no errors)Patch 36878697 apply (pdb PDB$SEED): SUCCESS  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36878697/25797620/36878697_apply_YCSMTEST_PDBSEED_2024Oct16_12_21_33.log (no errors)Patch 36912597 apply (pdb MESTEST): SUCCESS  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36912597/25871884/36912597_apply_YCSMTEST_MESTEST_2024Oct16_12_21_48.log (no errors)Patch 36878697 apply (pdb MESTEST): SUCCESS  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36878697/25797620/36878697_apply_YCSMTEST_MESTEST_2024Oct16_12_21_33.log (no errors)​Automatic recompilation incomplete; run utlrp.sql to revalidate.  PDBs: MESTEST PDB$SEED​SQL Patching tool complete on Wed Oct 16 12:25:32 2024​

6.4编译无效对象

@$ORACLE_HOME/rdbms/admin/utlrp.sql

6.5检查补丁结果

SQL> set linesize 180col action for a15col status for a15SQL> SQL> SQL> select PATCH_ID,PATCH_TYPE,ACTION,STATUS,TARGET_VERSION from dba_registry_sqlpatch;​  PATCH_ID PATCH_TYPE ACTION          STATUS          TARGET_VERSION---------- ---------- --------------- --------------- ---------------  29517242 RU         APPLY           SUCCESS         19.3.0.0.0  36878697 INTERIM    APPLY           SUCCESS         19.25.0.0.0  36912597 RU         APPLY           SUCCESS         19.25.0.0.0SQL> select PATCH_UID,PATCH_ID,ACTION,STATUS,ACTION_TIME ,DESCRIPTION from dba_registry_sqlpatch;​ PATCH_UID   PATCH_ID ACTION          STATUS          ACTION_TIME---------- ---------- --------------- --------------- ---------------------------------------------------------------------------DESCRIPTION----------------------------------------------------------------------------------------------------  22862832   29517242 APPLY           SUCCESS         16-OCT-23 01.31.09.382782 PMDatabase Release Update : 19.3.0.0.190416 (29517242)​  25797620   36878697 APPLY           SUCCESS         16-OCT-24 12.15.56.261268 PMOJVM RELEASE UPDATE: 19.25.0.0.241015 (36878697)​  25871884   36912597 APPLY           SUCCESS         16-OCT-24 12.21.09.791292 PMDatabase Release Update : 19.25.0.0.241015 (36912597)​SQL>​

更多打补丁相关文章

Oracle19.24发布，打补丁到19.24_oracle 19.24-CSDN博客

oracle 19.23 Patch发布（含下载链接）_19.23补丁-CSDN博客
oracle patch 大全（更新至2024-03）-CSDN博客