RU 19.26安装（手工安装各个补丁）

已于 2025-02-08 09:04:12 修改
阅读量766 收藏 4
点赞数 4
分类专栏： Patches 文章标签： oracle
于 2025-01-27 14:27:44 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xxzhaobb/article/details/145379793
版权

使用手工方式打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/oraInventory
   from           : /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.log

Verifying 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/oraInventory
   from           : /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.log

Verifying 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.log

OPatch 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/oraInventory
   from           : /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.log

Verifying 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.log

OPatch 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/oraInventory
   from           : /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.log

Verifying 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.log

OPatch 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/oraInventory
   from           : /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.log

Verifying 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.log

OPatch 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/oraInventory
   from           : /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.log

Verifying 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.log

OPatch 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/oraInventory
   from           : /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.log

Verifying 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.log

OPatch 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/oraInventory
   from           : /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.log

Verifying 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/oraInventory
   from           : /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.log

Verifying 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.log

OPatch 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/oraInventory
   from           : /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.log

Verifying 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.log

OPatch 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.log

Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.26.0.0.0 Release_Update 250118124854: Installed
  SQL registry:
    Applied 19.25.0.0.0 Release_Update 241010184253 successfully on 20-OCT-24 02.58.38.961302 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  No interim patches need to be rolled back
  Patch 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 250118124854
  No interim patches need to be applied

Installing patches...
Patch installation complete.  Total patches installed: 1

Validating logfiles...done
Patch 37260974 apply: SUCCESS
  logfile: /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 /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 27 14:09:20 2025
Version 19.26.0.0.0

Copyright (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。

--20250208 add 

早上给几套单机，几套单机dg打补丁，明显感觉打补丁比以前快很多。而且运行datapath也比以前快很多。

oracle软件下载（百度盘），包含11GR2至21C基础安装包及相应补丁包
03-31
oracle软件下载（百度盘），包含11GR2至21C基础安装包及相应补丁包
oracle 19C RAC打补丁到19.26
xiaofan23z的专栏
01-27 2277
oracle 19CRAC打补丁到19.26本文只保留简介命令和每个命令大概的用时，方便大家直接copy使用，并了解每个命令的预期时间，减少命令执行期的等待焦虑。
Oracle19C 19.27补丁发布
最新发布
xiaofan23z的专栏
04-16 1004
p6880880_190000_Linux-x86-64.zip (更新 OPatch .45)本文仅供简明指令和大概用时，方便直接 copy 使用，并了解指令的预期执行时间，减少等待焦虑。北京时间4/16日Oracle 19C 19.27季度补丁发布，至此，19c RAC 升级至19.27 完成。
oracle补丁升级，19.0-19.21
12-20
oracle补丁升级，19.0-19.21
Oracle 19c补丁-19.26的校验码
kevinyu998的博客
01-22 584
多次发生打补丁失败了才想起来校验，补丁上传的生产环境上首先要做校验。
Oracle 19C RU补丁升级，从19.7to19.25 -单机
hf191850699的专栏
12-07 1920
源端单实例19.7hfzcdb。
oracle-instantclient19.24-devel-19.24.0.0.0-1.aarch64.rpm
12-24
oracle-instantclient19.24-devel-19.24.0.0.0-1.aarch64.rpm
Oracle下载安装(保姆级教学）
热门推荐
m0_63233901的博客
12-23 1万+
对于Oracle软件的下载，建议通过官网免费下载，安全且有保证。下载地址：通过下载页面可以选择安装压缩包（将压缩包解压，点击【setup.exe】进行安装注意：使用系统管理者账户运行。
从零开始构建Linux
weixin_30379531的博客
01-26 1219
目的：深入了解以Linux内核为基础的系统是如何组成，运行，以构建一个最基础的，纯净的系统。 LFS构建步骤宿主机准备- linux操作系统安装- 使用独立硬盘，创建分区- 配置用户和组- 下载所有需要的软件包源代码准备开发环境构建一个基本开发环境构造完整的目标系统配置系统启动脚本启动系统 一、宿主系统准备1.1.安装所需要依赖包 [root@node ~]# yum install -...
Oracle 19.8新特性"asmcmd credverify" and "asmcmd credfix"
Enmotech的博客
05-20 575
平台：Redhat Linux 7.6数据库版本：Oracle 19.10问题描述：进行OCR磁盘替换DD破坏实验，并删除原有的OCR磁盘组。中间过程中，因spfile文件以及asm密码文...
代码审计-dubbo admin <=2.6.1远程命令执行漏洞
weixin_47208161的博客
02-12 6739
前置输入材料安全目标和需求架构分析供应链安全源代码审查依赖结构矩阵（Dependency Structure Matrices，DSM)数据流信任边界数据存贮威胁列表otter mana...
instantclient-basic-linux.x64-19.26.0.0.0dbru
02-17
oracle19c客户端组件下载： instantclient-basic-linux.x64-19.26.0.0.0dbru
instantclient-tools-linux.x64-19.26.0.0.0dbru
02-17
oracle客户端组件：expdp ,sqlldr等 instantclient-tools-linux.x64-19.26.0.0.0dbru
oracle-instantclient19.22-odbc-19.22.0.0.0-1.x86_64.rpm
05-30
如果你自己在官网下载需要Oracle账号，我这里直接下载好这四个安装包,用于安装Oracle客户端、开发环境等，zabbix监控数据库必备 （适用于centos 8或者9）
Drools4.0官方使用手册中文
u011930916的博客
03-20 4870
第一章. Drools 4.0 发布版标注1.1.  Drools 4.0的新内容Drools4.0是从之前的Drools3.0.x系列以来的一次主要更新。在语言表达式，引擎性能和工具实用性方面都有一整套的新特性开发完成。下面列出一些最引人注意的更新列表。1.1.1. 语言表达式增强· 新的条件元素: from, collect, accumulate 和forall· 新的字段约束操作: not...
网络安全事件应急响应实战二
悦分享
09-14 1万+
当企业发生黑客入侵、系统崩溃或其它影响业务正常运行的安全事件时，急需第一时间进行处理，使企业的网络信息系统在最短时间内恢复正常工作，进一步查找入侵来源，还原入侵事故过程，同时给出解决方案与防范措施，为企业。新闻源网站一般权重较高，收录快，能够被搜索引擎优先收录，是黑灰产推广引流的必争之地，很容易成为被攻击的对象。短连接（short connnection）是相对于长连接而言的概念，指的是在数据传送过程中，只在需要发送数据时，才去建立一个连接，数据发送完成后，则断开此连接，即每次连接只完成一项业务的发送。
Oracle19.24发布，打补丁到19.24
xiaofan23z的专栏
07-17 3020
p6880880_190000_Linux-x86-64.zip （.43的opatch）(要求>=.42)p36582629_190000_Linux-x86-64.zip（GI）（rac需要，GI补丁包含DB）一般每个季度的首月中16号左右发布（北美时间），中国时间17号能看到。2024年7月16日 19c，19.24补丁发布。具体的patch number如下。基本和上面的步骤一致。
oracle19c rac补丁升级及回退（19.3-＞19.22）
qq_58503141的博客
03-26 1306
【代码】oracle19c rac补丁升级及回退（19.3-＞19.22）
oracle 19c安装DBRU补丁时报错CheckSystemSpace的处理
还不算晕的专栏
02-14 571
oracle 19c的补丁目前已经发布到19.26版本了，数据库补丁安装也是数据库运维中的一个常见工作；在实际安装时，发现用OPatch.SKIP_VERIFY_SPACE=true参数可以开始安装，但是安装过程中依然有报错，最终还是需要扩大空间的。查阅文档，是需要22GB以上的可用空间，同时可以用OPatch.SKIP_VERIFY_SPACE=true参数来跳过。查阅文档，是需要22GB以上的可用空间，同时可以用OPatch.SKIP_VERIFY_SPACE=true参数来跳过。
oracle 19.26下载
03-25
<think>好的，我现在需要帮助用户找到Oracle数据库19c版本19.26的官方下载地址。首先，我应该回忆一下Oracle的下载流程和相关政策。Oracle通常要求用户拥有有效的支持合同才能下载补丁和更新，这意味着用户可能需要登录Oracle支持网站（My Oracle Support，MOS）才能获取下载链接。 用户提到的版本是19.26，这应该是19c的某个补丁集或更新版本。Oracle Database 19c的版本号通常以19.x.x.x.x的形式表示，例如19.3.0.0.0，而补丁号可能像19.16这样的形式。不过用户直接提到了19.26，可能需要确认是否存在这个具体版本，或者是否有可能是补丁编号的一部分。 接下来，我需要检查提供的引用内容。引用[2]和[3]提到了应用补丁的过程，例如使用opatchauto应用补丁37260974和36414915，这可能与数据库的升级或补丁应用有关。用户可能已经有一些补丁应用的经验，但当前的问题是关于下载19.26版本。 考虑到Oracle的版本发布惯例，19c的长期支持版本（LTS）通常会有定期发布的更新包，称为Release Updates（RU）或Release Update Revisions（RUR）。这些更新包的版本号可能以年份和月份命名，例如19.16对应2023年4月的RU。但用户提到的19.26可能是一个特定的补丁集，或者可能有误，因为目前公开的版本可能尚未达到19.26。这时需要确认用户是否正确理解了版本号，或者是否指的是某个特定的补丁编号。 用户需要的是官方下载地址，因此必须引导他们到Oracle的官方渠道。首先，用户需要访问My Oracle Support（MOS）账户，搜索相关的补丁号或版本号。例如，补丁号如37260974或36414915可能对应特定的补丁，但用户需要的是完整的数据库安装包还是单独的补丁？ 如果用户需要的是完整的Oracle Database 19c安装介质，官方下载页面通常提供基础版本的安装包，例如19.3，然后通过应用RU来升级到更高版本。因此，用户可能需要先下载基础版本，再应用补丁升级到19.16或更高版本，但19.26可能不存在，或者可能属于不同的补丁序列。 此时，我应该建议用户按照以下步骤操作： 1. 访问Oracle官方网站，登录My Oracle Support账户。 2. 在补丁和更新部分搜索相关的补丁号或版本号。 3. 确认所需的版本是否存在，或是否存在对应的补丁集。 4. 如果用户没有MOS账户，可能需要联系Oracle销售获取支持合同。 另外，检查引用中的信息，引用[2]提到了应用补丁时需要关闭数据库，这可能意味着用户正在进行升级操作，因此需要确认他们是否已经安装了基础版本，并需要特定的补丁来升级到目标版本。 总结来说，用户需要明确他们所需的版本是否正确，以及是否有权限通过MOS下载。如果用户没有有效的支持合同，可能无法直接下载，需要建议他们联系Oracle销售或合作伙伴。</think>要下载Oracle Database 19c版本19.26的官方安装文件或补丁，需遵循以下步骤： 1. **访问Oracle官方渠道** Oracle Database的所有版本和补丁均通过**My Oracle Support (MOS)**平台提供，需拥有有效的Oracle支持合同（CSI号码）才能访问[^2][^3]。 2. **登录My Oracle Support** - 访问 [https://support.oracle.com](https://support.oracle.com) - 使用已绑定支持合同的账号登录。 3. **搜索补丁或版本** - 在MOS的**补丁与更新**栏目中，输入以下关键词： - **Patch Number**: 若已知具体补丁编号（例如引用中的`36414915`或`37260974`），可直接搜索。 - **版本关键词**: 搜索`Oracle Database 19.26`或`19c Release Update 26`，但需注意： - Oracle 19c的版本号通常以`19.x.x.x.x`格式表示（如`19.3.0.0.0`），而`19.26`可能是补丁集版本（如`19.16`为2023年4月发布的RU）。 - 若未找到`19.26`，可能是版本标识差异或尚未公开发布，建议联系Oracle支持确认。 4. **下载与验证** - 找到目标补丁后，点击下载链接，需确保与操作系统兼容（如Linux x86-64）。 - 下载完成后，按官方文档使用`opatch`工具安装，并参考引用中的操作步骤（如关闭数据库、执行升级命令等）。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值