提示:文章写完后,目录可以自动生成,如何生成可参考右边的帮助文档
文章目录
前言
提示:这里可以添加本文要记录的大概内容:
因客户安全要求,要为数据库一体机进行打补丁,本文记录一次最新的Oracle RAC 19C打补丁操作,本次升级计划19.10——>19.15,以下为本文实操干货:
提示:以下是本篇文章正文内容,下面案例可供参考
一、工作前准备
1.准备patch包
[oracle@dbm0dbadm01 ~]$ cd /data/patch_software/
[oracle@dbm0dbadm01 patch_software]$ ll
total 0
drwxr-xr-x 2 root root 55 Jul 13 19:00 db
drwxrwxrwx 3 grid oinstall 102 Jul 13 19:04 grid
drwxr-xr-x 3 oracle oinstall 102 Jul 13 19:05 ojvm
drwxr-xr-x 3 oracle oinstall 72 Jul 13 19:06 opatch
2.两个节点备份grid、oracle家目录
#以下命令仅展示一个节点
[root@dbm0dbadm01 db_home1 ~]$ su - grid
[grid@dbm0dbadm01 ~]$ cd /u01/app/19.0.0.0
[grid@dbm0dbadm01 19.0.0.0~]$ tar cvf /data/patch_software/homebak/grid.20220709.tar grid
[root@dbm0dbadm01 db_home1 ~]$ su - oracle
[oracle@dbm0dbadm01 ~]$ cd /u01/app/oracle/product/19.0.0.0
[oracle@dbm0dbadm01 19.0.0.0~]$tar cvf /data/patch_software/homebak/dbhome_1.20220709.tar dbhome_1
2.两个节点grid、oracle替换OPatch工具
#以下命令仅展示一个节点
[oracle@dbm0dbadm01 ~]$ cd $ORACLE_HOME
[oracle@dbm0dbadm01 db_home1 ~]$ mv OPatch OPatch.bak
[oracle@dbm0dbadm01 db_home1 ~]$ unzip /data/patch_software/opatch/p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME
[oracle@dbm0dbadm01 db_home1 ~]$ exit
[root@dbm0dbadm01 db_home1 ~]$ chown -R oracle:oinstall OPatch
[root@dbm0dbadm01 db_home1 ~]$ su -grid
[grid@dbm0dbadm01 ~]$ cd $ORACLE_HOME
[grid@dbm0dbadm01 grid~]$ mv OPatch OPatch.bak
[grid@dbm0dbadm01 grid~]$ unzip /data/patch_software/opatch/p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME
[grid@dbm0dbadm01 grid~]$ exit
[root@dbm0dbadm01 grid ~]$ chown -R grid:oinstall OPatch
3.两个节点运行补丁冲突检查
#以下命令仅展示一个节点
[oracle@dbm0dbadm02 OPatch]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /data/patch_software/grid/33803476/33815596
Oracle Interim Patch Installer version 12.2.0.1.30
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.30
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2022-07-16_21-31-37PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@dbm0dbadm02 OPatch]$ exit
logout
[root@dbm0dbadm02 ~]# su - grid
Last login: Sat Jul 16 21:21:45 CST 2022
[grid@dbm0dbadm02 ~]$ history|grep opatch
72 2022-07-13.19:15:24 opatch --version
73 2022-07-13.19:15:35 opatch version
76 2022-07-13.19:24:56 opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /data/patch_software/grid/33803476/33575402
77 2022-07-13.19:25:25 opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /data/patch_software/grid/33803476/33815596
78 2022-07-13.19:25:44 opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /data/patch_software/grid/33803476/33911149
79 2022-07-13.19:25:59 opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /data/patch_software/grid/33803476/33806152
80 2022-07-13.19:26:16 opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /data/patch_software/grid/33803476/33815607
82 2022-07-13.19:29:51 opatch lspatches
83 2022-07-16.21:32:36 history|grep opatch
[grid@dbm0dbadm02 ~]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /data/patch_software/grid/33803476/33575402
Oracle Interim Patch Installer version 12.2.0.1.30
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.0.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.30
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2022-07-16_21-32-49PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@dbm0dbadm02 ~]$ ps -ef|grep LOCAL=NO|wc -l
192
4.关闭升级过程中的计划任务
#添加#号进行注释
#注意备份数据
[oracle@dbm0dbadm01 ~]$ crontab -e
二、Patch升级步骤
1.grid进行GI升级(遇到冲突log)
[root@dbm0dbadm01 33803476]# pwd
/data/patch_software/grid/33803476
[root@dbm0dbadm01 33803476]# ll /u01/app/oraInventory/ContentsXML/oui-patch.xml
-rw-rw---- 1 grid oinstall 174 Apr 17 2021 /u01/app/oraInventory/ContentsXML/oui-patch.xml
[root@dbm0dbadm01 33803476]# ll /u01/app/19.0.0.0/grid/inventory/oneoffs
total 0
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 29340594
drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29401763
drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29517242
drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29517247
drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29585399
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 32218454
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 32218663
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 32222571
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 32240590
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 32289783
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 32301133
[root@dbm0dbadm01 33803476]# ll /u01/app/19.0.0.0/grid/inventory/oneoffs|wc -l
12
[root@dbm0dbadm01 33803476]# /u01/app/19.0.0.0/grid/OPatch/opatchauto apply /data/patch_software/grid/33803476
OPatchauto session is initiated at Sat Jul 16 22:23:45 2022
System initialization log file is /u01/app/19.0.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-07-16_10-23-52PM.log.
Session log file is /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/opatchauto2022-07-16_10-25-21PM.log
The id for this session is 9NR1
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0.0/grid
Patch applicability verification failed on home /u01/app/19.0.0.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : dbm0dbadm01->/u01/app/19.0.0.0/grid Type[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/19.0.0.0/grid, host: dbm0dbadm01.
Command failed: /u01/app/19.0.0.0/grid/OPatch/opatchauto apply /data/patch_software/grid/33803476 -oh /u01/app/19.0.0.0/grid -target_type cluster -binary -invPtrLoc /u01/app/19.0.0.0/grid/oraInst.loc -jre /u01/app/19.0.0.0/grid/OPatch/jre -persistresult /u01/app/19.0.0.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_dbm0dbadm01_crs_1.ser -analyze -online -prepare_home
Command failure output:
==Following patches FAILED in analysis for apply:
Patch: /data/patch_software/grid/33803476/33815596
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-07-16_22-25-48PM_1.log
Reason: Failed during Analysis: CheckConflictAgainstOracleHome Failed, [ Prerequisite Status: FAILED, Prerequisite output:
Summary of Conflict Analysis:
Patches that can be applied now without any conflicts are :
33575402, 33806152, 33815607, 33911149
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
32289783, 33815596
Conflicts/Supersets for each patch are:
Patch : 33815596
Bug Conflict with 32289783
Conflicting bugs are:
29357821, 2999 ...
After fixing the cause of failure Run opatchauto resume
]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.
OPatchauto session completed at Sat Jul 16 22:26:27 2022
Time taken to complete the session 2 minutes, 43 seconds
opatchauto failed with error code 42
2.回滚所提示的冲突patch包
[root@dbm0dbadm01 33803476]# /u01/app/19.0.0.0/grid/OPatch/opatchauto rollback -id 32289783
OPatchauto session is initiated at Sat Jul 16 22:27:46 2022
System initialization log file is /u01/app/19.0.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-07-16_10-27-51PM.log.
Session log file is /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/opatchauto2022-07-16_10-28-31PM.log
The id for this session is 4VMD
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Patch applicability verified successfully on home /u01/app/19.0.0.0/grid
Executing patch validation checks on home /u01/app/19.0.0.0/grid
Patch validation checks successfully completed on home /u01/app/19.0.0.0/grid
Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0.0/dbhome_1
No step execution required.........
Preparing to bring down database service on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Successfully prepared home /u01/app/oracle/product/19.0.0.0/dbhome_1 to bring down database service
Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/dbm0dbadm01/crsconfig/crs_prepatch_rollback_inplace_dbm0dbadm01_2022-07-16_10-28-58PM.log
CRS service brought down successfully on home /u01/app/19.0.0.0/grid
Start rolling back binary patch on home /u01/app/19.0.0.0/grid
Binary patch rolled back successfully on home /u01/app/19.0.0.0/grid
Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.0.0.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/dbm0dbadm01/crsconfig/crs_postpatch_rollback_inplace_dbm0dbadm01_2022-07-16_10-30-48PM.log
CRS service started successfully on home /u01/app/19.0.0.0/grid
Preparing home /u01/app/oracle/product/19.0.0.0/dbhome_1 after database service restarted
No step execution required.........
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:dbm0dbadm01
RAC Home:/u01/app/oracle/product/19.0.0.0/dbhome_1
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch ID: 32289783
Reason: This Patch does not exist in the home, it cannot be rolled back.
Host:dbm0dbadm01
CRS Home:/u01/app/19.0.0.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY rolled back:
Patch ID: 32289783
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-07-16_22-30-23PM_1.log
OPatchauto session completed at Sat Jul 16 22:35:20 2022
Time taken to complete the session 7 minutes, 35 seconds
[root@dbm0dbadm01 33803476]#
3.重新应用GI补丁包
[root@dbm0dbadm01 33803476]# /u01/app/19.0.0.0/grid/OPatch/opatchauto apply /data/patch_software/grid/33803476
OPatchauto session is initiated at Sat Jul 16 22:35:36 2022
System initialization log file is /u01/app/19.0.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2022-07-16_10-35-44PM.log.
Session log file is /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/opatchauto2022-07-16_10-37-11PM.log
The id for this session is TURA
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0.0/grid
Patch applicability verified successfully on home /u01/app/19.0.0.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Executing patch validation checks on home /u01/app/19.0.0.0/grid
Patch validation checks successfully completed on home /u01/app/19.0.0.0/grid
Executing patch validation checks on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0.0/dbhome_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Preparing to bring down database service on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Successfully prepared home /u01/app/oracle/product/19.0.0.0/dbhome_1 to bring down database service
Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/dbm0dbadm01/crsconfig/crs_prepatch_apply_inplace_dbm0dbadm01_2022-07-16_10-39-04PM.log
CRS service brought down successfully on home /u01/app/19.0.0.0/grid
Performing prepatch operation on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Perpatch operation completed successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Start applying binary patch on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Binary patch applied successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Performing postpatch operation on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Start applying binary patch on home /u01/app/19.0.0.0/grid
Binary patch applied successfully on home /u01/app/19.0.0.0/grid
Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.0.0.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/dbm0dbadm01/crsconfig/crs_postpatch_apply_inplace_dbm0dbadm01_2022-07-16_10-56-47PM.log
CRS service started successfully on home /u01/app/19.0.0.0/grid
Preparing home /u01/app/oracle/product/19.0.0.0/dbhome_1 after database service restarted
No step execution required.........
Trying to apply SQL patch on home /u01/app/oracle/product/19.0.0.0/dbhome_1
SQL patch applied successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:dbm0dbadm01
RAC Home:/u01/app/oracle/product/19.0.0.0/dbhome_1
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /data/patch_software/grid/33803476/33815607
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /data/patch_software/grid/33803476/33575402
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /data/patch_software/grid/33803476/33911149
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /data/patch_software/grid/33803476/33806152
Log: /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-07-16_22-40-14PM_1.log
Patch: /data/patch_software/grid/33803476/33815596
Log: /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2022-07-16_22-40-14PM_1.log
Host:dbm0dbadm01
CRS Home:/u01/app/19.0.0.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /data/patch_software/grid/33803476/33575402
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-07-16_22-47-53PM_1.log
Patch: /data/patch_software/grid/33803476/33806152
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-07-16_22-47-53PM_1.log
Patch: /data/patch_software/grid/33803476/33815596
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-07-16_22-47-53PM_1.log
Patch: /data/patch_software/grid/33803476/33815607
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-07-16_22-47-53PM_1.log
Patch: /data/patch_software/grid/33803476/33911149
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2022-07-16_22-47-53PM_1.log
Patching session reported following warning(s):
_________________________________________________
[WARNING] The database instance 'cxl1' from '/u01/app/oracle/product/19.0.0.0/dbhome_1', in host'dbm0dbadm01' is not running. SQL changes, if any, will not be applied.
To apply. the SQL changes, bring up the database instance and run the command manually from any one node (run as oracle).
Refer to the readme to get the correct steps for applying the sql changes.
OPatchauto session completed at Sat Jul 16 23:05:51 2022
Time taken to complete the session 30 minutes, 16 seconds
#在升级完成后本次操作有个实例未能启动,手动通过集群命令进行拉起此告警实例。
4.完成已知打补丁坑的处理
坑1:
#拷贝以下文件与权限到节点二的相应目录
[root@dbm0dbadm01 33803476]# ll /u01/app/oraInventory/ContentsXML/oui-patch.xml
-rw-rw-r-- 1 grid oinstall 174 Jul 16 22:55 /u01/app/oraInventory/ContentsXML/oui-patch.xml
[root@dbm0dbadm01 33803476]# scp -rp /u01/app/oraInventory/ContentsXML/oui-patch.xml dbm0dbadm02:/u01/app/oraInventory/ContentsXML
#注意权限
[root@dbm0dbadm01 33803476]# ll /u01/app/19.0.0.0/grid/inventory/oneoffs
total 0
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 29340594
drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29401763
drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29517242
drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29517247
drwxr-x--- 4 grid oinstall 29 Apr 18 2019 29585399
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 32218454
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 32218663
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 32222571
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 32240590
drwxr-xr-x 4 grid oinstall 29 Apr 17 2021 32301133
drwxr-xr-x 4 grid oinstall 29 Jul 16 22:49 33575402
drwxr-xr-x 4 grid oinstall 29 Jul 16 22:53 33806152
drwxr-xr-x 4 grid oinstall 29 Jul 16 22:54 33815596
drwxr-xr-x 4 grid oinstall 29 Jul 16 22:55 33815607
drwxr-xr-x 4 grid oinstall 29 Jul 16 22:55 33911149
[root@dbm0dbadm01 33803476]# ll /u01/app/19.0.0.0/grid/inventory/oneoffs|wc -l
16
[root@dbm0dbadm01 33803476]# pwd
/data/patch_software/grid/33803476
[root@dbm0dbadm01 33803476]# scp -rp /u01/app/19.0.0.0/grid/inventory/oneoffs/* dbm0dbadm02:/u01/app/19.0.0.0/grid/inventory/oneoffs/
The authenticity of host 'dbm0dbadm02 (10.160.254.226)' can't be established.
ECDSA key fingerprint is SHA256:NaP5AaJmpnOm4ht0uP52CCDYIYHC9QuGrkcGPAYPU0s.
ECDSA key fingerprint is MD5:f8:fe:e0:c2:26:d0:f2:9d:5d:f8:20:01:59:a2:79:c5.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'dbm0dbadm02' (ECDSA) to the list of known hosts.
root@dbm0dbadm02's password:
inventory.xml 100% 1956 212.1KB/s 00:00
actions.xml 100% 2081 3.0MB/s 00:00
actions.xml 100% 3657 175.2KB/s 00:00
inventory.xml 100% 1630 298.9KB/s 00:00
actions.xml 100% 96KB 11.1MB/s 00:00
inventory.xml 100% 64KB 14.0MB/s 00:00
actions.xml 100% 351 33.4KB/s 00:00
inventory.xml 100% 2857 589.4KB/s 00:00
actions.xml 100% 347 36.8KB/s 00:00
inventory.xml 100% 18KB 2.5MB/s 00:00
inventory.xml 100% 425KB 17.6MB/s 00:00
actions.xml 100% 2606KB 67.6MB/s 00:00
inventory.xml 100% 24KB 8.4MB/s 00:00
actions.xml 100% 79KB 65.6MB/s 00:00
inventory.xml 100% 108KB 35.6MB/s 00:00
actions.xml 100% 230KB 20.2MB/s 00:00
inventory.xml 100% 2060 195.8KB/s 00:00
actions.xml 100% 2651 3.3MB/s 00:00
inventory.xml 100% 2275 642.6KB/s 00:00
actions.xml 100% 2230 5.4MB/s 00:00
inventory.xml 100% 2358 306.3KB/s 00:00
actions.xml 100% 2081 4.2MB/s 00:00
inventory.xml 100% 837KB 29.7MB/s 00:00
actions.xml 100% 5871KB 88.3MB/s 00:00
inventory.xml 100% 173KB 11.2MB/s 00:00
actions.xml 100% 233KB 82.7MB/s 00:00
inventory.xml 100% 45KB 4.7MB/s 00:00
actions.xml 100% 94KB 12.6MB/s 00:00
inventory.xml 100% 2400 297.2KB/s 00:00
actions.xml 100% 2651 4.9MB/s 00:00
[root@dbm0dbadm01 33803476]#
坑2:
#19.10升级19.15过程中会遇到OCW补丁冲突问题需要回滚原有OCW补丁
[root@dbm0dbadm01 33803476]# /u01/app/19.0.0.0/grid/OPatch/opatchauto rollback -id 32289783
5.节点一所有实例,进行数据字典更新
[root@dbm0dbadm01 33803476]# su - oracle
Last login: Sun Jul 17 00:01:48 CST 2022 on pts/1
[oracle@dbm0dbadm01 ~]$ cd $ORACLE_HOME/OPatch
[oracle@dbm0dbadm01 OPatch]$ echo $ORACLE_SID
cxl1
[oracle@dbm0dbadm01 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.15.0.0.0 Production on Sun Jul 17 00:15:35 2022
Copyright (c) 2012, 2022, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_248101_2022_07_17_00_15_35/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of interim SQL patches:
Interim patch 32067171 (OJVM RELEASE UPDATE: 19.10.0.0.210119 (32067171)):
Binary registry: Installed
PDB ALLORCL: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB CDB$ROOT: Applied successfully on 31-MAY-21 04.32.27.339011 PM
PDB DOCDB: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB DZORCL: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB FINANCE: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB FSSCPRD: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB HCSORCL: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB HLJCDB: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB HRJX: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB MIDDLEORCL: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB OAORCL: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB ORG11G: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB PDB$SEED: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB PGJTZYY: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB PGXCDZ: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB PSPROD: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB RETAILPROD: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB YTHGYY: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB ZJMIDDLE: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB ZJORCL: Applied successfully on 31-MAY-21 04.42.06.460557 PM
Current state of release update SQL patches:
Binary registry:
19.15.0.0.0 Release_Update 220331125408: Installed
PDB ALLORCL:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.33.583058 AM
PDB CDB$ROOT:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.08.816204 AM
PDB DOCDB:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.16.507502 AM
PDB DZORCL:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.05.172007 AM
PDB FINANCE:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.24.109137 AM
PDB FSSCPRD:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.23.791585 AM
PDB HCSORCL:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.43.382587 AM
PDB HLJCDB:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.20.199757 AM
PDB HRJX:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.27.418116 AM
PDB MIDDLEORCL:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.38.681471 AM
PDB OAORCL:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.28.715827 AM
PDB ORG11G:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.19.549993 AM
PDB PDB$SEED:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.14.336546 AM
PDB PGJTZYY:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.54.383704 AM
PDB PGXCDZ:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.12.872897 AM
PDB PSPROD:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.50.793932 AM
PDB RETAILPROD:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.08.855947 AM
PDB YTHGYY:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.47.068455 AM
PDB ZJMIDDLE:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.01.463680 AM
PDB ZJORCL:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.57.882226 AM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED ORG11G FINANCE OAORCL ALLORCL MIDDLEORCL HCSORCL YTHGYY PSPROD PGJTZYY ZJORCL ZJMIDDLE DZORCL RETAILPROD PGXCDZ DOCDB HLJCDB FSSCPRD HRJX
No interim patches need to be rolled back
No release update patches need to be installed
No interim patches need to be applied
SQL Patching tool complete on Sun Jul 17 00:16:13 2022
6.完成数据字典更新后关闭实例进行OJVM升级,再次进行数据字典升级
[oracle@dbm0dbadm01 OPatch]$ srvctl stop instance -d umcarets -i cxl1
[oracle@dbm0dbadm01 OPatch]$ pwd
/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch
[oracle@dbm0dbadm01 OPatch]$ cd /data/patch_software/ojvm/
33808367/ p33808367_190000_Linux-x86-64.zip PatchSearch.xml
[oracle@dbm0dbadm01 OPatch]$ cd /data/patch_software/ojvm/33808367/
[oracle@dbm0dbadm01 33808367]$ ll
total 68
drwxr-x--- 3 oracle oinstall 28 Mar 12 00:31 etc
drwxr-x--- 6 oracle oinstall 80 Mar 12 00:31 files
-rw-rw-r-- 1 oracle oinstall 63120 Apr 19 10:20 README.html
-rw-r--r-- 1 oracle oinstall 11 Mar 12 00:32 README.txt
[oracle@dbm0dbadm01 33808367]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.30
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.30
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2022-07-17_00-33-05AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@dbm0dbadm01 33808367]$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.30
Copyright (c) 2022, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.30
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2022-07-17_00-33-35AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2022-07-17_00-33-35AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: dbm0dbadm01.umexa.com
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 19c 19.0.0.0.0
There are 1 products installed in this Oracle Home.
Interim patches (3) :
Patch 33815596 : applied on Sat Jul 16 22:46:40 CST 2022
Unique Patch ID: 24719210
Patch description: "OCW RELEASE UPDATE 19.15.0.0.0 (33815596)"
Created on 6 Apr 2022, 20:34:59 hrs PST8PDT
Bugs fixed:
13742922, 17787434, 24611963, 24677421, 24943214, 25642320, 25736599
26305045, 26496292, 26615554, 26675491, 26813848, 26898787, 27092095
27148384, 27222128, 27262781, 27341142, 27445388, 27505699, 27526265
27572040, 27604329, 27663388, 27760043, 27877830, 27912364, 27935374
28107050, 28138981, 28302439, 28302580, 28319989, 28336118, 28344129
28406406, 28441307, 28462255, 28470673, 28554809, 28567875, 28572309
28597991, 28621543, 28621601, 28628631, 28642469, 28648916, 28670344
28677941, 28697242, 28697896, 28699321, 28704073, 28710663, 28723237
28747089, 28755846, 28762163, 28772816, 28785321, 28790623, 28793090
28793409, 28800508, 28805158, 28805475, 28808652, 28814106, 28815557
28828986, 28834364, 28834743, 28847541, 28847572, 28847655, 28852065
略...
33593847, 33594788, 33601071, 33617820, 33626113, 33731331, 33733953
33743193, 33744602, 33766334, 33840507, 33851570, 33879646, 33885339
34008143, 3
Patch 33806152 : applied on Sat Jul 16 22:42:47 CST 2022
Unique Patch ID: 24713297
Patch description: "Database Release Update : 19.15.0.0.220419 (33806152)"
Created on 4 Apr 2022, 06:06:27 hrs UTC
Bugs fixed:
1297945, 7391838, 8460502, 8476681, 14570574, 14735102, 15931756
15959416, 16662822, 16664572, 16750494, 17275499, 17395507, 17428816
17468475, 17777718, 18534283, 18697534, 19080742, 19138896, 19697993
略...
28833912, 28835937, 28836716, 28837979, 28838385, 28839869, 28842408
28844656, 28844738, 28845346, 28846759, 28849494, 28849776, 28850084
28851458, 28851467, 28854004, 28854212, 28854733, 28855520, 28855922
33679665, 33684377, 33695048, 33714000, 33718848, 33727406, 33736618
33738702, 33743745, 33794088, 33801237, 33808041, 33811601, 33817717
33822187, 33824830, 33850437, 33853330, 33879054, 33893127, 33896760
33921441, 33954999, 33961800, 33967599
Patch 32067171 : applied on Sat Apr 17 20:46:29 CST 2021
Unique Patch ID: 23947975
Patch description: "OJVM RELEASE UPDATE: 19.10.0.0.210119 (32067171)"
Created on 2 Dec 2020, 09:24:57 hrs UTC
Bugs fixed:
29445548, 29254623, 29540327, 29774362, 30134746, 30160625, 30534662
29512125, 29942275, 30855101, 31306261, 31359215, 30895577, 29224710
26716835, 31668872, 32165759, 32069696, 32032733, 30889443, 30674373
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@dbm0dbadm01 33808367]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.30
Copyright (c) 2022, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.30
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2022-07-17_00-33-48AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 33808367
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.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '33808367' to OH '/u01/app/oracle/product/19.0.0.0/dbhome_1'
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 33808367 successfully applied.
Sub-set patch [32067171] has become inactive due to the application of a super-set patch [33808367].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2022-07-17_00-33-48AM_1.log
OPatch succeeded.
[oracle@dbm0dbadm01 33808367]$ srvctl start instance -d umcarebg -i cxl1
[oracle@dbm0dbadm01 33808367]$ echo $ORACLE_SID
cxl1
[oracle@dbm0dbadm01 33808367]$ cd $ORACLE_HOME/OPatch
[oracle@dbm0dbadm01 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.15.0.0.0 Production on Sun Jul 17 00:41:12 2022
Copyright (c) 2012, 2022, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_17986_2022_07_17_00_41_12/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Warning: PDB INCATEST is in mode MOUNTED and will be skipped.
Warning: PDB DDITEST is in mode MOUNTED and will be skipped.
Warning: PDB YTHGYYTS is in mode MOUNTED and will be skipped.
Warning: PDB PGJTZYYTS is in mode MOUNTED and will be skipped.
Warning: PDB ZDJJTS is in mode MOUNTED and will be skipped.
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of interim SQL patches:
Interim patch 32067171 (OJVM RELEASE UPDATE: 19.10.0.0.210119 (32067171)):
Binary registry: Not installed
PDB CDB$ROOT: Applied successfully on 02-JUN-21 02.39.29.942543 PM
PDB DZPJTS: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB ERPTEST1: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB ERPTEST2: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB EWELLAGTS: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB EWELLPGTS: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB EWELLTS: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB EWELLWUYETS: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB FINANCETEST: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB FSSCSIT: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB FSSCUAT: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB HISDBTEST: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB INCAERPTEST: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB NCTEST1: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB NCTEST2: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB OAORCLTS: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB PDB$SEED: Applied successfully on 02-JUN-21 02.48.31.337311 PM
PDB PSDEV: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB PSTEST: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB PSUAT: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB RETAILTEST: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB WYDZPJTS: Applied successfully on 31-MAY-21 04.42.06.460557 PM
PDB YHIS: Applied successfully on 31-MAY-21 04.42.06.460557 PM
Interim patch 33808367 (OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367)):
Binary registry: Installed
PDB CDB$ROOT: Not installed
PDB DZPJTS: Not installed
PDB ERPTEST1: Not installed
PDB ERPTEST2: Not installed
PDB EWELLAGTS: Not installed
PDB EWELLPGTS: Not installed
PDB EWELLTS: Not installed
PDB EWELLWUYETS: Not installed
PDB FINANCETEST: Not installed
PDB FSSCSIT: Not installed
PDB FSSCUAT: Not installed
PDB HISDBTEST: Not installed
PDB INCAERPTEST: Not installed
PDB NCTEST1: Not installed
PDB NCTEST2: Not installed
PDB OAORCLTS: Not installed
PDB PDB$SEED: Not installed
PDB PSDEV: Not installed
PDB PSTEST: Not installed
PDB PSUAT: Not installed
PDB RETAILTEST: Not installed
PDB WYDZPJTS: Not installed
PDB YHIS: Not installed
Current state of release update SQL patches:
Binary registry:
19.15.0.0.0 Release_Update 220331125408: Installed
PDB CDB$ROOT:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.53.438108 AM
PDB DZPJTS:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.30.900414 AM
PDB ERPTEST1:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.08.038000 AM
PDB ERPTEST2:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.12.099789 AM
PDB EWELLAGTS:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.53.018055 AM
PDB EWELLPGTS:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.49.396756 AM
PDB EWELLTS:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.34.568994 AM
PDB EWELLWUYETS:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.38.186949 AM
PDB FINANCETEST:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.56.682175 AM
PDB FSSCSIT:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.06.07.876924 AM
PDB FSSCUAT:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.06.11.744399 AM
PDB HISDBTEST:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.27.161709 AM
PDB INCAERPTEST:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.06.04.128909 AM
PDB NCTEST1:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.04.374118 AM
PDB NCTEST2:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.00.692485 AM
PDB OAORCLTS:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.45.744236 AM
PDB PDB$SEED:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.04.57.034298 AM
PDB PSDEV:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.15.820699 AM
PDB PSTEST:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.23.253211 AM
PDB PSUAT:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.19.582934 AM
PDB RETAILTEST:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.05.41.894768 AM
PDB WYDZPJTS:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.06.15.423485 AM
PDB YHIS:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 17-JUL-22 12.06.00.387847 AM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED NCTEST2 NCTEST1 ERPTEST1 ERPTEST2 PSDEV PSUAT PSTEST HISDBTEST DZPJTS EWELLTS EWELLWUYETS RETAILTEST OAORCLTS EWELLPGTS EWELLAGTS FINANCETEST YHIS INCAERPTEST FSSCSIT FSSCUAT WYDZPJTS
The following interim patches will be rolled back:
32067171 (OJVM RELEASE UPDATE: 19.10.0.0.210119 (32067171))
No release update patches need to be installed
The following interim patches will be applied:
33808367 (OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367))
Installing patches...
Patch installation complete. Total patches installed: 46
Validating logfiles...done
Patch 32067171 rollback (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_CDBROOT_2022Jul17_00_41_44.log (no errors)
Patch 33808367 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_CDBROOT_2022Jul17_00_41_44.log (no errors)
Patch 32067171 rollback (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_PDBSEED_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_PDBSEED_2022Jul17_00_41_59.log (no errors)
Patch 32067171 rollback (pdb NCTEST2): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_NCTEST2_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb NCTEST2): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_NCTEST2_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb NCTEST1): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_NCTEST1_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb NCTEST1): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_NCTEST1_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb ERPTEST1): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_ERPTEST1_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb ERPTEST1): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_ERPTEST1_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb ERPTEST2): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_ERPTEST2_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb ERPTEST2): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_ERPTEST2_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb PSDEV): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_PSDEV_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb PSDEV): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_PSDEV_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb PSUAT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_PSUAT_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb PSUAT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_PSUAT_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb PSTEST): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_PSTEST_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb PSTEST): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_PSTEST_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb HISDBTEST): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_HISDBTEST_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb HISDBTEST): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_HISDBTEST_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb DZPJTS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_DZPJTS_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb DZPJTS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_DZPJTS_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb EWELLTS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_EWELLTS_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb EWELLTS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_EWELLTS_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb EWELLWUYETS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_EWELLWUYETS_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb EWELLWUYETS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_EWELLWUYETS_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb RETAILTEST): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_RETAILTEST_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb RETAILTEST): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_RETAILTEST_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb OAORCLTS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_OAORCLTS_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb OAORCLTS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_OAORCLTS_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb EWELLPGTS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_EWELLPGTS_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb EWELLPGTS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_EWELLPGTS_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb EWELLAGTS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_EWELLAGTS_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb EWELLAGTS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_EWELLAGTS_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb FINANCETEST): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_FINANCETEST_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb FINANCETEST): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_FINANCETEST_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb YHIS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_YHIS_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb YHIS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_YHIS_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb INCAERPTEST): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_INCAERPTEST_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb INCAERPTEST): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_INCAERPTEST_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb FSSCSIT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_FSSCSIT_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb FSSCSIT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_FSSCSIT_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb FSSCUAT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_FSSCUAT_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb FSSCUAT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_FSSCUAT_2022Jul17_00_41_49.log (no errors)
Patch 32067171 rollback (pdb WYDZPJTS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32067171/23947975/32067171_rollback_UMCARETS_WYDZPJTS_2022Jul17_00_41_48.log (no errors)
Patch 33808367 apply (pdb WYDZPJTS): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33808367/24680225/33808367_apply_UMCARETS_WYDZPJTS_2022Jul17_00_41_49.log (no errors)
SQL Patching tool complete on Sun Jul 17 00:42:19 2022
7.编译失效对象
@$ORACLE_HOME/rdbms/admin/utlrp.sql