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

🕗 发布于 2024-10-16 15:47 数据库

一. 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.43OPatch 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 sessionOracle 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.logInvoking 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 sessionOracle 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.logInvoking 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.logVerifying 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.logOPatch 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.logVerifying 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.logOPatch 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 sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 16 09:28:24 2024Version 19.25.0.0.0Copyright (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.logConnecting to database...OKGathering database info...doneNote:  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...doneCurrent 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 installedCurrent 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 PMAdding 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: 6Validating 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$SEEDSQL 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>

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

原文地址：https://blog.csdn.net/xiaofan23z/article/details/142978589

免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！

上一篇：LabVIEW智能可变温循环PCT测试系统
下一篇：（十）远程访问和控制：OpenSSH 与 TCPwrappers 全解析

描述性分析：偏度和峰度
集中趋势与离散程度是数据分布的两个重要特征，但要全面了解数据分布的特点，我们还应考虑数据分布的形状是否为对称、偏斜的程度以及分布的扁平程度等问题。
阅读更多2024-10-17
centos 手动安装nvidia-container-toolkit
是无法正常安装的，会报错：OpenSSL SSL_connect: Connection reset by peer in connection to nvidia.github.io:443。系统版
阅读更多2024-10-17
10.高级存储过程技巧（10/10）
存储过程是一组在数据库中预先编写并存储的SQL语句，它们可以接收输入参数、返回结果，并且可以包含控制流语句，如IF条件语句、WHILE循环等。性能提升：由于存储过程是预编译的，它们的执行计划会被缓存，
阅读更多2024-10-17
OpenCV 简介与在 Python 和 C# 中的使用
OpenCV（Open Source Computer Vision Library）是一个开源的计算机视觉库，它提供了丰富的函数和工具，用于处理图像和视频数据。最初由英特尔公司开发，现在由一个开源社
阅读更多2024-10-17
centOS部署Jenkins实现项目可持续自动化部署
个人看的是尚硅谷的视频，跟着实战，但因为视频是21年的，所以很容易出现jenkins插件不适配问题。因而个人直接用较新版的jdk和jenkins.sudo su。
阅读更多2024-10-17
天锐绿盾VS Ping32数据安全新选择，用户体验分享
而Ping32则以其创新的技术和灵活的功能配置，尤其受到技术爱好者和大型企业的青睐。在网络安全的选择上，用户应根据自身的实际需求和技术水平，选择最合适的安全软件，为数字生活提供可靠的保护。相比之下，P
阅读更多2024-10-17
前端vue的样式
前端vue的样式
阅读更多2024-10-17
大数据-174 Elasticsearch Query DSL - 全文检索 full-text query 匹配、短语、多字段详细操作
全文搜索能够搜索已分析的文本字段，如电子邮件正文、商品描述，使用索引期间应用于字段的同一分词处理查询字符串，全文搜索的分类很多，有如下的这么几种。如果你需要在多个字段上进行文本搜索，可用multi_m
阅读更多2024-10-17
GCC（GNU Compiler Collection）部分参数解释
预处理完成后，编译器会输出预处理后的代码，通常是一个扩展了所有宏和包含的文件内容的C或C++源代码。应该是逗号分隔的参数列表，如果只有一个参数，逗号也可以省略，但通常为了保持一致性，即使只有一个参数也
阅读更多2024-10-17
Sign Language Dataset: 聋哑人手语数据集（猫脸码客第209期）
（一）RWTH-PHOENIX-Weather-2014RWTH-PHOENIX-Weather-2014是一个大型的聋哑人手语数据集，包含德国PHOENIX天气预报节目中的手语数据。该数据集由RWT
阅读更多2024-10-17

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

1 Known Issues

相关文章