暂无图片
暂无图片
7
暂无图片
暂无图片
暂无图片

oracle 19CRAC打补丁到19.20

原创 潇湘秦 2023-10-19
2436

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. 二.命令+输出版本(部分解压之类命令没加入)

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>

最后修改时间:2023-10-20 10:00:39
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论