RU 19.26安装（手工安装各个补丁）
使用手工方式打RU19.26
参考文档： Supplemental Readme - Grid Infrastructure Release Update 12.2.0.1.x / 18c /19c (Doc ID 2246888.1)
操作步骤：
1 Stop the CRS managed resources running from DB homes.
2 Run the pre root script.
3 Patch GI home
4 Patch DB home
5 Run the post script
6 Start the CRS managed resources that were earlier running from DB homes
7 datapatch
备注： 1 在测试19.26的时候，明显感觉时间上比以前的19.19，19.20等等，少很多。以前最多消耗过10-12小时，现在大约3-4小时结束。现在虚拟机比以前少约4G内存（以前20G，现在16G）。
2 19.26的readme 明显风格和之前的RU的readme不一样
1 关闭掉GI和DB （测试之前，GI和DB一直都是关闭的，没有启动 ）
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
2 Run the pre root script.
# <GI_HOME>/crs/install/rootcrs.sh -prepatch
[root@node19c01 install]# ./rootcrs.sh -prepatch
Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:/u01/app/grid/crsdata/node19c01/crsconfig/crs_prepatch_apply_inplace_node19c01_2025-01-27_10-29-59AM.log
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [724960844].
2025/01/27 10:32:20 CLSRSC-4012: Shutting down Oracle Trace File Analyzer (TFA) Collector.
2025/01/27 10:32:49 CLSRSC-4013: Successfully shut down Oracle Trace File Analyzer (TFA) Collector.
2025/01/27 10:32:51 CLSRSC-347: Successfully unlock /u01/app/19.0.0/grid
2025/01/27 10:32:55 CLSRSC-671: Pre-patch steps for patching GI home successfully completed.
[root@node19c01 install]# pwd
/u01/app/19.0.0/grid/crs/install
[root@node19c01 install]# 3 给GI打PATCH
As the GI home owner execute:$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/<OCW TRACKING BUG>
$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/<ACFS TRACKING BUG>
$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/<DBWLM TRACKING BUG>
$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/<DB RU TRACKING BUG>
$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/<TOMCAT RU TRACKING BUG> su - grid
$ /u01/app/19.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /psu/37257886/37268031
$ /u01/app/19.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /psu/37257886/37266638
$ /u01/app/19.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /psu/37257886/36758186
$ /u01/app/19.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /psu/37257886/37260974
$ /u01/app/19.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /psu/37257886/37461387
4 Patch Oracle HOME
$ <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>
$ <ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/<OCW TRACKING BUG>
$ <ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/<DB RU TRACKING BUG>
$ <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME> su - oracle
$ /psu/37257886/37268031/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/19.0.0/db_1
$ /u01/app/oracle/product/19.0.0/db_1/OPatch/opatch apply -oh /u01/app/oracle/product/19.0.0/db_1 -local /psu/37257886/37268031
$ /u01/app/oracle/product/19.0.0/db_1/OPatch/opatch apply -oh /u01/app/oracle/product/19.0.0/db_1 -local /psu/37257886/37260974
$ /psu/37257886/37268031/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/19.0.0/db_1 5. Run the post script.
# <GI_HOME>/rdbms/install/rootadd_rdbms.sh
# <GI_HOME>/crs/install/rootcrs.sh -postpatch/u01/app/19.0.0/grid/rdbms/install/rootadd_rdbms.sh
/u01/app/19.0.0/grid/crs/install/rootcrs.sh -postpatch 6 启动crs （打完后，自动启动）
7 datapatch （在其中一个节点执行）
打完后的效果 ：
[grid@node19c01 ~]$ cd $ORACLE_HOME/OPatch
[grid@node19c01 OPatch]$ ./opatch lspatches
37461387;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37461387)
37260974;Database Release Update : 19.26.0.0.250121 (37260974)
37266638;ACFS RELEASE UPDATE 19.26.0.0.0 (37266638)
37268031;OCW RELEASE UPDATE 19.26.0.0.0 (37268031)
36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186)OPatch succeeded.
[grid@node19c01 OPatch]$ [grid@node19c02 ~]$ cd $ORACLE_HOME/OPatch
[grid@node19c02 OPatch]$ ./opatch lspatches
37461387;TOMCAT RELEASE UPDATE 19.0.0.0.0 (37461387)
37260974;Database Release Update : 19.26.0.0.250121 (37260974)
37266638;ACFS RELEASE UPDATE 19.26.0.0.0 (37266638)
37268031;OCW RELEASE UPDATE 19.26.0.0.0 (37268031)
36758186;DBWLM RELEASE UPDATE 19.0.0.0.0 (36758186)OPatch succeeded.
[grid@node19c02 OPatch]$ [oracle@node19c01 OPatch]$ ./opatch lspatches
37260974;Database Release Update : 19.26.0.0.250121 (37260974)
37268031;OCW RELEASE UPDATE 19.26.0.0.0 (37268031)OPatch succeeded.
[oracle@node19c01 OPatch]$ [oracle@node19c02 OPatch]$ ./opatch lspatches
37260974;Database Release Update : 19.26.0.0.250121 (37260974)
37268031;OCW RELEASE UPDATE 19.26.0.0.0 (37268031)OPatch succeeded.
[oracle@node19c02 OPatch]$ #### 安装各个补丁的log
--ocw log
[grid@node19c01 ~]$ /u01/app/19.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /psu/37257886/37268031
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventoryfrom : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.45
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_10-34-57AM_1.logVerifying environment and performing prerequisite checks...--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventoryfrom : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.45
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_10-42-21AM_1.logVerifying environment and performing prerequisite checks...
OPatch continues with these patches: 37268031 Do you want to proceed? [y|n]
Y
User Responded with: Y
All checks passed.Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/19.0.0/grid')Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '37268031' to OH '/u01/app/19.0.0/grid'
ApplySession: Optional component(s) [ oracle.has.db.cvu, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found.Patching component oracle.rdbms, 19.0.0.0.0...Patching component oracle.has.crs.cvu, 19.0.0.0.0...Patching component oracle.rhp.crs, 19.0.0.0.0...Patching component oracle.has.crs, 19.0.0.0.0...Patching component oracle.has.db, 19.0.0.0.0...Patching component oracle.rhp.db, 19.0.0.0.0...Patching component oracle.has.cvu, 19.0.0.0.0...Patching component oracle.has.rsf, 19.0.0.0.0...Patching component oracle.has.common.cvu, 19.0.0.0.0...Patching component oracle.has.common, 19.0.0.0.0...Patching component oracle.xag, 19.0.0.0.0...Patching component oracle.rhp.common, 19.0.0.0.0...
Patch 37268031 successfully applied.
Sub-set patch [36917416] has become inactive due to the application of a super-set patch [37268031].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_10-42-21AM_1.logOPatch succeeded.
[grid@node19c01 ~]$ -- acfs log
[grid@node19c01 ~]$ /u01/app/19.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /psu/37257886/37266638
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventoryfrom : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.45
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_10-53-26AM_1.logVerifying environment and performing prerequisite checks...
OPatch continues with these patches: 37266638 Do you want to proceed? [y|n]
Y
User Responded with: Y
All checks passed.Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/19.0.0/grid')Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '37266638' to OH '/u01/app/19.0.0/grid'Patching component oracle.usm, 19.0.0.0.0...
Patch 37266638 successfully applied.
Sub-set patch [36917397] has become inactive due to the application of a super-set patch [37266638].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_10-53-26AM_1.logOPatch succeeded.
[grid@node19c01 ~]$ --dbwlm log
[grid@node19c01 ~]$ /u01/app/19.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /psu/37257886/36758186
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventoryfrom : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.45
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_11-03-20AM_1.logVerifying environment and performing prerequisite checks...The following patch(es) are duplicate patches with patches installed in the Oracle Home.[ 36758186]
You have already installed same patch(es) with same UPI(s) or same version(s).
These patch(es) will be skipped.OPatch Session completed with warnings.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_11-03-20AM_1.logOPatch completed with warnings.
[grid@node19c01 ~]$ -- 上面的warnings，详细log信息如下 ：
[Jan 27, 2025 11:09:10 AM] [INFO] Following patches are auto rollbackable:
[Jan 27, 2025 11:09:10 AM] [INFO] Finished checking prereq checkConflictAgainstOHWithDetail
[Jan 27, 2025 11:09:51 AM] [WARNING]OUI-67652:The following patch(es) are duplicate patches with patches installed in the Oracle Home.[ 36758186]You have already installed same patch(es) with same UPI(s) or same version(s).These patch(es) will be skipped.
[Jan 27, 2025 11:09:51 AM] [INFO] UtilSession: N-Apply done.
[Jan 27, 2025 11:09:51 AM] [INFO] --------------------------------------------------------------------------------
[Jan 27, 2025 11:09:51 AM] [INFO] The following warnings have occurred during OPatch execution:
[Jan 27, 2025 11:09:51 AM] [INFO] 1) OUI-67652:The following patch(es) are duplicate patches with patches installed in the Oracle Home.[ 36758186]You have already installed same patch(es) with same UPI(s) or same version(s).These patch(es) will be skipped.
[Jan 27, 2025 11:09:51 AM] [INFO] --------------------------------------------------------------------------------
[Jan 27, 2025 11:09:51 AM] [SEVERE] OUI-67008:OPatch Session completed with warnings.
[Jan 27, 2025 11:09:51 AM] [INFO] Finishing UtilSession at Mon Jan 27 11:09:51 CST 2025
[Jan 27, 2025 11:09:51 AM] [INFO] Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_11-03-20AM_1.log-- dbru log
[grid@node19c01 ~]$ /u01/app/19.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /psu/37257886/37260974
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventoryfrom : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.45
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_11-11-26AM_1.logVerifying environment and performing prerequisite checks...
Prerequisite check "CheckSystemSpace" failed.
The details are:
Required amount of space(9292.756MB) is not available.
UtilSession failed:
Prerequisite check "CheckSystemSpace" failed.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_11-11-26AM_1.logOPatch failed with error code 73
[grid@node19c01 ~]$ [oracle@node19c01 dbs]$ ls -lrt
total 6149044
-rw-r--r-- 1 oracle oinstall 3079 May 14 2015 init.ora
-rw------- 1 oracle asmadmin 1965297664 Apr 19 2024 core.74035
-rw------- 1 oracle asmadmin 2171056128 Apr 19 2024 core.74034
-rw------- 1 oracle asmadmin 2158157824 Apr 19 2024 core.74036
-rw-r----- 1 oracle asmadmin 8388608 Jan 27 10:31 id_test1.dat
-rw-rw---- 1 oracle asmadmin 1544 Jan 27 10:31 hc_test1.dat
[oracle@node19c01 dbs]$ rm -rf core*[grid@node19c01 ~]$ /u01/app/19.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /psu/37257886/37260974
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventoryfrom : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.45
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_11-23-08AM_1.logVerifying environment and performing prerequisite checks...
OPatch continues with these patches: 37260974 Do you want to proceed? [y|n]
Y
User Responded with: Y
All checks passed.Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/19.0.0/grid')Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '37260974' to OH '/u01/app/19.0.0/grid'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.ctx, 19.0.0.0.0 ] , [ oracle.dbdev, 19.0.0.0.0 ] , [ oracle.marvel, 19.0.0.0.0 ] , [ oracle.odbc.ic, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.precomp.common.core, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.oci, 19.0.0.0.0 ] , [ oracle.rdbms.scheduler, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.rdbms.drdaas, 19.0.0.0.0 ] , [ oracle.xdk, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.mgw.common, 19.0.0.0.0 ] , [ oracle.rdbms.hs_common, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.odbc, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.oraolap, 19.0.0.0.0 ] , [ oracle.ctx.atg, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.hsodbc, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.xdk.xquery, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.dm, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.rdbms.dv, 19.0.0.0.0 ] , [ oracle.rdbms.lbac, 19.0.0.0.0 ] , [ oracle.rdbms.rat, 19.0.0.0.0 ] , [ oracle.oraolap.api, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.precomp.common, 19.0.0.0.0 ] , [ oracle.precomp.lang, 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.rsf, 19.0.0.0.0...Patching component oracle.rdbms.util, 19.0.0.0.0...Patching component oracle.rdbms, 19.0.0.0.0...Patching component oracle.assistants.acf, 19.0.0.0.0...Patching component oracle.assistants.asm, 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.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.network.rsf, 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.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.rsf.ic, 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.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.tfa, 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.network.aso, 19.0.0.0.0...Patching component oracle.install.deinstalltool, 19.0.0.0.0...Patching component oracle.ovm, 19.0.0.0.0...Patching component oracle.sdo.locator, 19.0.0.0.0...Patching component oracle.xdk.parser.java, 19.0.0.0.0...Patching component oracle.rdbms.rman, 19.0.0.0.0...Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...Patching component oracle.ctx.rsf, 19.0.0.0.0...Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...Patching component oracle.ldap.ssl, 19.0.0.0.0...Patching component oracle.network.listener, 19.0.0.0.0...Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...Patching component oracle.dbtoolslistener, 19.0.0.0.0...Patching component oracle.ldap.client, 19.0.0.0.0...Patching component oracle.javavm.server, 19.0.0.0.0...Patching component oracle.rdbms.install.common, 19.0.0.0.0...Patching component oracle.rdbms.locator, 19.0.0.0.0...Patching component oracle.network.client, 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.jdk, 1.8.0.201.0...
Patch 37260974 successfully applied.
Sub-set patch [36912597] has become inactive due to the application of a super-set patch [37260974].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_11-23-08AM_1.logOPatch succeeded.
[grid@node19c01 ~]$ -- tomcat log
[grid@node19c01 ~]$ /u01/app/19.0.0/grid/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /psu/37257886/37461387
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventoryfrom : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.45
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_11-36-55AM_1.logVerifying environment and performing prerequisite checks...
OPatch continues with these patches: 37461387 Do you want to proceed? [y|n]
Y
User Responded with: Y
All checks passed.Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/19.0.0/grid')Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '37461387' to OH '/u01/app/19.0.0/grid'Patching component oracle.tomcat.crs, 19.0.0.0.0...
Patch 37461387 successfully applied.
Sub-set patch [36940756] has become inactive due to the application of a super-set patch [37461387].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2025-01-27_11-36-55AM_1.logOPatch succeeded.
[grid@node19c01 ~]$ -- oracle 补丁
[oracle@node19c01 ~]$ /psu/37257886/37268031/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/19.0.0/db_1
/psu/37257886/37268031/custom/scripts/prepatch.sh completed successfully.
[oracle@node19c01 ~]$ -- ocw log for oracle
[oracle@node19c01 ~]$ /u01/app/oracle/product/19.0.0/db_1/OPatch/opatch apply -oh /u01/app/oracle/product/19.0.0/db_1 -local /psu/37257886/37268031
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventoryfrom : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.45
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2025-01-27_11-50-35AM_1.logVerifying environment and performing prerequisite checks...--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventoryfrom : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.45
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2025-01-27_11-55-59AM_1.logVerifying environment and performing prerequisite checks...
OPatch continues with these patches: 37268031 Do you want to proceed? [y|n]
Y
User Responded with: Y
All checks passed.Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.0.0/db_1')Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '37268031' to OH '/u01/app/oracle/product/19.0.0/db_1'
ApplySession: Optional component(s) [ oracle.has.crs.cvu, 19.0.0.0.0 ] , [ oracle.rhp.crs, 19.0.0.0.0 ] , [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ] , [ oracle.xag, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found.Patching component oracle.rdbms, 19.0.0.0.0...Patching component oracle.has.db.cvu, 19.0.0.0.0...Patching component oracle.has.db, 19.0.0.0.0...Patching component oracle.rhp.db, 19.0.0.0.0...Patching component oracle.has.rsf, 19.0.0.0.0...Patching component oracle.has.common.cvu, 19.0.0.0.0...Patching component oracle.has.common, 19.0.0.0.0...Patching component oracle.rhp.common, 19.0.0.0.0...
Patch 37268031 successfully applied.
Sub-set patch [36917416] has become inactive due to the application of a super-set patch [37268031].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2025-01-27_11-55-59AM_1.logOPatch succeeded.
[oracle@node19c01 ~]$
-- dbru log for oracle
[oracle@node19c01 ~]$ /u01/app/oracle/product/19.0.0/db_1/OPatch/opatch apply -oh /u01/app/oracle/product/19.0.0/db_1 -local /psu/37257886/37260974
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventoryfrom : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.45
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2025-01-27_12-03-06PM_1.logVerifying environment and performing prerequisite checks...
OPatch continues with these patches: 37260974 Do you want to proceed? [y|n]
Y
User Responded with: Y
All checks passed.Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.0.0/db_1')Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '37260974' to OH '/u01/app/oracle/product/19.0.0/db_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 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.oraolap.mgmt, 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.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 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.rsf, 19.0.0.0.0...Patching component oracle.rdbms.util, 19.0.0.0.0...Patching component oracle.rdbms, 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.network.aso, 19.0.0.0.0...Patching component oracle.rdbms.drdaas, 19.0.0.0.0...Patching component oracle.install.deinstalltool, 19.0.0.0.0...Patching component oracle.xdk, 19.0.0.0.0...Patching component oracle.ovm, 19.0.0.0.0...Patching component oracle.sdo.locator, 19.0.0.0.0...Patching component oracle.mgw.common, 19.0.0.0.0...Patching component oracle.xdk.parser.java, 19.0.0.0.0...Patching component oracle.rdbms.hs_common, 19.0.0.0.0...Patching component oracle.rdbms.rman, 19.0.0.0.0...Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...Patching component oracle.ctx.rsf, 19.0.0.0.0...Patching component oracle.odbc, 19.0.0.0.0...Patching component oracle.oraolap, 19.0.0.0.0...Patching component oracle.ctx.atg, 19.0.0.0.0...Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...Patching component oracle.ldap.ssl, 19.0.0.0.0...Patching component oracle.network.listener, 19.0.0.0.0...Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...Patching component oracle.xdk.xquery, 19.0.0.0.0...Patching component oracle.rdbms.dm, 19.0.0.0.0...Patching component oracle.dbtoolslistener, 19.0.0.0.0...Patching component oracle.ldap.client, 19.0.0.0.0...Patching component oracle.javavm.server, 19.0.0.0.0...Patching component oracle.rdbms.dv, 19.0.0.0.0...Patching component oracle.rdbms.install.common, 19.0.0.0.0...Patching component oracle.rdbms.lbac, 19.0.0.0.0...Patching component oracle.rdbms.rat, 19.0.0.0.0...Patching component oracle.oraolap.api, 19.0.0.0.0...Patching component oracle.rdbms.locator, 19.0.0.0.0...Patching component oracle.network.client, 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.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 37260974 successfully applied.
Sub-set patch [36912597] has become inactive due to the application of a super-set patch [37260974].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2025-01-27_12-03-06PM_1.logOPatch succeeded.
[oracle@node19c01 ~]$ -- post patch log
[oracle@node19c01 ~]$ /psu/37257886/37268031/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/19.0.0/db_1
Reading /u01/app/oracle/product/19.0.0/db_1/install/params.ora..
Reading /u01/app/oracle/product/19.0.0/db_1/install/params.ora..
Found uninstantiated /u01/app/oracle/product/19.0.0/db_1/crs/sbs/srvctl.sbs file, copying to /u01/app/oracle/product/19.0.0/db_1/bin/srvctl
Parsing file /u01/app/oracle/product/19.0.0/db_1/bin/srvctl
Parsing file /u01/app/oracle/product/19.0.0/db_1/bin/srvconfig
Parsing file /u01/app/oracle/product/19.0.0/db_1/bin/cluvfy
Parsing file /u01/app/oracle/product/19.0.0/db_1/bin/kfod
Verifying file /u01/app/oracle/product/19.0.0/db_1/bin/srvctl
Verifying file /u01/app/oracle/product/19.0.0/db_1/bin/srvconfig
Verifying file /u01/app/oracle/product/19.0.0/db_1/bin/cluvfy
Verifying file /u01/app/oracle/product/19.0.0/db_1/bin/kfod
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/srvctl
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/srvconfig
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/kfod
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/diskmon.bin
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/lsnodes
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/osdbagrp
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/rawutl
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/srvm/admin/ractrans
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/srvm/admin/getcrshome
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/crsdiag.pl
Postpatch completed successfully
[oracle@node19c01 ~]$ -- rootcrs log
[root@node19c01 psu]# /u01/app/19.0.0/grid/rdbms/install/rootadd_rdbms.sh
[root@node19c01 psu]#
[root@node19c01 psu]# /u01/app/19.0.0/grid/crs/install/rootcrs.sh -postpatch
Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:/u01/app/grid/crsdata/node19c01/crsconfig/crs_postpatch_apply_inplace_node19c01_2025-01-27_12-14-13AM.log
2025/01/27 12:14:19 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [724960844].
2025/01/27 12:15:48 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2025/01/27 12:15:49 CLSRSC-672: Post-patch steps for patching GI home successfully completed.
[root@node19c01 psu]# 2025/01/27 12:18:05 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.[root@node19c01 psu]# -- datapatch log
[oracle@node19c02 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.26.0.0.0 Production on Mon Jan 27 14:06:25 2025
Copyright (c) 2012, 2025, Oracle. All rights reserved.Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_127500_2025_01_27_14_06_25/sqlpatch_invocation.logConnecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...doneCurrent state of interim SQL patches:No interim patches foundCurrent state of release update SQL patches:Binary registry:19.26.0.0.0 Release_Update 250118124854: InstalledSQL registry:Applied 19.25.0.0.0 Release_Update 241010184253 successfully on 20-OCT-24 02.58.38.961302 PMAdding patches to installation queue and performing prereq checks...done
Installation queue:No interim patches need to be rolled backPatch 37260974 (Database Release Update : 19.26.0.0.250121 (37260974)):Apply from 19.25.0.0.0 Release_Update 241010184253 to 19.26.0.0.0 Release_Update 250118124854No interim patches need to be appliedInstalling patches...
Patch installation complete. Total patches installed: 1Validating logfiles...done
Patch 37260974 apply: SUCCESSlogfile: /u01/app/oracle/cfgtoollogs/sqlpatch/37260974/26040769/37260974_apply_TEST_2025Jan27_14_07_37.log (no errors)
SQL Patching tool complete on Mon Jan 27 14:08:13 2025
[oracle@node19c02 OPatch]$ SQL> select STATUS,DESCRIPTION from dba_registry_sqlpatch;[oracle@node19c02 ~]$ sqlplus /nologSQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 27 14:09:20 2025
Version 19.26.0.0.0Copyright (c) 1982, 2024, Oracle. All rights reserved.SQL> conn / as sysdba
Connected.
SQL> select STATUS,DESCRIPTION from dba_registry_sqlpatch;STATUS
-------------------------
DESCRIPTION
--------------------------------------------------------------------------------
SUCCESS
Database Release Update : 19.3.0.0.190416 (29517242)SUCCESS
Database Release Update : 19.7.0.0.200414 (30869156)SUCCESS
Database Release Update : 19.19.0.0.230418 (35042068)STATUS
-------------------------
DESCRIPTION
--------------------------------------------------------------------------------
SUCCESS
Database Release Update : 19.20.0.0.230718 (35320081)SUCCESS
Database Release Update : 19.21.0.0.231017 (35643107)SUCCESS
Database Release Update : 19.22.0.0.240116 (35943157)STATUS
-------------------------
DESCRIPTION
--------------------------------------------------------------------------------
SUCCESS
Database Release Update : 19.23.0.0.240416 (36233263)SUCCESS
Database Release Update : 19.24.0.0.240716 (36582781)SUCCESS
Database Release Update : 19.25.0.0.241015 (36912597)STATUS
-------------------------
DESCRIPTION
--------------------------------------------------------------------------------
SUCCESS
Database Release Update : 19.26.0.0.250121 (37260974)10 rows selected.SQL> -- 补充，补丁过程中，升级了 tfa
2025-01-27 12:15:49: Command output:
> CLSRSC-672: Post-patch steps for patching GI home successfully completed.
>End Command output
2025-01-27 12:15:49: CLSRSC-672: Post-patch steps for patching GI home successfully completed.
2025-01-27 12:18:05: Command output:
>
> AHF Installer for Platform Linux Architecture x86_64
>
> AHF Installation Log : /tmp/ahf_install_2411200_107468_2025_01_27-12_15_48.log
>
> Starting Autonomous Health Framework (AHF) Installation
>
> AHF Version: 24.11.2 Build Date: 202501100041
>
> AHF is already installed at /opt/oracle.ahf
>
> Installed AHF Version: 24.8.1 Build Date: 202409300403
>
> Upgrading /opt/oracle.ahf
> TFA-00002 Oracle Trace File Analyzer (TFA) is not running
> TFA-00106 TFA Shutdown/Stopped by user
>
> Shutting down AHF Services
>
> Upgrading AHF Services
>
> Starting AHF Services
> No new directories were added to TFA
> Directory /u01/app/grid/crsdata/node19c01/trace/chad was already added to TFA Directories.
>
> .------------------------------------------------------------------.
> | Host | TFA Version | TFA Build ID | Upgrade Status |
> +-----------+-------------+-----------------------+----------------+
> | node19c01 | 24.11.2.0.0 | 241120020250110004139 | UPGRADED |
> | node19c02 | 24.8.1.0.0 | 240810020240930040327 | NOT UPGRADED |
> '-----------+-------------+-----------------------+----------------'
>
> Setting up AHF CLI and SDK
>
> AHF is successfully upgraded to latest version
>
> Moving /tmp/ahf_install_2411200_107468_2025_01_27-12_15_48.log to /u01/app/grid/oracle.ahf/data/node19c01/diag/ahf/
>
>End Command output
2025-01-27 12:18:05: Executing cmd: /u01/app/19.0.0/grid/bin/clsecho -p has -f clsrsc -m 4003
2025-01-27 12:18:05: Executing cmd: /u01/app/19.0.0/grid/bin/clsecho -p has -f clsrsc -m 4003
2025-01-27 12:18:05: Command output:
> CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
>End Command output
2025-01-27 12:18:05: CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.> Installed AHF Version: 24.8.1 Build Date: 202409300403
>
> Upgrading /opt/oracle.ahf
> TFA-00002 Oracle Trace File Analyzer (TFA) is not running
> TFA-00106 TFA Shutdown/Stopped by user
>
> Shutting down AHF Services
> TFA-00002 Oracle Trace File Analyzer (TFA) is not running
> TFA-00106 TFA Shutdown/Stopped by user
> TFA-00201 Diagnostic directory not found.
>
> Upgrading AHF Services
>
> Starting AHF Services
> TFA-00201 Diagnostic directory not found.
>
> .------------------------------------------------------------------.
> | Host | TFA Version | TFA Build ID | Upgrade Status |
> +-----------+-------------+-----------------------+----------------+
> | node19c02 | 24.11.2.0.0 | 241120020250110004139 | UPGRADED |
> | node19c01 | 24.11.2.0.0 | 241120020250110004139 | UPGRADED |
> '-----------+-------------+-----------------------+----------------'
>
> Setting up AHF CLI and SDK
>
> AHF is successfully upgraded to latest version
>
> Moving /tmp/ahf_install_2411200_114634_2025_01_27-14_03_21.log to /u01/app/grid/oracle.ahf/data/node19c02/diag/ahf/
>
>End Command output
2025-01-27 14:05:33: Executing cmd: /u01/app/19.0.0/grid/bin/clsecho -p has -f clsrsc -m 4003
2025-01-27 14:05:33: Executing cmd: /u01/app/19.0.0/grid/bin/clsecho -p has -f clsrsc -m 4003
2025-01-27 14:05:33: Command output:
> CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
>End Command output打完补丁后 ，集群会自动起来
END。
相关文章：
RU 19.26安装（手工安装各个补丁）
使用手工方式打RU19.26 参考文档： Supplemental Readme - Grid Infrastructure Release Update 12.2.0.1.x / 18c /19c (Doc ID 2246888.1) 操作步骤： 1 Stop the CRS managed resources running from DB homes. 2 Run the pre root script. 3 Patch GI…...
深入理解Pytest中的Setup和Teardown
关注开源优测不迷路 大数据测试过程、策略及挑战 测试框架原理，构建成功的基石 在自动化测试工作之前，你应该知道的10条建议 在自动化测试中，重要的不是工具 对于简单程序而言，使用 Pytest 运行测试直截了当。然而，当你…...
如何利用AI工具来进行数据分析
利用AI工具进行数据分析可以显著提高效率和准确性，以下是详细步骤和方法： 1. 明确分析目标 在开始数据分析之前，首先需要明确分析的目标和问题。这包括确定需要解决的问题、期望的见解或结果，以及选择合适的AI工具和方法。 2. …...
具身智能体俯视全局的导航策略！TopV-Nav: 解锁多模态语言模型在零样本目标导航中的顶视空间推理潜力
作者：Linqing Zhong, Chen Gao, Zihan Ding, Yue Liao, Si Liu 单位：北京航空航天大学，新加坡国立大学，香港中文大学多模态实验室 论文标题：TopV-Nav: Unlocking the Top-View Spatial Reasoning Potential of MLLM …...
npm:升级自身时报错:EBADENGINE
具体报错信息如下： 1.原因分析 npm和当前的node版本不兼容。 // 当前实际版本: Actual: {"npm":"10.2.4","node":"v20.11.0"}可以通过官网文档查看与自己 node 版本 兼容的是哪一版本的npm，相对应进行更新即可…...
微信小程序实现自定义日历功能
文章目录 1. 创建日历组件实现步骤：2. 代码实现过程3. 实现效果图4. 关于作者其它项目视频教程介绍 1. 创建日历组件实现步骤： 创建日历组件：首先，你需要创建一个日历组件，包含显示日期的逻辑。样式设计：为…...
Vue 3 中的 toRef 与 toRefs：使用与案例解析
在 Vue 3 的响应式系统中，toRef 和 toRefs 是两个非常实用的工具函数。它们主要用于将响应式对象的属性转换为单独的 ref，以便在模板或逻辑中更方便地使用。本文将详细介绍 toRef 和 toRefs 的用法，并通过一个老师信息的案例来演示它们的实际…...
问题修复记录：Linux docker 部署 dify，无法调用宿主机本地服务
重磅推荐专栏： 《大模型AIGC》 《课程大纲》 《知识星球》 本专栏致力于探索和讨论当今最前沿的技术趋势和应用领域，包括但不限于ChatGPT和Stable Diffusion等。我们将深入研究大型模型的开发和应用，以及与之相关的人工智能生成内容（AIGC）技术。通过深入的技术解析和实践经…...
代码随想录day20
235. 利用二叉搜索树的特性即可 /** lc appleetcode.cn id235 langcpp** [235] 二叉搜索树的最近公共祖先*/// lc codestart /*** Definition for a binary tree node.* struct TreeNode {* int val;* TreeNode *left;* TreeNode *right;* TreeNode(int x) :…...
【ProxyBroker】用Python打破网络限制的利器
ProxyBroker 1. 什么是ProxyBroker2. ProxyBroker的功能3. ProxyBroker的优势4. ProxyBroker的使用方法5. ProxyBroker的应用场景6.结语项目地址： 1. 什么是ProxyBroker ProxyBroker是一个开源工具，它可以异步地从多个来源找到公共代理，并同…...
分布式微服务系统架构第88集：kafka集群
使用集 群最大的好处是可以跨服务器进行负载均衡，再则就是可以使用复制功能来避免因单点故 障造成的数据丢失。在维护 Kafka 或底层系统时，使用集群可以确保为客户端提供高可用 性。 需要多少个broker 一个 Kafka 集群需要多少个 broker 取决于以下几个因…...
RocketMQ原理—5.高可用+高并发+高性能架构
大纲 1.RocketMQ的整体架构与运行流程 2.基于NameServer管理Broker集群的架构 3.Broker集群的主从复制架构 4.基于Topic和Queue实现的数据分片架构 5.Broker基于Pull模式的主从复制原理 6.Broker层面到底如何做到数据0丢失 7.数据0丢失与写入高并发的取舍 8.RocketMQ读…...
下载Visual Studio Community 2019
官方链接如下：Visual Studio Community 2019下载链接 https://learn.microsoft.com/zh-cn/visualstudio/releases/2019/system-requirements#download 目前官方仅建议2022版，已经关闭vs2019等旧版本，哪天开放了，记得踢我一下。 …...
一文简单回顾Java中的String、StringBuilder、StringBuffer
简单说下String、StringBuilder、StringBuffer的区别 String、StringBuffer、StringBuilder在Java中都是用于处理字符串的，它们之间的区别是String是不可变的，平常开发用的最多，当遇到大量字符串连接的时候，就用StringBuilder&am…...
27. C语言 强制类型转换详解
本章目录: 前言强制类型转换（Type Casting）强制类型转换的语法示例1：将整数转换为浮点数输出结果： 代码解析： 整数提升（Integer Promotion）示例2：整数提升输出结果： 代码…...
git困扰的问题
.gitignore中添加的某个忽略文件并不生效 把某些目录或文件加入忽略规则，按照上述方法定义后发现并未生效， gitignore只能忽略那些原来没有被追踪的文件，如果某些文件已经被纳入了版本管理中，则修改.gitignore是无效的。 解决方…...
反向代理模块。。
1 概念 1.1 反向代理概念 反向代理是指以代理服务器来接收客户端的请求，然后将请求转发给内部网络上的服务器，将从服务器上得到的结果返回给客户端，此时代理服务器对外表现为一个反向代理服务器。 对于客户端来说，反向代理就相当于…...
【Linux基础指令】第三期
近期更新的基础指令链接： 【Linux基础指令】第一期-CSDN博客 【Linux基础指令】第二期-CSDN博客 本期博客的主题依旧是 "基础指令" ；话不多说，正文开始。 一、Linux的指令 1.zip / unzip 功能：打包压缩 命令格式&…...
Jenkins安装部署（以及常见报错解决方案），jdk版本控制器sdkman
目录 零、环境介绍 一、Jenkins安装 1、插件安装以及更换插件源 2、修改jenkins时区 二、sdkman安装（可选） 1、sdkman常用方法 2、sdkman常用方法演示 2.1、查看可用的jdk 2.2、下载jdk并切换版本 三、jenkins报错解决 1、下载sdkman后systemc…...
利用JSON数据类型优化关系型数据库设计
利用JSON数据类型优化关系型数据库设计 前言 在关系型数据库中，传统的结构化存储方式要求预先定义好所有的列及其数据类型。 然而，随着业务的发展，这种设计可能会显得不够灵活，尤其是在需要扩展单个列的描述功能时。 JSON数据…...
Nxopen 直齿轮参数化设计
NXUG1953 Visualstudio 2019 参考论文： A Method for Determining the AGMA Tooth Form Factor from Equations for the Generated Tooth Root Fillet //FullGear// Mandatory UF Includes #include <uf.h> #include <uf_object_types.h>// Internal I…...
线程配置经验
工作时，时常会遇到，线程相关的问题与解法，本人会持续对开发过程中遇到的关于线程相关的问题及解决记录更新记录在此篇博客中。 目录 一、线程基本知识 1. 线程和进程 二、问题与解法 1. 避免乘法级别数量线程并行 1）使用线程池…...
火语言RPA--KimiAiFree服务
🚩【组件功能】：KimiAiFree服务支持联网搜索、支持智能体对话、支持长文档解读、支持图像OCR。 配置预览 配置说明 服务地址 支持T或# 自行搭建或第三方提供的KimiAiFree服务地址。 RefreshToken 支持T或# 与KimiAiFree服务交互时用到的token。从ki…...
P6120 [USACO17JAN] Hoof, Paper, Scissor S
难度：普及/提高−； 题意： 石头、剪刀、布游戏，先给出 n n n 轮已经知道的其中一人的对局情况，例如样例： 5 P - 布 P - 布 H - 石头 P - 布 S - 剪刀另外一人，只允许修改一次机会的情况下…...
Android Studio打包APK
1.导出APK安装包 如果是首次打包，Create new 单击蓝色对话框右边文件夹📂图标 ，选择密钥保存路径，然后在下方File name对话框中填写您想要名称，再点击OK回到密钥创建对话框。 在此对话框中填写密码（Passwo…...
08 比特币通用技术介绍
比特币分层 比特币区块结构 存储结构 区块是比特币存储交易的结构，一个区块总是指向其父节点。 一个区块包含三个字段：区块头、区块交易数量、交易列表。交易数量受到区块大小限制，输入、输出数量和脚本都会占用区块空间，矿工往…...
拟合损失函数
文章目录 拟合损失函数一、线性拟合1.1 介绍1.2 代码可视化1.2.1 生成示例数据1.2.2 损失函数1.2.3 绘制三维图像1.2.4 绘制等高线1.2.5 损失函数关于斜率的函数 二、 多变量拟合2.1 介绍2.2 代码可视化2.2.1 生成示例数据2.2.2 损失函数2.2.3 绘制等高线 三、 多项式拟合3.1 介…...
二进制安卓清单 binary AndroidManifest - XCTF apk 逆向-2
XCTF 的 apk 逆向-2 题目 wp，这是一道反编译对抗题。 题目背景 AndroidManifest.xml 在开发时是文本 xml，在编译时会被 aapt 编译打包成为 binary xml。具体的格式可以参考稀土掘金 MindMac 做的类图（2014），下面的博…...
在线免费快速无痕去除照片海报中的文字logo
上期和大家分享了用photoshop快速无痕去除照片海报中的文字logo的方法，有的同学觉得安装PS太麻烦，有那下载安装时间早都日落西山了，问有没有合适的在线方法可以快速去除；达芬奇上网也尝试了几个网站，今天分享一个对国人…...
引领未来科技潮流：Web3 前沿发展趋势
随着技术不断发展，我们正站在一个全新的互联网时代的门槛上，Web3的出现正在重新定义互联网的构架和运作方式。Web3，作为互联网的下一代发展趋势，其核心思想是去中心化、开放与用户主权。与现有的Web2.0相比，Web3更加注…...