oracle 19CRAC打补丁到19.20
前部为只有步骤和命令的简洁版本,后部为实际操作部分以及常见报错处理办法
一. 命令版
1.本次所需的补丁如下
p6880880_190000_Linux-x86-64.zip (.37的opatch)
p35354406_190000_Linux-x86-64.zip(OJVM)
p35320081_190000_Linux-x86-64.zip(DB)
p35319490_190000_Linux-x86-64.zip(GI)
19.20补丁下载链接
https://www.modb.pro/doc/113098
单实例打补丁教程看如下链接
https://www.modb.pro/db/1689502773707612160
2.更新grid opatch 两个节点 root用户执行
mv /u01/app/19.3.0/grid/OPatch /u01/app/19.3.0/grid/OPatch.bak --备份opatch
unzip -q p6880880_190000_Linux-x86-64.zip -d /u01/app/19.3.0/grid/ --更新opatch
chmod -R 755 /u01/app/19.3.0/grid/OPatch
chown -R grid:oinstall /u01/app/19.3.0/grid/OPatch
[grid@hostname ~]$ opatch version --更新后检查opatch的版本
OPatch Version: 12.2.0.1.37
OPatch succeeded.
[grid@hostname ~]$
3.更新oracle opatch 两个节点 root执行
mv /u01/app/oracle/product/19.3.0/db_1/OPatch /u01/app/oracle/product/19.3.0/db_1/OPatch.bak --备份opatch
unzip -q p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19.3.0/db_1/
chmod -R 755 /u01/app/oracle/product/19.3.0/db_1/OPatch
chown -R oracle:oinstall /u01/app/oracle/product/19.3.0/db_1/OPatch
4.解压patch包 两个节点 root执行
unzip p35319490_190000_Linux-x86-64.zip -d /u01/app/
unzip p35354406_190000_Linux-x86-64.zip -d /u01/app/
chown -R grid:oinstall /u01/app/35319490
chmod -R 755 /u01/app/35319490
chown -R grid:oinstall /u01/app/35354406
chmod -R 755 /u01/app/35354406
5.兼容性检查
OPatch兼容性检查 两个节点 grid用户
/u01/app/19.3.0/grid/OPatch/opatch lsinventory -detail -oh /u01/app/19.3.0/grid/
6.补丁冲突检查
📢 注意:db1和db2都执行
子目录的五个patch和OJVM分别在grid和oracle用户下分别执行检查
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/35319490/33575402
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/35319490/35320081
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/35319490/35320149
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/35319490/35332537
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/35319490/35553096
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/35354406
7.空间检查
📢 注意:db1和db2都执行
Grid 执行
vi /tmp/patch_list_gihome.txt #新建文件加入需要坚持的patch no
/u01/app/35319490/33575402
/u01/app/35319490/35320081
/u01/app/35319490/35320149
/u01/app/35319490/35332537
/u01/app/35319490/35553096
/u01/app/35354406
两个节点 grid用户 oracle用户分别执行
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
8.补丁分析检查
Root 执行
/u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/app/35319490 -analyze ---大约2分钟
/u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/app/35354406 -analyze ---大约6.5分钟
9.grid 升级
## roo用户两个节点都要分别执行 --grid upgrade
/u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/app/35354406 -oh /u01/app/19.3.0/grid ---约6.5分钟(OJVM)
/u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/app/35319490 -oh /u01/app/19.3.0/grid ---约12分钟(GI)
opatch lspatches
[grid@hostname ~]$ opatch lspatches --升级后的状态
35553096;TOMCAT RELEASE UPDATE 19.0.0.0.0 (35553096)
35332537;ACFS RELEASE UPDATE 19.20.0.0.0 (35332537)
35320149;OCW RELEASE UPDATE 19.20.0.0.0 (35320149)
35320081;Database Release Update : 19.20.0.0.230718 (35320081)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
35354406;OJVM RELEASE UPDATE: 19.20.0.0.230718 (35354406)
10.oracle 升级
## root两个节点都要分别执行 --oracle upgrade
oracle 升级前需要关闭数据库 --如果不关闭会有报错opatch失败
srvctl stop database -d dbname
/u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto apply /u01/app/35319490/35320081 -oh /u01/app/oracle/product/19.3.0/db_1
11.升级后动作
仅节点1
opatch lspatches
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> alter system set cluster_database=false scope=spfile; --设置接非集群
srvctl stop db -d dbname
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP UPGRADE
##以upgrade模式启动是pdb是无法open的,需要关闭后正常startup后才可以open
SQL> SHUTDOWN
SQL> STARTUP
SQL> alter system set cluster_database=true scope=spfile sid='*'; ##改回集群数据库
SQL> SHUTDOWN
srvctl start database -d dbname #启动所有节点数据库
SQL>alter pluggable database all open;
如果使用了pdb执行前确认两个节点pdb都打开,如果pdb没有打开 可能会出现cdb和pdb RU不一致,导致pdb受限。
[oracle@db1 ~]$ datapatch -verbose #确认都pdb 都open后执行datapatch
如果pdb没有更新 可以使用这个命令强制更新ru
datapatch -verbose -apply ru_id -force –pdbs pdbname
--编译无效对象
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
完成后检查patch情况
set linesize 180
col action for a15
col status for a15
select PATCH_ID,PATCH_TYPE,ACTION,STATUS,TARGET_VERSION from dba_registry_sqlpatch;
- 二.命令+输出版本(部分解压之类命令没加入)
1.解压并更新grid opatch
[root@YCSMLDWDB01 patch]# ll
total 4894488
-rwxr-xr-x. 1 root root 2990370786 Oct 18 10:31 35319490_190000_Linux-x86-64.zip
-rwxr-xr-x. 1 root root 1769419773 Oct 18 10:30 p35320081_190000_Linux-x86-64.zip
-rwxr-xr-x. 1 root root 127314614 Oct 18 10:29 p35354406_190000_Linux-x86-64.zip
-rwxr-xr-x. 1 root root 124843817 Oct 18 10:28 p6880880_190000_Linux-x86-64.zip
[root@YCSMLDWDB01 patch]# unzip -q p6880880_190000_Linux-x86-64.zip -d /u01/app/19.3.0/grid/
[root@YCSMLDWDB01 patch]#
[root@YCSMLDWDB01 patch]# chmod -R 755 /u01/app/19.3.0/grid/OPatch
[root@YCSMLDWDB01 patch]# chown -R grid:oinstall /u01/app/19.3.0/grid/OPatch
[root@YCSMLDWDB01 patch]# su - grid
Last login: Wed Oct 18 10:22:58 CST 2023
[grid@YCSMLDWDB01 ~]$ cd /u01/app/19.3.0/grid/OPatch
[grid@YCSMLDWDB01 OPatch]$ opatch version
OPatch Version: 12.2.0.1.37
OPatch succeeded.
2. 兼容性检查
[grid@YCSMLDWDB02 ~]$ /u01/app/19.3.0/grid/OPatch/opatch lsinventory -detail -oh /u01/app/19.3.0/grid/
Oracle Interim Patch Installer version 12.2.0.1.37
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.3.0/grid//oraInst.loc
OPatch version : 12.2.0.1.37
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-10-18_10-49-54AM_1.log
Lsinventory Output file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2023-10-18_10-49-54AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: YCSMLDWDB02
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 19c 19.0.0.0.0
There are 1 products installed in this Oracle Home.
Installed Products (102):
Assistant Common Files 19.0.0.0.0
Automatic Storage Management Assistant 19.0.0.0.0
BLASLAPACK Component 19.0.0.0.0
Buildtools Common Files 19.0.0.0.0
Cluster Ready Services Files 19.0.0.0.0
Cluster Verification Utility Common Files 19.0.0.0.0
Cluster Verification Utility CRS Files 19.0.0.0.0
Cluster Verification Utility Files 19.0.0.0.0
Database Configuration and Upgrade Assistants 19.0.0.0.0
Database Migration Assistant for Unicode 19.0.0.0.0
Database SQL Scripts 19.0.0.0.0
Database Workspace Manager 19.0.0.0.0
DB TOOLS Listener 19.0.0.0.0
Deinstallation Tool 19.0.0.0.0
Expat libraries 2.0.1.0.4
Hadoopcore Component 19.0.0.0.0
HAS Common Files 19.0.0.0.0
HAS Files for DB 19.0.0.0.0
Installation Common Files 19.0.0.0.0
Installation Plugin Files 19.0.0.0.0
Installer SDK Component 12.2.0.7.0
Java Development Kit 1.8.0.201.0
LDAP Required Support Files 19.0.0.0.0
OLAP SQL Scripts 19.0.0.0.0
Oracle Advanced Security 19.0.0.0.0
Oracle Bali Share 11.1.1.6.0
Oracle Clusterware RDBMS Files 19.0.0.0.0
Oracle Core Required Support Files 19.0.0.0.0
Oracle Core Required Support Files for Core DB 19.0.0.0.0
Oracle Database 19c 19.0.0.0.0
Oracle Database 19c Multimedia Files 19.0.0.0.0
Oracle Database Deconfiguration 19.0.0.0.0
Oracle Database Utilities 19.0.0.0.0
Oracle DBCA Deconfiguration 19.0.0.0.0
Oracle Extended Windowing Toolkit 11.1.1.6.0
Oracle Globalization Support 19.0.0.0.0
Oracle Globalization Support 19.0.0.0.0
Oracle Globalization Support For Core 19.0.0.0.0
Oracle Grid Infrastructure 19c 19.0.0.0.0
Oracle Grid Infrastructure Bundled Agents 19.0.0.0.0
Oracle Grid Management Database 19.0.0.0.0
Oracle Help for Java 11.1.1.7.0
Oracle Help Share Library 11.1.1.7.0
Oracle Ice Browser 11.1.1.7.0
Oracle Internet Directory Client 19.0.0.0.0
Oracle Java Client 19.0.0.0.0
Oracle JDBC Server Support Package 19.0.0.0.0
Oracle JDBC/OCI Instant Client 19.0.0.0.0
Oracle JDBC/THIN Interfaces 19.0.0.0.0
Oracle JFC Extended Windowing Toolkit 11.1.1.6.0
Oracle JVM 19.0.0.0.0
Oracle JVM For Core 19.0.0.0.0
Oracle LDAP administration 19.0.0.0.0
Oracle Locale Builder 19.0.0.0.0
Oracle Multimedia 19.0.0.0.0
Oracle Multimedia Client Option 19.0.0.0.0
Oracle Multimedia Java Advanced Imaging 19.0.0.0.0
Oracle Multimedia Locator 19.0.0.0.0
Oracle Multimedia Locator Java Required Support Files 19.0.0.0.0
Oracle Multimedia Locator RDBMS Files 19.0.0.0.0
Oracle Net 19.0.0.0.0
Oracle Net Listener 19.0.0.0.0
Oracle Net Required Support Files 19.0.0.0.0
Oracle Netca Client 19.0.0.0.0
Oracle Notification Service 19.0.0.0.0
Oracle Notification Service for Instant Client 19.0.0.0.0
Oracle One-Off Patch Installer 12.2.0.1.15
Oracle Quality of Service Management (Server) 19.0.0.0.0
Oracle RAC Required Support Files-HAS 19.0.0.0.0
Oracle Recovery Manager 19.0.0.0.0
Oracle Security Developer Tools 19.0.0.0.0
Oracle Text Required Support Files 19.0.0.0.0
Oracle Universal Connection Pool 19.0.0.0.0
Oracle Universal Installer 12.2.0.7.0
Oracle USM Deconfiguration 19.0.0.0.0
Oracle Wallet Manager 19.0.0.0.0
oracle.swd.commonlogging 13.3.0.0.0
oracle.swd.opatchautodb 12.2.0.1.5
oracle.swd.oui.core.min 12.2.0.7.0
Parser Generator Required Support Files 19.0.0.0.0
Perl Interpreter 5.28.1.0.0
Perl Modules 5.28.1.0.0
PL/SQL 19.0.0.0.0
PL/SQL Embedded Gateway 19.0.0.0.0
Platform Required Support Files 19.0.0.0.0
Precompiler Required Support Files 19.0.0.0.0
RDBMS Required Support Files 19.0.0.0.0
RDBMS Required Support Files for Instant Client 19.0.0.0.0
Required Support Files 19.0.0.0.0
RHP Files for Common 19.0.0.0.0
RHP Files for CRS 19.0.0.0.0
RHP Files for DB 19.0.0.0.0
Secure Socket Layer 19.0.0.0.0
SQL*Plus 19.0.0.0.0
SQL*Plus Files for Instant Client 19.0.0.0.0
SQL*Plus Required Support Files 19.0.0.0.0
SSL Required Support Files for InstantClient 19.0.0.0.0
Tomcat Container 19.0.0.0.0
Tracle File Analyzer 19.0.0.0.0
Universal Storage Manager Files 19.0.0.0.0
XDK Required Support Files 19.0.0.0.0
XML Parser for Java 19.0.0.0.0
There are 102 products installed in this Oracle Home.
Interim patches (4) :
Patch 29585399 : applied on Thu Apr 18 15:36:24 CST 2019
Unique Patch ID: 22840393
Patch description: "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
Created on 9 Apr 2019, 19:12:47 hrs PST8PDT
Bugs fixed:
27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673
28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321
28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040
28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250
28925460, 28935956, 28940472, 28942694, 28951332, 28963036, 28968779
28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876
29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455
29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456
29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631
29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540
29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091
29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624
29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934
29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583
29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090
29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753
29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299
29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381
29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931
29413360, 29457319, 29465047, 3
Files Touched:
clustdb.sql --> ORACLE_HOME/srvm/admin/clustdb.sql
Patch Location in Inventory:
/u01/app/19.3.0/grid/inventory/oneoffs/29585399
Patch Location in Storage area:
/u01/app/19.3.0/grid/.patch_storage/29585399_Apr_9_2019_19_12_47
Patch 29517247 : applied on Thu Apr 18 15:36:02 CST 2019
Unique Patch ID: 22840392
Patch description: "ACFS RELEASE UPDATE 19.3.0.0.0 (29517247)"
Created on 1 Apr 2019, 15:08:20 hrs PST8PDT
Bugs fixed:
28611527, 28687713, 28701011, 28740425, 28844788, 28860451, 28960047
29031452, 29039918, 29115917, 29198743, 29264772
Files Touched:
security.xsd --> ORACLE_HOME/usm/xml/schema/security.xsd
Patch Location in Inventory:
/u01/app/19.3.0/grid/inventory/oneoffs/29517247
Patch Location in Storage area:
/u01/app/19.3.0/grid/.patch_storage/29517247_Apr_1_2019_15_08_20
Patch 29517242 : applied on Thu Apr 18 15:35:39 CST 2019
Unique Patch ID: 22862832
Patch description: "Database Release Update : 19.3.0.0.190416 (29517242)"
Created on 17 Apr 2019, 23:27:10 hrs PST8PDT
Bugs fixed:
14735102, 19697993, 20313356, 21965541, 25806201, 25883179, 25986062
26476244, 26611353, 26872233, 27369515, 27423500, 27666312, 27710072
27846298, 27957203, 28064977, 28072567, 28129791, 28181021, 28210681
28279456, 28313275, 28350595, 28371123, 28379065, 28431445, 28463226
28489419, 28502773, 28513333, 28534475, 28561704, 28569897, 28572533
28572544, 28587723, 28593682, 28594086, 28597221, 28601957, 28605066
28606598, 28625862, 28627033, 28636532, 28643718, 28644549, 28645570
28646200, 28646939, 28649388, 28655209, 28663782, 28673945, 28692275
28694872, 28696373, 28705231, 28710385, 28710734, 28714461, 28718469
28730079, 28740708, 28760206, 28772390, 28774416, 28777214, 28789531
28791852, 28795551, 28802734, 28804517, 28810381, 28811560, 28815123
28815355, 28819640, 28824482, 28833912, 28835937, 28862532, 28863432
28873575, 28876253, 28876639, 28884931, 28888327, 28892794, 28897512
28899663, 28901126, 28905457, 28907196, 28912691, 28915561, 28917080
28918429, 28919145, 28922227, 28922532, 28922608, 28925634, 28925880
28933158, 28936114, 28937717, 28938698, 28940179, 28940281, 28941901
28942455, 28945421, 28945994, 28951533, 28952168, 28954762, 28955606
28957292, 28957723, 28962775, 28965231, 28966444, 28974083, 28977322
28983095, 28983486, 28986326, 28986481, 28988482, 28989306, 28993295
28994307, 28996376, 29000000, 29001888, 29002927, 29003738, 29006318
29006621, 29007321, 29007775, 29008035, 29011936, 29013475, 29014076
29015118, 29017265, 29018655, 29019121, 29021063, 29021352, 29024552
29026582, 29026606, 29027456, 29027694, 29027940, 29031575, 29031600
29032234, 29032457, 29032607, 29033052, 29033145, 29033200, 29033280
29034587, 29037290, 29038528, 29039089, 29039510, 29043554, 29043651
29043725, 29044763, 29044954, 29047850, 29048289, 29048498, 29048605
29050560, 29050765, 29051702, 29052726, 29053783, 29056024, 29056270
29056560, 29059011, 29061959, 29062692, 29062848, 29062860, 29062868
29110526, 29110783, 29110790, 29110797, 29110802, 29110805, 29111598
29113282, 29113305, 29117526, 29117642, 29119077, 29120223, 29122224
29122254, 29123297, 29123432, 29123482, 29124368, 29125380, 29126345
29127957, 29128935, 29129450, 29129497, 29129712, 29130219, 29131539
29132938, 29134447, 29136111, 29138641, 29141316, 29141341, 29141685
29142667, 29144995, 29145214, 29145730, 29149829, 29150338, 29151520
29152357, 29155099, 29157389, 29158680, 29158899, 29159909, 29159936
29160174, 29162095, 29163415, 29163437, 29163524, 29163567, 29167111
29167342, 29167374, 29167940, 29168219, 29168433, 29169073, 29169215
29171942, 29172618, 29172826, 29173140, 29173373, 29173817, 29174004
29176318, 29177466, 29177543, 29177886, 29178385, 29180313, 29180455
29180559, 29180893, 29181153, 29181231, 29181620, 29181743, 29181923
29182019, 29183912, 29184297, 29184666, 29185193, 29186456, 29189302
29189307, 29189889, 29190235, 29190474, 29190740, 29191541, 29192419
29192468, 29192685, 29193207, 29194205, 29194367, 29194493, 29194827
29195279, 29195337, 29195758, 29196725, 29199635, 29199733, 29200316
29200700, 29201494, 29201539, 29202104, 29202850, 29203122, 29203166
29203425, 29203443, 29203604, 29205281, 29205323, 29205419, 29205463
29205767, 29205918, 29206109, 29206605, 29207073, 29208260, 29208732
29211457, 29211724, 29212012, 29212433, 29212611, 29213351, 29213775
29213850, 29213879, 29214561, 29214960, 29216746, 29216984, 29217294
29217472, 29217828, 29217848, 29218570, 29219205, 29219273, 29220079
29221248, 29221891, 29222031, 29222784, 29223833, 29223859, 29223967
29224065, 29224605, 29225076, 29227602, 29228869, 29229164, 29229754
29229844, 29229955, 29230252, 29230565, 29231133, 29232117, 29232154
29234123, 29237538, 29240307, 29241345, 29242017, 29242884, 29243958
29245137, 29245160, 29246163, 29247415, 29247712, 29247906, 29248552
29248835, 29248858, 29249991, 29250059, 29251259, 29253184, 29253871
29254031, 29254930, 29255178, 29255273, 29255431, 29255435, 29256426
29259119, 29259320, 29261906, 29262512, 29262887, 29265448, 29266248
29266899, 29267292, 29268412, 29269171, 29270585, 29273539, 29273735
29273847, 29274428, 29274564, 29274627, 29275461, 29278218, 29279658
29279751, 29279854, 29282898, 29285503, 29285788, 29285956, 29286037
29287130, 29287705, 29292837, 29293072, 29297863, 29297915, 29298220
29299049, 29299082, 29299844, 29301566, 29302963, 29303918, 29304781
29311588, 29312310, 29312734, 29312753, 29313347, 29313417, 29313525
29314539, 29318410, 29319441, 29321489, 29323946, 29324568, 29325087
29325105, 29325257, 29325993, 29327044, 29329087, 29331209, 29331380
29331493, 29332771, 29333500, 29337310, 29338315, 29338453, 29338780
29338913, 29339155, 29341209, 29343086, 29346943, 29347620, 29348176
29350052, 29351386, 29351716, 29351749, 29352867, 29353271, 29355654
29356547, 29356752, 29358828, 29360672, 29361801, 29363151, 29364171
29364177, 29367019, 29367561, 29368253, 29373418, 29373588, 29374179
29377986, 29378029, 29379978, 29382784, 29385652, 29386502, 29386635
29386660, 29387274, 29388094, 29388524, 29388830, 29389889, 29390435
29394140, 29394749, 29397954, 29398863, 29399100, 29399121, 29405012
29405651, 29412066, 29412269, 29417884, 29423826, 29429264, 29429566
29431485, 29435652, 29438736, 29439522, 29450421, 29451386, 29452576
29452953, 29457807, 29460252, 29462957, 29486181, 29507616, 29515240
29521748, 29530812, 29531654, 29557336, 29558975, 29601461
Files Touched:
metadata_oracle_xdk_rsf_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_xdk_rsf_29517242.txt
metadata_oracle_nlsrtl_rsf_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_nlsrtl_rsf_29517242.txt
metadata_oracle_ons_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_ons_29517242.txt
metadata_oracle_dbjava_jdbc_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_dbjava_jdbc_29517242.txt
metadata_oracle_rdbms_rsf_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_rdbms_rsf_29517242.txt
metadata_oracle_network_listener_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_network_listener_29517242.txt
metadata_oracle_assistants_deconfig_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_assistants_deconfig_29517242.txt
metadata_oracle_assistants_acf_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_assistants_acf_29517242.txt
metadata_oracle_rdbms_util_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_rdbms_util_29517242.txt
metadata_oracle_assistants_asm_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_assistants_asm_29517242.txt
metadata_oracle_ctx_rsf_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_ctx_rsf_29517242.txt
metadata_oracle_duma_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_duma_29517242.txt
metadata_oracle_rdbms_rsf_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_rdbms_rsf_29517242.txt
metadata_oracle_sqlplus_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_sqlplus_29517242.txt
metadata_oracle_rdbms_deconfig_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_rdbms_deconfig_29517242.txt
metadata_oracle_sdo_locator_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_sdo_locator_29517242.txt
metadata_oracle_dbjava_ic_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_dbjava_ic_29517242.txt
metadata_oracle_rdbms_dbscripts_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_rdbms_dbscripts_29517242.txt
metadata_oracle_network_client_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_network_client_29517242.txt
metadata_oracle_rdbms_rman_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_rdbms_rman_29517242.txt
metadata_oracle_rdbms_install_plugins_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_rdbms_install_plugins_29517242.txt
metadata_oracle_dbjava_ucp_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_dbjava_ucp_29517242.txt
metadata_oracle_tfa_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_tfa_29517242.txt
metadata_oracle_sqlplus_ic_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_sqlplus_ic_29517242.txt
metadata_oracle_network_rsf_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_network_rsf_29517242.txt
metadata_oracle_sdo_locator_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_sdo_locator_29517242.txt
metadata_oracle_buildtools_rsf_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_buildtools_rsf_29517242.txt
metadata_oracle_ovm_29517242.txt --> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/metadata_oracle_ovm_29517242.txt
29517242_apply.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/29517242_apply.sql
29517242_rollback.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/29517242_rollback.sql
29517242.xml --> ORACLE_HOME/sqlpatch/29517242/22862832/29517242.xml
prvtimd.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtimd.plb
sdoaggrh.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoaggrh.sql
sdostats.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdostats.plb
sdoutlb.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoutlb.plb
sdoloadj.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoloadj.sql
sdocat.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdocat.plb
prvt3gl.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvt3gl.sql
prvtlrsb.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtlrsb.plb
sdo.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdo.sql
sdosrid.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdosrid.sql
prvtmd1.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtmd1.plb
sdoepsgv0.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoepsgv0.sql
prvtgeom.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtgeom.plb
catmdlocp1.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/catmdlocp1.sql
prvtmd.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtmd.plb
sdolrsmd.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdolrsmd.sql
prvterr.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvterr.plb
prvtfeature.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtfeature.plb
sdofeature.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdofeature.sql
sdogmlsc.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdogmlsc.sql
catmdtrig.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/catmdtrig.sql
prvtgmd.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtgmd.plb
prvtadmn.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtadmn.plb
sdoepsgl.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoepsgl.plb
prvtcat.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtcat.plb
prvtsidx.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtsidx.plb
sdogeom.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdogeom.sql
prvt3glh.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvt3glh.plb
prvtcs.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtcs.plb
catmdloct.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/catmdloct.sql
prvtsrid.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtsrid.plb
sdoaggrb.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoaggrb.plb
prvtmig.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtmig.plb
catmdloch.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/catmdloch.sql
sdoutlh.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoutlh.sql
sdojsph.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdojsph.sql
sdopopt.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdopopt.plb
sdoutl.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoutl.plb
sdoepsgx.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoepsgx.sql
md.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/md.sql
sdojspnjh.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdojspnjh.sql
sdoepsgv.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoepsgv.sql
sdolrsh.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdolrsh.sql
sdoutlb.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoutlb.sql
prvtrtr.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtrtr.plb
prvt3gl.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvt3gl.plb
sdoepsgd.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoepsgd.sql
prvtoper.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtoper.plb
mdprivs.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/mdprivs.sql
prvtsipt.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtsipt.plb
prvtsdo.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtsdo.plb
sdomapd.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdomapd.sql
sdocsdef.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdocsdef.sql
sdocs.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdocs.sql
sdotune.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdotune.sql
prvtmem.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtmem.plb
sdogmmh.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdogmmh.sql
prvtpidx.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtpidx.plb
prvttmd.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvttmd.plb
prvtgeom.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtgeom.sql
sdotypes.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdotypes.sql
sdoadmin.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoadmin.sql
sdosfs.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdosfs.sql
sdomig.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdomig.sql
sdoepsgl2.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoepsgl2.plb
catmdlocj.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/catmdlocj.sql
prvt3glh.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvt3glh.sql
catmdlocp2.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/catmdlocp2.sql
relate.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/relate.sql
sdotxth.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdotxth.sql
prvtprdx.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtprdx.plb
prvttune.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvttune.plb
sdogmmb.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdogmmb.plb
sdopidx.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdopidx.sql
sdolrsb.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdolrsb.plb
catmdloc.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/catmdloc.sql
prvtlrsh.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtlrsh.plb
sdoepsgl3.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoepsgl3.plb
sdoepsgl4.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoepsgl4.plb
sdoogc.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdoogc.sql
sdotypeg.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdotypeg.sql
prvtmd2.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/prvtmd2.plb
sdotptyp.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdotptyp.sql
sdocsvws.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdocsvws.sql
sdovis3dschema.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdovis3dschema.sql
sdotpmd.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/md/admin/sdotpmd.sql
prvtgwmpl.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/src/server/gwm/prvtgwmpl.sql
dbmssqlt.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmssqlt.sql
prvtemxi.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtemxi.plb
prvtgwmdb.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtgwmdb.plb
prvtsqlu.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtsqlu.plb
cataivw.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/cataivw.sql
dbmsgwmdb.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmsgwmdb.sql
catspd.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/catspd.sql
dbmsgwmco.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmsgwmco.sql
prvtgwmpl.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtgwmpl.plb
prvtsrv.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtsrv.plb
catappcontainer.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/catappcontainer.sql
prvtsqlt.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtsqlt.plb
dbmsrman.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmsrman.sql
dbmsgwmpl.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmsgwmpl.sql
prvtgwmco.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtgwmco.plb
prvtspmi.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtspmi.plb
dbmsgwm.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmsgwm.sql
prvtash.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtash.plb
dbmssqlu.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmssqlu.sql
prvtemx_dbhome.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtemx_dbhome.plb
catcdbviews.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/catcdbviews.sql
prvtgwmfx.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtgwmfx.plb
cdcore_mig.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/cdcore_mig.sql
prvtspm.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtspm.plb
prvtgwmalt.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtgwmalt.plb
dbmsgwmfx.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmsgwmfx.sql
prvtgwm.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtgwm.sql
prvthdm.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvthdm.plb
catadv.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/catadv.sql
dbmsgwmcl.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmsgwmcl.sql
dbmsrmansys.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmsrmansys.sql
prvtgwmfix.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtgwmfix.plb
catawrvw.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/catawrvw.sql
catawrpdbvw.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/catawrpdbvw.sql
prvtgwmcl.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtgwmcl.plb
catost.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/catost.sql
awrmacro.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/awrmacro.sql
prvtaii.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtaii.plb
catawrrtvw.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/catawrrtvw.sql
prvtgwmut.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtgwmut.plb
prvtsqlqi.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtsqlqi.plb
prvtrmns.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtrmns.plb
dbmsgwmfix.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmsgwmfix.sql
dbmsgwmut.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmsgwmut.sql
execsmb.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/execsmb.sql
prvtstai.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvtstai.plb
prvsash.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvsash.plb
dbmsgwmalt.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/dbmsgwmalt.sql
prvsspmi.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/prvsspmi.plb
bug_29032457_rollback.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.3.0.0.0-RU-Release_Update-190410122720/rdbms/admin/backport_files/bug_29032457_rollback.sql
relate.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/relate.sql
sdopopt.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdopopt.plb
prvtoper.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtoper.plb
sdoepsgd.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoepsgd.sql
sdoutlh.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoutlh.sql
sdojsph.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdojsph.sql
prvtmig.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtmig.plb
sdoepsgx.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoepsgx.sql
sdoepsgl2.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoepsgl2.plb
sdoepsgv.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoepsgv.sql
sdogeom.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdogeom.sql
prvtcat.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtcat.plb
sdovis3dschema.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdovis3dschema.sql
sdojspnjh.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdojspnjh.sql
sdoadmin.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoadmin.sql
sdoogc.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoogc.sql
prvtgeom.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtgeom.sql
sdotypes.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdotypes.sql
sdocsdef.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdocsdef.sql
prvtsipt.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtsipt.plb
prvtpidx.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtpidx.plb
prvtgmd.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtgmd.plb
prvterr.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvterr.plb
prvtprdx.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtprdx.plb
sdoepsgl3.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoepsgl3.plb
sdoutl.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoutl.plb
prvttune.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvttune.plb
sdoepsgl4.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoepsgl4.plb
prvt3glh.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvt3glh.sql
catmdlocp2.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/catmdlocp2.sql
sdotypeg.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdotypeg.sql
prvtmd1.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtmd1.plb
sdotptyp.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdotptyp.sql
sdocsvws.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdocsvws.sql
sdosrid.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdosrid.sql
catmdlocj.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/catmdlocj.sql
catmdloc.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/catmdloc.sql
prvtlrsh.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtlrsh.plb
sdomig.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdomig.sql
prvtimd.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtimd.plb
sdosfs.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdosfs.sql
prvt3gl.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvt3gl.sql
sdoutlb.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoutlb.plb
sdotpmd.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdotpmd.sql
sdoepsgv0.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoepsgv0.sql
prvtmd2.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtmd2.plb
sdocs.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdocs.sql
sdoaggrh.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoaggrh.sql
sdolrsb.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdolrsb.plb
prvtlrsb.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtlrsb.plb
sdostats.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdostats.plb
sdoloadj.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoloadj.sql
sdotxth.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdotxth.sql
md.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/md.sql
sdolrsmd.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdolrsmd.sql
sdogmmb.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdogmmb.plb
sdopidx.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdopidx.sql
prvtcs.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtcs.plb
sdofeature.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdofeature.sql
prvtgeom.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtgeom.plb
catmdlocp1.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/catmdlocp1.sql
prvttmd.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvttmd.plb
sdocat.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdocat.plb
prvtsidx.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtsidx.plb
sdoepsgl.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoepsgl.plb
catmdloct.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/catmdloct.sql
prvt3glh.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvt3glh.plb
sdogmlsc.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdogmlsc.sql
catmdloch.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/catmdloch.sql
prvtsdo.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtsdo.plb
sdomapd.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdomapd.sql
sdogmmh.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdogmmh.sql
prvtmem.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtmem.plb
prvtadmn.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtadmn.plb
sdotune.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdotune.sql
prvt3gl.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvt3gl.plb
sdoaggrb.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoaggrb.plb
sdoutlb.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdoutlb.sql
prvtrtr.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtrtr.plb
prvtfeature.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtfeature.plb
sdolrsh.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdolrsh.sql
mdprivs.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/mdprivs.sql
sdo.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/sdo.sql
catmdtrig.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/catmdtrig.sql
prvtsrid.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtsrid.plb
prvtmd.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/md/admin/prvtmd.plb
cataivw.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/cataivw.sql
dbmsgwmdb.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmsgwmdb.sql
dbmssqlu.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmssqlu.sql
prvtsqlt.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtsqlt.plb
dbmsrman.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmsrman.sql
prvtspmi.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtspmi.plb
prvtgwmdb.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtgwmdb.plb
prvtemx_dbhome.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtemx_dbhome.plb
catspd.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/catspd.sql
prvtsrv.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtsrv.plb
prvtash.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtash.plb
dbmsgwm.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmsgwm.sql
dbmsgwmpl.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmsgwmpl.sql
prvtgwmco.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtgwmco.plb
prvtsqlu.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtsqlu.plb
dbmssqlt.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmssqlt.sql
prvtemxi.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtemxi.plb
dbmsgwmco.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmsgwmco.sql
prvtgwmpl.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtgwmpl.plb
prvsspmi.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvsspmi.plb
catawrpdbvw.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/catawrpdbvw.sql
prvtgwmcl.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtgwmcl.plb
prvtspm.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtspm.plb
dbmsgwmalt.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmsgwmalt.sql
dbmsgwmcl.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmsgwmcl.sql
dbmsrmansys.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmsrmansys.sql
prvtstai.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtstai.plb
prvtrmns.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtrmns.plb
dbmsgwmfx.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmsgwmfx.sql
catawrrtvw.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/catawrrtvw.sql
catappcontainer.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/catappcontainer.sql
prvtgwm.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtgwm.sql
prvthdm.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvthdm.plb
prvtgwmfx.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtgwmfx.plb
prvtaii.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtaii.plb
catcdbviews.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/catcdbviews.sql
dbmsgwmfix.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmsgwmfix.sql
awrmacro.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/awrmacro.sql
catadv.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/catadv.sql
catawrvw.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/catawrvw.sql
prvtgwmfix.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtgwmfix.plb
execsmb.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/execsmb.sql
catost.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/catost.sql
prvsash.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvsash.plb
prvtsqlqi.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtsqlqi.plb
dbmsgwmut.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/dbmsgwmut.sql
prvtgwmut.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtgwmut.plb
cdcore_mig.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/cdcore_mig.sql
prvtgwmalt.plb --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/admin/prvtgwmalt.plb
prvtgwmpl.sql --> ORACLE_HOME/sqlpatch/29517242/22862832/rollback_files/19.1.0.0.0/rdbms/src/server/gwm/prvtgwmpl.sql
Patch Location in Inventory:
/u01/app/19.3.0/grid/inventory/oneoffs/29517242
Patch Location in Storage area:
/u01/app/19.3.0/grid/.patch_storage/29517242_Apr_17_2019_23_27_10
Patch 29401763 : applied on Thu Apr 18 15:35:16 CST 2019
Unique Patch ID: 22759421
Patch description: "TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)"
Created on 11 Apr 2019, 22:26:25 hrs PST8PDT
Bugs fixed:
29286300
Files Touched:
catalina.policy --> ORACLE_HOME/tomcat/conf/catalina.policy
catalina.properties --> ORACLE_HOME/tomcat/conf/catalina.properties
context.xml --> ORACLE_HOME/tomcat/conf/context.xml
logging.properties --> ORACLE_HOME/tomcat/conf/logging.properties
server.xml --> ORACLE_HOME/tomcat/conf/server.xml
web.xml --> ORACLE_HOME/tomcat/conf/web.xml
annotations-api.jar --> ORACLE_HOME/tomcat/lib/annotations-api.jar
bootstrap.jar --> ORACLE_HOME/tomcat/lib/bootstrap.jar
catalina.jar --> ORACLE_HOME/tomcat/lib/catalina.jar
jaspic-api.jar --> ORACLE_HOME/tomcat/lib/jaspic-api.jar
servlet-api.jar --> ORACLE_HOME/tomcat/lib/servlet-api.jar
tomcat-api.jar --> ORACLE_HOME/tomcat/lib/tomcat-api.jar
tomcat-coyote.jar --> ORACLE_HOME/tomcat/lib/tomcat-coyote.jar
tomcat-jni.jar --> ORACLE_HOME/tomcat/lib/tomcat-jni.jar
tomcat-juli.jar --> ORACLE_HOME/tomcat/lib/tomcat-juli.jar
tomcat-util-scan.jar --> ORACLE_HOME/tomcat/lib/tomcat-util-scan.jar
tomcat-util.jar --> ORACLE_HOME/tomcat/lib/tomcat-util.jar
Patch Location in Inventory:
/u01/app/19.3.0/grid/inventory/oneoffs/29401763
Patch Location in Storage area:
/u01/app/19.3.0/grid/.patch_storage/29401763_Apr_11_2019_22_26_25
--------------------------------------------------------------------------------
OPatch succeeded.
[grid@YCSMLDWDB02 ~]$
3.补丁冲突检查
[grid@YCSMLDWDB01 OPatch]$
[oracle@YCSMLMESDB02 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/35319490/33575402
Oracle Interim Patch Installer version 12.2.0.1.37
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.37
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-10-17_14-30-50PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@YCSMLMESDB02 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/35319490/35320081
Oracle Interim Patch Installer version 12.2.0.1.37
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.37
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-10-17_14-30-51PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@YCSMLMESDB02 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/35319490/35320149
Oracle Interim Patch Installer version 12.2.0.1.37
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.37
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-10-17_14-30-57PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@YCSMLMESDB02 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/35319490/35332537
Oracle Interim Patch Installer version 12.2.0.1.37
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.37
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-10-17_14-30-58PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@YCSMLMESDB02 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/35319490/35553096
Oracle Interim Patch Installer version 12.2.0.1.37
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.37
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-10-17_14-30-59PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
4.空间检查
[grid@YCSMLMESDB01 ~]$ vi /tmp/patch_list_gihome.txt
[grid@YCSMLMESDB01 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
Oracle Interim Patch Installer version 12.2.0.1.37
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.3.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.3.0/grid/oraInst.loc
OPatch version : 12.2.0.1.37
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.3.0/grid/cfgtoollogs/opatch/opatch2023-10-17_14-35-45PM_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
[grid@YCSMLMESDB01 ~]$ exit
logout
[root@YCSMLMESDB01 35319490]# su - oracle
Last login: Tue Oct 17 14:30:20 CST 2023 on pts/0
[oracle@YCSMLMESDB01 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
Oracle Interim Patch Installer version 12.2.0.1.37
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.37
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2023-10-17_14-35-56PM_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
[oracle@YCSMLMESDB01 ~]$
5.补丁分析
[root@YCSMLMESDB01 35319490]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/app/35319490 -analyze
OPatchauto session is initiated at Tue Oct 17 14:39:30 2023
System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-10-17_02-39-34PM.log.
Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2023-10-17_02-39-54PM.log
The id for this session is IP9X
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1
Patch applicability verified successfully on home /u01/app/19.3.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1
Executing patch validation checks on home /u01/app/19.3.0/grid
Patch validation checks successfully completed on home /u01/app/19.3.0/grid
Executing patch validation checks on home /u01/app/oracle/product/19.3.0/db_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/db_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has failed:
Host:ycsmlmesdb01
CRS Home:/u01/app/19.3.0/grid
Version:19.0.0.0.0
Analysis for patches has failed.
==Following patches FAILED in analysis for apply:
Patch: /u01/app/35319490/35320081
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-40-09PM_1.log
Reason: Failed during Analysis: CheckSystemCommandsAvailable Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Missing command :fuser]
###报错原因是确少一个包fuser命令 需要安装 yum install -y psmisc
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/app/35319490/35320149
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-40-09PM_1.log
Patch: /u01/app/35319490/35332537
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-40-09PM_1.log
Patch: /u01/app/35319490/33575402
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-40-09PM_1.log
Patch: /u01/app/35319490/35553096
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-40-09PM_1.log
Host:ycsmlmesdb01
RAC Home:/u01/app/oracle/product/19.3.0/db_1
Version:19.0.0.0.0
Analysis for patches has failed.
==Following patches FAILED in analysis for apply:
Patch: /u01/app/35319490/35320081
Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-40-09PM_1.log
Reason: Failed during Analysis: CheckSystemCommandsAvailable Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Missing command :fuser]
==Following patches were SKIPPED:
Patch: /u01/app/35319490/35332537
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/app/35319490/33575402
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/app/35319490/35553096
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/app/35319490/35320149
Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-40-09PM_1.log
OPATCHAUTO-72053: Analysis for the patches failed.
OPATCHAUTO-72053: Command execution failed.
OPATCHAUTO-72053: Please check the summary for more details.
OPatchauto session completed at Tue Oct 17 14:41:16 2023
Time taken to complete the session 1 minute, 42 seconds
[root@YCSMLMESDB01 35319490]#
[root@YCSMLMESDB01 35319490]# yum search fuser
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.163.com
* extras: mirrors.ustc.edu.cn
* updates: mirrors.ustc.edu.cn
======================================================================== Matched: fuser ========================================================================
psmisc.x86_64 : Utilities for managing processes on your system
[root@YCSMLMESDB01 35319490]# yum install -y psmisc
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.ustc.edu.cn
* extras: mirrors.ustc.edu.cn
* updates: mirrors.ustc.edu.cn
base | 3.6 kB 00:00:00
extras | 2.9 kB 00:00:00
updates | 2.9 kB 00:00:00
Resolving Dependencies
--> Running transaction check
---> Package psmisc.x86_64 0:22.20-17.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================================================================================================
Package Arch Version Repository Size
================================================================================================================================================================
Installing:
psmisc x86_64 22.20-17.el7 base 141 k
Transaction Summary
================================================================================================================================================================
Install 1 Package
Total download size: 141 k
Installed size: 475 k
Downloading packages:
psmisc-22.20-17.el7.x86_64.rpm | 141 kB 00:00:02
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
Installing : psmisc-22.20-17.el7.x86_64 1/1
Verifying : psmisc-22.20-17.el7.x86_64 1/1
Installed:
psmisc.x86_64 0:22.20-17.el7
Complete!
[root@YCSMLMESDB01 35319490]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/app/35319490 -analyze
OPatchauto session is initiated at Tue Oct 17 14:49:35 2023
System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-10-17_02-49-38PM.log.
Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2023-10-17_02-49-56PM.log
The id for this session is T1QD
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1
Patch applicability verified successfully on home /u01/app/19.3.0/grid
Executing patch validation checks on home /u01/app/19.3.0/grid
Patch validation checks successfully completed on home /u01/app/19.3.0/grid
Executing patch validation checks on home /u01/app/oracle/product/19.3.0/db_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/db_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:ycsmlmesdb01
RAC Home:/u01/app/oracle/product/19.3.0/db_1
Version:19.0.0.0.0
==Following patches were SKIPPED:
Patch: /u01/app/35319490/35332537
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/app/35319490/33575402
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/app/35319490/35553096
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/app/35319490/35320149
Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-50-11PM_1.log
Patch: /u01/app/35319490/35320081
Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-50-11PM_1.log
Host:ycsmlmesdb01
CRS Home:/u01/app/19.3.0/grid
Version:19.0.0.0.0
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/app/35319490/35320149
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-50-11PM_1.log
Patch: /u01/app/35319490/35332537
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-50-11PM_1.log
Patch: /u01/app/35319490/33575402
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-50-11PM_1.log
Patch: /u01/app/35319490/35553096
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-50-11PM_1.log
Patch: /u01/app/35319490/35320081
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-50-11PM_1.log
OPatchauto session completed at Tue Oct 17 14:51:21 2023
Time taken to complete the session 1 minute, 43 seconds
[root@YCSMLMESDB01 patch]#
[root@YCSMLMESDB01 patch]# cd /u01/app
[root@YCSMLMESDB01 app]# ll
[root@YCSMLMESDB01 app]#
[root@YCSMLMESDB01 app]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/app/35354406 -analyze
OPatchauto session is initiated at Tue Oct 17 14:58:19 2023
System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-10-17_02-58-20PM.log.
Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2023-10-17_02-58-37PM.log
The id for this session is WXL9
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1
Patch applicability verified successfully on home /u01/app/19.3.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1
Executing patch validation checks on home /u01/app/19.3.0/grid
Patch validation checks successfully completed on home /u01/app/19.3.0/grid
Executing patch validation checks on home /u01/app/oracle/product/19.3.0/db_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/db_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:ycsmlmesdb01
CRS Home:/u01/app/19.3.0/grid
Version:19.0.0.0.0
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/app/35354406
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-58-46PM_1.log
Host:ycsmlmesdb01
RAC Home:/u01/app/oracle/product/19.3.0/db_1
Version:19.0.0.0.0
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u01/app/35354406
Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_14-58-46PM_1.log
OPatchauto session completed at Tue Oct 17 14:59:31 2023
Time taken to complete the session 1 minute, 12 seconds
[root@YCSMLMESDB01 app]
6.grid升级
[root@YCSMLMESDB02 patch]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/app/35354406 -oh /u01/app/19.3.0/grid (OJVM)
OPatchauto session is initiated at Tue Oct 17 15:00:41 2023
System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-10-17_03-00-43PM.log.
Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2023-10-17_03-00-51PM.log
The id for this session is 1AP5
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid
Patch applicability verified successfully on home /u01/app/19.3.0/grid
Executing patch validation checks on home /u01/app/19.3.0/grid
Patch validation checks successfully completed on home /u01/app/19.3.0/grid
Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.3.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/ycsmlmesdb02/crsconfig/crs_prepatch_ycsmlmesdb02_2023-10-17_03-01-01PM.log
CRS service brought down successfully on home /u01/app/19.3.0/grid
Start applying binary patch on home /u01/app/19.3.0/grid
Binary patch applied successfully on home /u01/app/19.3.0/grid
Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.3.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/ycsmlmesdb02/crsconfig/crs_postpatch_ycsmlmesdb02_2023-10-17_03-02-35PM.log
CRS service started successfully on home /u01/app/19.3.0/grid
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:ycsmlmesdb02
CRS Home:/u01/app/19.3.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u01/app/35354406
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_15-02-10PM_1.log
OPatchauto session completed at Tue Oct 17 15:04:42 2023
Time taken to complete the session 4 minutes, 1 second
[root@YCSMLMESDB02 patch]#
[root@YCSMLMESDB02 patch]# /u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/app/35319490 -oh /u01/app/19.3.0/grid(GI)
OPatchauto session is initiated at Tue Oct 17 15:25:23 2023
System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-10-17_03-25-27PM.log.
Session log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/opatchauto2023-10-17_03-25-37PM.log
The id for this session is NY7P
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0/grid
Patch applicability verified successfully on home /u01/app/19.3.0/grid
Executing patch validation checks on home /u01/app/19.3.0/grid
Patch validation checks successfully completed on home /u01/app/19.3.0/grid
Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.3.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/ycsmlmesdb02/crsconfig/crs_prepatch_apply_inplace_ycsmlmesdb02_2023-10-17_03-26-23PM.log
CRS service brought down successfully on home /u01/app/19.3.0/grid
Start applying binary patch on home /u01/app/19.3.0/grid
Binary patch applied successfully on home /u01/app/19.3.0/grid
Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.3.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/ycsmlmesdb02/crsconfig/crs_postpatch_apply_inplace_ycsmlmesdb02_2023-10-17_03-32-36PM.log
CRS service started successfully on home /u01/app/19.3.0/grid
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:ycsmlmesdb02
CRS Home:/u01/app/19.3.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u01/app/35319490/33575402
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_15-28-58PM_1.log
Patch: /u01/app/35319490/35320081
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_15-28-58PM_1.log
Patch: /u01/app/35319490/35320149
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_15-28-58PM_1.log
Patch: /u01/app/35319490/35332537
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_15-28-58PM_1.log
Patch: /u01/app/35319490/35553096
Log: /u01/app/19.3.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_15-28-58PM_1.log
OPatchauto session completed at Tue Oct 17 15:37:17 2023
Time taken to complete the session 11 minutes, 50 seconds
[root@YCSMLMESDB02 patch]#
[root@YCSMLMESDB02 patch]# su - grid
Last login: Tue Oct 17 15:37:15 CST 2023
[grid@YCSMLMESDB02 ~]$
[grid@YCSMLMESDB02 ~]$
[grid@YCSMLMESDB02 ~]$ opatch lspatches
35553096;TOMCAT RELEASE UPDATE 19.0.0.0.0 (35553096)
35332537;ACFS RELEASE UPDATE 19.20.0.0.0 (35332537)
35320149;OCW RELEASE UPDATE 19.20.0.0.0 (35320149)
35320081;Database Release Update : 19.20.0.0.230718 (35320081)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
35354406;OJVM RELEASE UPDATE: 19.20.0.0.230718 (35354406)
7. oracle升级
[root@YCSMLMESDB01 app]# /u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto apply /u01/app/35319490/35320081 -oh /u01/app/oracle/product/19.3.0/db_1
OPatchauto session is initiated at Tue Oct 17 15:40:47 2023
System initialization log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2023-10-17_03-40-51PM.log.
Session log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2023-10-17_03-41-06PM.log
The id for this session is 2S2E
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1
Executing patch validation checks on home /u01/app/oracle/product/19.3.0/db_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/db_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1
Preparing to bring down database service on home /u01/app/oracle/product/19.3.0/db_1
Successfully prepared home /u01/app/oracle/product/19.3.0/db_1 to bring down database service
Bringing down database service on home /u01/app/oracle/product/19.3.0/db_1
Following database(s) and/or service(s) are stopped and will be restarted later during the session: ycsmmesdb
Database service successfully brought down on home /u01/app/oracle/product/19.3.0/db_1
Performing prepatch operation on home /u01/app/oracle/product/19.3.0/db_1
Prepatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1
Start applying binary patch on home /u01/app/oracle/product/19.3.0/db_1
Failed while applying binary patches on home /u01/app/oracle/product/19.3.0/db_1
Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : ycsmlmesdb01->/u01/app/oracle/product/19.3.0/db_1 Type[rac]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/oracle/product/19.3.0/db_1, host: ycsmlmesdb01.
Command failed: /u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto apply /u01/app/35319490/35320081 -oh /u01/app/oracle/product/19.3.0/db_1 -target_type rac_database -binary -invPtrLoc /u01/app/oracle/product/19.3.0/db_1/oraInst.loc -jre /u01/app/oracle/product/19.3.0/db_1/OPatch/jre -persistresult /u01/app/oracle/product/19.3.0/db_1/opatchautocfg/db/sessioninfo/sessionresult_ycsmlmesdb01_rac_2.ser -analyzedresult /u01/app/oracle/product/19.3.0/db_1/opatchautocfg/db/sessioninfo/sessionresult_analyze_ycsmlmesdb01_rac_2.ser
Command failure output:
==Following patches FAILED in apply:
Patch: /u01/app/35319490/35320081
Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_15-43-17PM_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: Prerequisite check "CheckActiveFilesAndExecutables" failed.
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.
###oracle patch 失败是因为数据库没有关闭
OPatchauto session completed at Tue Oct 17 15:43:49 2023
Time taken to complete the session 2 minutes, 58 seconds
opatchauto failed with error code 42
[root@YCSMLMESDB01 app]# crsctl stop crs
-bash: crsctl: command not found
[root@YCSMLMESDB01 app]# su - grid
[root@YCSMLMESDB01 app]# /u01/app/19.3.0/grid/bin/crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.crsd' on 'ycsmlmesdb01'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.cvu' on 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.chad' on 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.qosmserver' on 'ycsmlmesdb01'
CRS-33673: Attempting to stop resource group 'ora.asmgroup' on server 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.ARCH.dg' on 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.ARCH.dg' on 'ycsmlmesdb01' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'ycsmlmesdb01' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'ycsmlmesdb01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.cvu' on 'ycsmlmesdb01' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'ycsmlmesdb01' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'ycsmlmesdb01' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.ycsmlmesdb01.vip' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.ycsmlmesdb01.vip' on 'ycsmlmesdb01' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'ycsmlmesdb01' succeeded
CRS-2677: Stop of 'ora.asm' on 'ycsmlmesdb01' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.qosmserver' on 'ycsmlmesdb01' succeeded
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'ycsmlmesdb01' succeeded
CRS-2673: Attempting to stop 'ora.asmnet1.asmnetwork' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.asmnet1.asmnetwork' on 'ycsmlmesdb01' succeeded
CRS-33677: Stop of resource group 'ora.asmgroup' on server 'ycsmlmesdb01' succeeded.
CRS-2677: Stop of 'ora.chad' on 'ycsmlmesdb01' succeeded
CRS-2672: Attempting to start 'ora.qosmserver' on 'ycsmlmesdb02'
CRS-2672: Attempting to start 'ora.scan1.vip' on 'ycsmlmesdb02'
CRS-2672: Attempting to start 'ora.cvu' on 'ycsmlmesdb02'
CRS-2672: Attempting to start 'ora.ycsmlmesdb01.vip' on 'ycsmlmesdb02'
CRS-2676: Start of 'ora.cvu' on 'ycsmlmesdb02' succeeded
CRS-2676: Start of 'ora.scan1.vip' on 'ycsmlmesdb02' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'ycsmlmesdb02'
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'ycsmlmesdb02' succeeded
CRS-2676: Start of 'ora.qosmserver' on 'ycsmlmesdb02' succeeded
CRS-5005: IP Address: 10.247.41.81 is already in use in the network
CRS-2674: Start of 'ora.ycsmlmesdb01.vip' on 'ycsmlmesdb02' failed
CRS-2673: Attempting to stop 'ora.ons' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.ons' on 'ycsmlmesdb01' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.net1.network' on 'ycsmlmesdb01' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'ycsmlmesdb01' has completed
CRS-2677: Stop of 'ora.crsd' on 'ycsmlmesdb01' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.crf' on 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.crf' on 'ycsmlmesdb01' succeeded
CRS-2677: Stop of 'ora.storage' on 'ycsmlmesdb01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.mdnsd' on 'ycsmlmesdb01' succeeded
CRS-2677: Stop of 'ora.asm' on 'ycsmlmesdb01' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ycsmlmesdb01' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.evmd' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.ctssd' on 'ycsmlmesdb01' succeeded
CRS-2677: Stop of 'ora.evmd' on 'ycsmlmesdb01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.cssd' on 'ycsmlmesdb01' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'ycsmlmesdb01'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'ycsmlmesdb01'
CRS-2677: Stop of 'ora.gpnpd' on 'ycsmlmesdb01' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'ycsmlmesdb01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ycsmlmesdb01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@YCSMLMESDB01 app]#
[root@YCSMLMESDB01 app]# ps -ef|grep smon
root 2362 19915 0 15:47 pts/0 00:00:00 grep --color=auto smon
[root@YCSMLMESDB01 app]# ps -ef|grep ora_ #确认数据库已经关闭
root 2698 19915 0 15:47 pts/0 00:00:00 grep --color=auto ora_
[root@YCSMLMESDB01 app]#
[root@YCSMLMESDB01 app]# /u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto apply /u01/app/35319490/35320081 -oh /u01/app/oracle/product/19.3.0/db_1
OPatchauto session is initiated at Tue Oct 17 15:47:38 2023
System initialization log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/systemconfig2023-10-17_03-47-42PM.log.
Session log file is /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/opatchauto2023-10-17_03-47-45PM.log
The id for this session is LZ3F
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/db_1
Executing patch validation checks on home /u01/app/oracle/product/19.3.0/db_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/db_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/db_1
No sqlpatch prereq operations are required on the local node for this home
No step execution required.........
Preparing to bring down database service on home /u01/app/oracle/product/19.3.0/db_1
No step execution required.........
Performing prepatch operation on home /u01/app/oracle/product/19.3.0/db_1
Prepatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1
Start applying binary patch on home /u01/app/oracle/product/19.3.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/19.3.0/db_1
Performing postpatch operation on home /u01/app/oracle/product/19.3.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/db_1
Preparing home /u01/app/oracle/product/19.3.0/db_1 after database service restarted
No step execution required.........
Trying to apply SQL patch on home /u01/app/oracle/product/19.3.0/db_1
No SQL patch operations are required on local node for this home
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:YCSMLMESDB01
RAC Home:/u01/app/oracle/product/19.3.0/db_1
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u01/app/35319490/35320081
Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2023-10-17_15-48-31PM_1.log
OPatchauto session completed at Tue Oct 17 15:52:19 2023
Time taken to complete the session 4 minutes, 37 seconds
[root@YCSMLMESDB01 app]#
[oracle@YCSMLMESDB01 ~]$ opatch lspatches
35320081;Database Release Update : 19.20.0.0.230718 (35320081)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
OPatch succeeded.
8.升级后相关操作
[root@YCSMLMESDB01 app]# crsctl start crs
-bash: crsctl: command not found
[root@YCSMLMESDB01 app]# /u01/app/19.3.0/grid/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@YCSMLMESDB01 app]# su - grid
Last login: Tue Oct 17 15:57:53 CST 2023
[root@YCSMLMESDB01 app]# /u01/app/19.3.0/grid/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[root@YCSMLMESDB01 app]#
[root@YCSMLMESDB01 app]# ps -ef|grep smon
oracle 3043 1 0 16:05 ? 00:00:00 ora_smon_ycsmmesdb1
root 13878 19915 0 16:07 pts/0 00:00:00 grep --color=auto smon
root 31958 1 1 16:04 ? 00:00:01 /u01/app/19.3.0/grid/bin/osysmond.bin
grid 32501 1 0 16:05 ? 00:00:00 asm_smon_+ASM1
[root@YCSMLMESDB01 app]# su - oracle
Last login: Tue Oct 17 15:57:54 CST 2023
[oracle@YCSMLMESDB01 ~]$
[oracle@YCSMLMESDB01 ~]$
[oracle@YCSMLMESDB01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 17 16:07:52 2023
Version 19.20.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
SQL> alter system set cluster_database=false scope=spfile;
System altered.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
[oracle@YCSMLMESDB01 ~]$ srvctl stop db -d dbname
[oracle@YCSMLMESDB01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 17 16:11:44 2023
Version 19.20.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 2.0267E+10 bytes
Fixed Size 23334064 bytes
Variable Size 2885681152 bytes
Database Buffers 1.7314E+10 bytes
Redo Buffers 43773952 bytes
Database mounted.
Database opened.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MIGRATE YES
3 YCSMMES MOUNTED
SQL>
SQL> alter pluggable database all open;
alter pluggable database all open
*
ERROR at line 1:
ORA-65054: Cannot open a pluggable database in the desired mode.
##upgrade 启动无法open,需要先关闭再正常startup 才可以open
[oracle@YCSMLMESDB01 ~]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 17-OCT-2023 16:14:47
Copyright (c) 1991, 2023, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 17-OCT-2023 16:05:46
Uptime 0 days 0 hr. 9 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/19.3.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/YCSMLMESDB01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.247.41.81)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_ARCH" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_OCR" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "07e0c9ac81e60e65e0635129f70ad8a1" has 1 instance(s).
Instance "ycsmmesdb1", status RESTRICTED, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
Instance "ycsmmesdb1", status RESTRICTED, has 1 handler(s) for this service...
Service "ycsmmes" has 1 instance(s).
Instance "ycsmmesdb1", status RESTRICTED, has 1 handler(s) for this service...
Service "ycsmmesdb" has 1 instance(s).
Instance "ycsmmesdb1", status RESTRICTED, has 1 handler(s) for this service...
Service "ycsmmesdbXDB" has 1 instance(s).
Instance "ycsmmesdb1", status RESTRICTED, has 1 handler(s) for this service...
The command completed successfully
[oracle@YCSMLMESDB01 ~]$ datapatch -verbose
SQL Patching tool version 19.20.0.0.0 Production on Tue Oct 17 16:17:07 2023
Copyright (c) 2012, 2023, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_30441_2023_10_17_16_17_07/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 YCSMMES 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:
No interim patches found
Current state of release update SQL patches:
Binary registry:
19.20.0.0.0 Release_Update 230715022800: Installed
PDB CDB$ROOT:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 17-OCT-23 09.42.27.962869 AM
PDB PDB$SEED:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 17-OCT-23 09.50.09.420959 AM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED
No interim patches need to be rolled back
Patch 35320081 (Database Release Update : 19.20.0.0.230718 (35320081)):
Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.20.0.0.0 Release_Update 230715022800
No interim patches need to be applied
WARNING: Following components are NOT in a valid state.
This could cause patching failure. If it does, consider
running utlrp.sql to bring components to VALID state.
Then, re-run datapatch.
PDB$SEED : SDO [INVALID]
Installing patches...
Patch installation complete. Total patches installed: 2
Validating logfiles...done
Patch 35320081 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35320081/25314491/35320081_apply_YCSMMESD_CDBROOT_2023Oct17_16_17_41.log (no errors)
Patch 35320081 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35320081/25314491/35320081_apply_YCSMMESD_PDBSEED_2023Oct17_16_22_48.log (no errors)
Automatic recompilation incomplete; run utlrp.sql to revalidate.
PDBs: CDB$ROOT PDB$SEED
SQL Patching tool complete on Wed Oct 18 13:36:52 2023
Refer to the SQL*Plus User's Guide and Reference for more information.
[oracle@YCSMLMESDB01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 17 16:27:08 2023
Version 19.20.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-01102: cannot mount database in EXCLUSIVE mode
##修改为非集群模式 另外已经节点已经启动,该节点则无法启动了
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
[oracle@YCSMLMESDB01 ~]$
[oracle@YCSMLMESDB01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 17 16:33:02 2023
Version 19.20.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 YCSMMES MOUNTED
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 YCSMMES MOUNTED
SQL>
SQL> alter pluggable database YCSMMES open;
Warning: PDB altered with errors.
##pdb没有按最初的流程导致pdb 没有更新 pdb受限
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 YCSMMES READ WRITE YES
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
[oracle@YCSMLMESDB01 ~]$
[oracle@YCSMLMESDB01 ~]$ datapatch –verbose
##确定两个节点pdb都open后重新datapatch
SQL Patching tool version 19.20.0.0.0 Production on Tue Oct 17 16:35:30 2023
Copyright (c) 2012, 2023, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_12417_2023_10_17_16_35_30/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:
No interim patches found
Current state of release update SQL patches:
Binary registry:
19.20.0.0.0 Release_Update 230715022800: Installed
PDB CDB$ROOT:
Applied 19.20.0.0.0 Release_Update 230715022800 successfully on 17-OCT-23 04.26.09.993615 PM
PDB PDB$SEED:
Applied 19.20.0.0.0 Release_Update 230715022800 successfully on 17-OCT-23 04.26.15.203676 PM
PDB YCSMMES:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 17-OCT-23 09.50.09.420959 AM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED
No interim patches need to be rolled back
No release update patches need to be installed
No interim patches need to be applied
For the following PDBs: YCSMMES
No interim patches need to be rolled back
Patch 35320081 (Database Release Update : 19.20.0.0.230718 (35320081)):
Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.20.0.0.0 Release_Update 230715022800
No interim patches need to be applied
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...done
Patch 35320081 apply (pdb YCSMMES): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/35320081/25314491/35320081_apply_YCSMMESD_YCSMMES_2023Oct17_16_35_58.log (no errors)
Automatic recompilation incomplete; run utlrp.sql to revalidate.
PDBs: YCSMMES
SQL Patching tool complete on Tue Oct 17 16:43:52 2023
[oracle@YCSMLMESDB01 ~]$
[oracle@YCSMLMESDB01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 17 16:46:22 2023
Version 19.20.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 YCSMMES READ WRITE YES
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
[oracle@YCSMLMESDB01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 17 16:49:12 2023
Version 19.20.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 YCSMMES MOUNTED
SQL>
SQL> alter pluggable database all open;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 YCSMMES READ WRITE NO
SQL>
SQL> alter pluggable database YCSMMES save state;
Pluggable database altered.
SQL>




