Pre- Requisites:
Backup the GI Home and DB Home.
Backup OLR file.
Backup OraInventory.
Backup the Database.
Download and install the lastest Opatch utility
+++Query the existing patches+++
As Oracle DB home owner:
========================
[oracle@testdb OPatch]$ opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
OPatch succeeded.
[oracle@testdb OPatch]$
As GI home owner:
=================
[grid@testdb OPatch]$ opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)
OPatch succeeded.
[grid@testdb OPatch]$
+++Check the existing version of GI+++
[grid@testdb ~]$ crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[grid@testdb ~]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [19.0.0.0.0]
[grid@testdb ~]$ crsctl query has releasepatch
Oracle Clusterware release patch level is [724960844] and the complete list of patches [29401763 29517242 29517247 29585399 ] have been applied on the local node. The release patch string is [19.3.0.0.0].
[grid@testdb ~]$ crsctl query has softwarepatch
Oracle Clusterware patch level on node testdb is [724960844].
+++Check the existing version of DB and Patch details+++
SQL> set linesize 300
col VERSION for a10
col ACTION for a20
col NAMESPACE for a15
col COMMENTS for a47
col ACTION_TIME for a30
select ACTION_TIME, ACTION, NAMESPACE,VERSION,COMMENTS from dba_registry_history;
ACTION_TIME ACTION NAMESPACE VERSION COMMENTS
—————————— ——————– ————— ———- ———————————————–
BOOTSTRAP DATAPATCH 19 RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417
17-03-23 8:33:27.624362 PM RU_APPLY SERVER 19.0.0.0.0 Patch applied on 19.3.0.0.0: Release_Update – 1
90410122720
SQL> set linesize 300
col status for a10
col ACTION for a10
col ACTION_TIME for a30
col DESCRIPTION for a30
select PATCH_ID,PATCH_TYPE,ACTION,ACTION_TIME,SOURCE_VERSION,
TARGET_VERSION,STATUS,description from dba_registry_sqlpatch order by ACTION_TIME;
PATCH_ID PATCH_TYPE ACTION ACTION_TIME SOURCE_VERSION TARGET_VERSION STATUS DESCRIPTION
———- ———- ———- —————————— ————— ————— ———- ——————————
29517242 RU APPLY 17-03-23 8:33:41.098816 PM 19.1.0.0.0 19.3.0.0.0 SUCCESS Database Release Update : 19.3
.0.0.190416 (29517242)
+++Check the existing version of DB and Patch details+++
Unzip GI and DB Patches at respective locations.
GI Patch location: /patch/patch_GI_19.18
DB Patch location: /patch/patch_DB_19.18
+++Check the consistency of inventory information for GI home and each database home +++
As Oracle User:
================
[oracle@testdb ~]$ /u01/app/oracle/product/19.0.0/db_1/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/product/19.0.0/db_1/
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0/db_1//oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2023-03-20_19-01-47PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2023-03-20_19-01-47PM.txt
——————————————————————————–
Local Machine Information::
Hostname: testdb
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 19c 19.0.0.0.0
There are 1 products installed in this Oracle Home.
Installed Products (128):
Assistant Common Files 19.0.0.0.0
BLASLAPACK Component 19.0.0.0.0
Buildtools Common Files 19.0.0.0.0
Cluster Verification Utility Common Files 19.0.0.0.0
Cluster Verification Utility DB 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
Enterprise Edition Options 19.0.0.0.0
Expat libraries 2.0.1.0.4
Generic Connectivity Common Files 19.0.0.0.0
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
JAccelerator (COMPANION) 19.0.0.0.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 Analytics 19.0.0.0.0
Oracle Advanced Security 19.0.0.0.0
Oracle Application Express 19.0.0.0.0
Oracle Bali Share 11.1.1.6.0
Oracle Call Interface (OCI) 19.0.0.0.0
Oracle Clusterware RDBMS Files 19.0.0.0.0
Oracle Context Companion 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 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 Gateway for ODBC 19.0.0.0.0
Oracle Database Provider for DRDA 19.0.0.0.0
Oracle Database Utilities 19.0.0.0.0
Oracle Database Vault option 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 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 Label Security 19.0.0.0.0
Oracle LDAP administration 19.0.0.0.0
Oracle Locale Builder 19.0.0.0.0
Oracle Message Gateway Common Files 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 Net Services 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 ODBC Driver 19.0.0.0.0
Oracle ODBC Driverfor Instant Client 19.0.0.0.0
Oracle OLAP 19.0.0.0.0
Oracle OLAP API 19.0.0.0.0
Oracle OLAP RDBMS Files 19.0.0.0.0
Oracle One-Off Patch Installer 12.2.0.1.15
Oracle Partitioning 19.0.0.0.0
Oracle Programmer 19.0.0.0.0
Oracle R Enterprise Server Files 19.0.0.0.0
Oracle RAC Required Support Files-HAS 19.0.0.0.0
Oracle Real Application Testing 19.0.0.0.0
Oracle Recovery Manager 19.0.0.0.0
Oracle Scheduler Agent 19.0.0.0.0
Oracle Security Developer Tools 19.0.0.0.0
Oracle Spatial and Graph 19.0.0.0.0
Oracle SQL Developer 19.0.0.0.0
Oracle Starter Database 19.0.0.0.0
Oracle Text 19.0.0.0.0
Oracle Text ATG Language Support Files 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 XML Development Kit 19.0.0.0.0
Oracle XML Query 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 Common Files 19.0.0.0.0
Precompiler Common Files for Core 19.0.0.0.0
Precompiler Required Support Files 19.0.0.0.0
Precompilers 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 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
SQLJ Runtime 19.0.0.0.0
SSL Required Support Files for InstantClient 19.0.0.0.0
Trace File Analyzer for DB 19.0.0.0.0
XDK Required Support Files 19.0.0.0.0
XML Parser for Java 19.0.0.0.0
XML Parser for Oracle JVM 19.0.0.0.0
There are 128 products installed in this Oracle Home.
Interim patches (2) :
Patch 29585399 : applied on Thu Apr 18 12:51:33 IST 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, 3, 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
Files Touched:
clustdb.sql –> ORACLE_HOME/srvm/admin/clustdb.sql
Patch Location in Inventory:
/u01/app/oracle/product/19.0.0/db_1/inventory/oneoffs/29585399
Patch Location in Storage area:
/u01/app/oracle/product/19.0.0/db_1/.patch_storage/29585399_Apr_9_2019_19_12_47
Patch 29517242 : applied on Thu Apr 18 12:51:17 IST 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:
29515240, 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
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_sdo_29517242.txt –>
ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/
metadata_oracle_sdo_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_dv_29517242.txt –> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/
metadata_oracle_rdbms_dv_29517242.txt
metadata_oracle_odbc_ic_29517242.txt –> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/
metadata_oracle_odbc_ic_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_rdbms_oci_29517242.txt –> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/
metadata_oracle_rdbms_oci_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_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_ctx_29517242.txt –> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/
metadata_oracle_ctx_29517242.txt
metadata_oracle_ovm_29517242.txt –> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/
metadata_oracle_ovm_29517242.txt
metadata_oracle_precomp_common_29517242.txt –> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/
metadata_oracle_precomp_common_29517242.txt
metadata_oracle_precomp_lang_29517242.txt –> ORACLE_HOME/sqlpatch/29517242/22861793/patch_level_files/
metadata_oracle_precomp_lang_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/oracle/product/19.0.0/db_1/inventory/oneoffs/29517242
Patch Location in Storage area:
/u01/app/oracle/product/19.0.0/db_1/.patch_storage/29517242_Apr_17_2019_23_27_10
OPatch succeeded.
As Grid User:
===============
[grid@testdb ~]$ /u01/app/19.0.0/grid/OPatch/opatch lsinventory -detail -oh /u01/app/19.0.0/grid
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_19-03-18PM_1.log
Lsinventory Output file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2023-03-20_19-03-18PM.txt
——————————————————————————–
Local Machine Information::
Hostname: testdb
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 13:06:24 IST 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, 3, 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
Files Touched:
clustdb.sql –> ORACLE_HOME/srvm/admin/clustdb.sql
Patch Location in Inventory:
/u01/app/19.0.0/grid/inventory/oneoffs/29585399
Patch Location in Storage area:
/u01/app/19.0.0/grid/.patch_storage/29585399_Apr_9_2019_19_12_47
Patch 29517247 : applied on Thu Apr 18 13:06:02 IST 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.0.0/grid/inventory/oneoffs/29517247
Patch Location in Storage area:
/u01/app/19.0.0/grid/.patch_storage/29517247_Apr_1_2019_15_08_20
Patch 29517242 : applied on Thu Apr 18 13:05:39 IST 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:
29515240, 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
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.0.0/grid/inventory/oneoffs/29517242
Patch Location in Storage area:
/u01/app/19.0.0/grid/.patch_storage/29517242_Apr_17_2019_23_27_10
Patch 29401763 : applied on Thu Apr 18 13:05:16 IST 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.0.0/grid/inventory/oneoffs/29401763
Patch Location in Storage area:
/u01/app/19.0.0/grid/.patch_storage/29401763_Apr_11_2019_22_26_25
OPatch succeeded.
+++Run OPatch Conflict Check to determine whether any currently installed one-off patches conflict with these RU patches+++
As the Grid home user:
=======================
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/patch_GI_19.18/34762026/34765931
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-13-29PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[grid@testdb ~]$
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/patch_GI_19.18/34762026/34768559
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-14-08PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[grid@testdb ~]$
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/patch_GI_19.18/34762026/34768569
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-14-34PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[grid@testdb ~]$
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/patch_GI_19.18/34762026/34863894
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-15-02PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[grid@testdb ~]$
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/patch_GI_19.18/34762026/33575402
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-15-32PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[grid@testdb ~]$
As the Oracle home user:
========================
[oracle@testdb ~]$
[oracle@testdb ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/patch_DB_19.18/34762026/34765931
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2023-03-20_20-16-00PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[oracle@testdb ~]$
[oracle@testdb ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /patch/patch_DB_19.18/34762026/34768559
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2023-03-20_20-16-42PM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
[oracle@testdb ~]$
+++++++Run OPatch System Space Check++++++
Check if enough free space is available in the GI home and Oracle home filesystem for the patches to be applied.
Create file /patch/patch_GI_19.18/patch_list_gihome.txt with the following patches:
cat /patch/patch_GI_19.18/patch_list_gihome.txt
/patch/patch_GI_19.18/34762026/34765931
/patch/patch_GI_19.18/34762026/34768559
/patch/patch_GI_19.18/34762026/34768569
/patch/patch_GI_19.18/34762026/34863894
/patch/patch_GI_19.18/34762026/33575402
Run the OPatch command to check if enough free space is available in the Grid Infrastructure home:
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /patch/patch_GI_19.18/patch_list_gihome.txt
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-19-42PM_1.log
Invoking prereq “checksystemspace”
Prereq “checkSystemSpace” passed.
OPatch succeeded.
[grid@testdb ~]$
For Oracle home, as Oracle home user:
Create file /patch/patch_DB_19.18/patch_list_dbhome.txt with the following patches:
cat /patch/patch_DB_19.18/patch_list_dbhome.txt
/patch/patch_DB_19.18/34762026/34765931
/patch/patch_DB_19.18/34762026/34768559
Run the OPatch command to check if enough free space is available in the RDBMS Oracle home:
[oracle@testdb ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /patch/patch_DB_19.18/patch_list_dbhome.txt
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2023-03-20_20-20-08PM_1.log
Invoking prereq “checksystemspace”
Prereq “checkSystemSpace” passed.
OPatch succeeded.
[oracle@testdb ~]$
The command output reports pass and fail messages as per the system space availability:
If OPatch reports Prereq “checkSystemSpace” failed., then cleanup the system space as the required amount of space is not available.
If OPatch reports Prereq “checkSystemSpace” passed., then no action is needed. Proceed with patch installation.
+++++Stop the CRS managed resources running from DB homes as oracle user++++
Make sure HAS services, DB and listener should up and running, we don’t have to stop them manually. Patch commands will stop them and start.
su – oracle
[oracle@testdb ~]$ $ORACLE_HOME/bin/srvctl stop home -o /u01/app/oracle/product/19.0.0/db_1 -s /patch/patch_DB_19.18/db_patch_stat.txt
[oracle@testdb ~]$
[oracle@testdb ~]$ cat /patch/patch_DB_19.18/db_patch_stat.txt
lsnr-LISTENER_TESTDB
db-testdb
[oracle@testdb ~]$
+++++++++Run the pre root script as root user++++++++++++
[root@testdb ~]# /u01/app/19.0.0/grid/crs/install/roothas.sh -prepatch
Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/testdb/crsconfig/hapatch_2023-03-20_08-27-54PM.log
2023/03/20 20:28:19 CLSRSC-347: Successfully unlock /u01/app/19.0.0/grid
2023/03/20 20:28:19 CLSRSC-671: Pre-patch steps for patching GI home successfully completed.
[root@testdb ~]#
++++++Patch GI home++++++++++++++
As the GI home owner (Grid user) execute:
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /patch/patch_GI_19.18/34762026/34768559
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-29-36PM_1.log
Verifying environment and performing prerequisite checks…
——————————————————————————–
Start OOP by Prereq process.
Launch OOP…
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-29-49PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 34768559
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/19.0.0/grid’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘34768559’ to OH ‘/u01/app/19.0.0/grid’
ApplySession: Optional component(s) [ oracle.has.db.cvu, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms, 19.0.0.0.0…
Patching component oracle.xag, 19.0.0.0.0…
Patching component oracle.has.db, 19.0.0.0.0…
Patching component oracle.rhp.db, 19.0.0.0.0…
Patching component oracle.has.cvu, 19.0.0.0.0…
Patching component oracle.rhp.common, 19.0.0.0.0…
Patching component oracle.has.common, 19.0.0.0.0…
Patching component oracle.has.crs.cvu, 19.0.0.0.0…
Patching component oracle.has.rsf, 19.0.0.0.0…
Patching component oracle.has.crs, 19.0.0.0.0…
Patching component oracle.rhp.crs, 19.0.0.0.0…
Patching component oracle.has.common.cvu, 19.0.0.0.0…
Patch 34768559 successfully applied.
Sub-set patch [29585399] has become inactive due to the application of a super-set patch [34768559].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-29-49PM_1.log
OPatch succeeded.
[grid@testdb ~]$
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /patch/patch_GI_19.18/34762026/34768569
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-32-26PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 34768569
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/19.0.0/grid’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘34768569’ to OH ‘/u01/app/19.0.0/grid’
Patching component oracle.usm, 19.0.0.0.0…
Patch 34768569 successfully applied.
Sub-set patch [29517247] has become inactive due to the application of a super-set patch [34768569].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-32-26PM_1.log
OPatch succeeded.
[grid@testdb ~]$
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /patch/patch_GI_19.18/34762026/33575402
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-34-28PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 33575402
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/19.0.0/grid’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘33575402’ to OH ‘/u01/app/19.0.0/grid’
Patching component oracle.wlm.dbwlm, 19.0.0.0.0…
Patch 33575402 successfully applied.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-34-28PM_1.log
OPatch succeeded.
[grid@testdb ~]$
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /patch/patch_GI_19.18/34762026/34765931
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-35-41PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 34765931
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/19.0.0/grid’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘34765931’ to OH ‘/u01/app/19.0.0/grid’
ApplySession: Optional component(s) [ oracle.ctx, 19.0.0.0.0 ] , [ oracle.dbdev, 19.0.0.0.0 ] , [ oracle.marvel, 19.0.0.0.0 ] , [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.odbc.ic, 19.0.0.0.0 ] , [ oracle.precomp.common.core, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.oci, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo, 19.0.0.0.0 ] , [ oracle.rdbms.lbac, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.hs_common, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.drdaas, 19.0.0.0.0 ] , [ oracle.oraolap, 19.0.0.0.0 ] , [ oracle.rdbms.dv, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.ctx.atg, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.hsodbc, 19.0.0.0.0 ] , [ oracle.xdk, 19.0.0.0.0 ] , [ oracle.mgw.common, 19.0.0.0.0 ] , [ oracle.xdk.xquery, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.odbc, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.oraolap.api, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.rdbms.scheduler, 19.0.0.0.0 ] , [ oracle.precomp.lang, 19.0.0.0.0 ] , [ oracle.precomp.common, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.slax.rsf, 19.0.0.0.0…
Patching component oracle.ordim.jai, 19.0.0.0.0…
Patching component oracle.bali.jewt, 11.1.1.6.0…
Patching component oracle.bali.ewt, 11.1.1.6.0…
Patching component oracle.help.ohj, 11.1.1.7.0…
Patching component oracle.rdbms.locator, 19.0.0.0.0…
Patching component oracle.perlint.expat, 2.0.1.0.4…
Patching component oracle.rdbms.util, 19.0.0.0.0…
Patching component oracle.rdbms, 19.0.0.0.0…
Patching component oracle.rdbms.rsf, 19.0.0.0.0…
Patching component oracle.assistants.acf, 19.0.0.0.0…
Patching component oracle.assistants.deconfig, 19.0.0.0.0…
Patching component oracle.assistants.server, 19.0.0.0.0…
Patching component oracle.blaslapack, 19.0.0.0.0…
Patching component oracle.buildtools.rsf, 19.0.0.0.0…
Patching component oracle.dbjava.ic, 19.0.0.0.0…
Patching component oracle.dbjava.jdbc, 19.0.0.0.0…
Patching component oracle.dbjava.ucp, 19.0.0.0.0…
Patching component oracle.duma, 19.0.0.0.0…
Patching component oracle.javavm.client, 19.0.0.0.0…
Patching component oracle.ldap.owm, 19.0.0.0.0…
Patching component oracle.ldap.rsf, 19.0.0.0.0…
Patching component oracle.ldap.security.osdt, 19.0.0.0.0…
Patching component oracle.network.rsf, 19.0.0.0.0…
Patching component oracle.ons, 19.0.0.0.0…
Patching component oracle.ons.ic, 19.0.0.0.0…
Patching component oracle.oracore.rsf, 19.0.0.0.0…
Patching component oracle.perlint, 5.28.1.0.0…
Patching component oracle.precomp.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.crs, 19.0.0.0.0…
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0…
Patching component oracle.rdbms.deconfig, 19.0.0.0.0…
Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0…
Patching component oracle.rhp.db, 19.0.0.0.0…
Patching component oracle.sdo.locator.jrf, 19.0.0.0.0…
Patching component oracle.sqlplus, 19.0.0.0.0…
Patching component oracle.sqlplus.ic, 19.0.0.0.0…
Patching component oracle.tfa, 19.0.0.0.0…
Patching component oracle.wwg.plsql, 19.0.0.0.0…
Patching component oracle.ldap.rsf.ic, 19.0.0.0.0…
Patching component oracle.network.listener, 19.0.0.0.0…
Patching component oracle.nlsrtl.rsf, 19.0.0.0.0…
Patching component oracle.network.client, 19.0.0.0.0…
Patching component oracle.sdo.locator, 19.0.0.0.0…
Patching component oracle.xdk.rsf, 19.0.0.0.0…
Patching component oracle.javavm.server, 19.0.0.0.0…
Patching component oracle.ldap.ssl, 19.0.0.0.0…
Patching component oracle.oraolap.dbscripts, 19.0.0.0.0…
Patching component oracle.rdbms.rman, 19.0.0.0.0…
Patching component oracle.rdbms.install.plugins, 19.0.0.0.0…
Patching component oracle.rdbms.install.common, 19.0.0.0.0…
Patching component oracle.xdk.parser.java, 19.0.0.0.0…
Patching component oracle.ovm, 19.0.0.0.0…
Patching component oracle.ctx.rsf, 19.0.0.0.0…
Patching component oracle.ldap.client, 19.0.0.0.0…
Patching component oracle.install.deinstalltool, 19.0.0.0.0…
Patching component oracle.dbtoolslistener, 19.0.0.0.0…
Patching component oracle.jdk, 1.8.0.201.0…
Patch 34765931 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [34765931].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-35-41PM_1.log
OPatch succeeded.
[grid@testdb ~]$
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch apply -oh /u01/app/19.0.0/grid -local /patch/patch_GI_19.18/34762026/34863894
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/19.0.0/grid/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-45-40PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 34863894
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/19.0.0/grid’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘34863894’ to OH ‘/u01/app/19.0.0/grid’
Patching component oracle.tomcat.crs, 19.0.0.0.0…
Patch 34863894 successfully applied.
Sub-set patch [29401763] has become inactive due to the application of a super-set patch [34863894].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2023-03-20_20-45-40PM_1.log
OPatch succeeded.
[grid@testdb ~]$
++++++Patch Oracle home++++++++++++++
As the Oracle DB home owner execute:
[oracle@testdb ~]$ /patch/patch_DB_19.18/34762026/34768559/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/19.0.0/db_1
/patch/patch_DB_19.18/34762026/34768559/custom/scripts/prepatch.sh completed successfully.
[oracle@testdb ~]$
[oracle@testdb ~]$ $ORACLE_HOME/OPatch/opatch apply -oh /u01/app/oracle/product/19.0.0/db_1 -local /patch/patch_DB_19.18/34762026/34768559
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2023-03-20_20-48-24PM_1.log
Verifying environment and performing prerequisite checks…
——————————————————————————–
Start OOP by Prereq process.
Launch OOP…
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2023-03-20_20-48-38PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 34768559
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/oracle/product/19.0.0/db_1’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘34768559’ to OH ‘/u01/app/oracle/product/19.0.0/db_1’
ApplySession: Optional component(s) [ oracle.xag, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ] , [ oracle.has.crs.cvu, 19.0.0.0.0 ] , [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.rhp.crs, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms, 19.0.0.0.0…
Patching component oracle.has.db, 19.0.0.0.0…
Patching component oracle.rhp.db, 19.0.0.0.0…
Patching component oracle.rhp.common, 19.0.0.0.0…
Patching component oracle.has.common, 19.0.0.0.0…
Patching component oracle.has.db.cvu, 19.0.0.0.0…
Patching component oracle.has.rsf, 19.0.0.0.0…
Patching component oracle.has.common.cvu, 19.0.0.0.0…
Patch 34768559 successfully applied.
Sub-set patch [29585399] has become inactive due to the application of a super-set patch [34768559].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2023-03-20_20-48-38PM_1.log
OPatch succeeded.
[oracle@testdb ~]$
[oracle@testdb ~]$ $ORACLE_HOME/OPatch/opatch apply -oh /u01/app/oracle/product/19.0.0/db_1 -local /patch/patch_DB_19.18/34762026/34765931
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2023-03-20_20-51-42PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 34765931
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/oracle/product/19.0.0/db_1’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘34765931’ to OH ‘/u01/app/oracle/product/19.0.0/db_1’
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.slax.rsf, 19.0.0.0.0…
Patching component oracle.ordim.jai, 19.0.0.0.0…
Patching component oracle.bali.jewt, 11.1.1.6.0…
Patching component oracle.bali.ewt, 11.1.1.6.0…
Patching component oracle.help.ohj, 11.1.1.7.0…
Patching component oracle.rdbms.locator, 19.0.0.0.0…
Patching component oracle.perlint.expat, 2.0.1.0.4…
Patching component oracle.rdbms.util, 19.0.0.0.0…
Patching component oracle.rdbms, 19.0.0.0.0…
Patching component oracle.rdbms.rsf, 19.0.0.0.0…
Patching component oracle.assistants.acf, 19.0.0.0.0…
Patching component oracle.assistants.deconfig, 19.0.0.0.0…
Patching component oracle.assistants.server, 19.0.0.0.0…
Patching component oracle.blaslapack, 19.0.0.0.0…
Patching component oracle.buildtools.rsf, 19.0.0.0.0…
Patching component oracle.ctx, 19.0.0.0.0…
Patching component oracle.dbdev, 19.0.0.0.0…
Patching component oracle.dbjava.ic, 19.0.0.0.0…
Patching component oracle.dbjava.jdbc, 19.0.0.0.0…
Patching component oracle.dbjava.ucp, 19.0.0.0.0…
Patching component oracle.duma, 19.0.0.0.0…
Patching component oracle.javavm.client, 19.0.0.0.0…
Patching component oracle.ldap.owm, 19.0.0.0.0…
Patching component oracle.ldap.rsf, 19.0.0.0.0…
Patching component oracle.ldap.security.osdt, 19.0.0.0.0…
Patching component oracle.marvel, 19.0.0.0.0…
Patching component oracle.network.rsf, 19.0.0.0.0…
Patching component oracle.odbc.ic, 19.0.0.0.0…
Patching component oracle.ons, 19.0.0.0.0…
Patching component oracle.ons.ic, 19.0.0.0.0…
Patching component oracle.oracore.rsf, 19.0.0.0.0…
Patching component oracle.perlint, 5.28.1.0.0…
Patching component oracle.precomp.common.core, 19.0.0.0.0…
Patching component oracle.precomp.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.crs, 19.0.0.0.0…
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0…
Patching component oracle.rdbms.deconfig, 19.0.0.0.0…
Patching component oracle.rdbms.oci, 19.0.0.0.0…
Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0…
Patching component oracle.rhp.db, 19.0.0.0.0…
Patching component oracle.sdo, 19.0.0.0.0…
Patching component oracle.sdo.locator.jrf, 19.0.0.0.0…
Patching component oracle.sqlplus, 19.0.0.0.0…
Patching component oracle.sqlplus.ic, 19.0.0.0.0…
Patching component oracle.wwg.plsql, 19.0.0.0.0…
Patching component oracle.ldap.rsf.ic, 19.0.0.0.0…
Patching component oracle.network.listener, 19.0.0.0.0…
Patching component oracle.rdbms.lbac, 19.0.0.0.0…
Patching component oracle.nlsrtl.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.hs_common, 19.0.0.0.0…
Patching component oracle.network.client, 19.0.0.0.0…
Patching component oracle.sdo.locator, 19.0.0.0.0…
Patching component oracle.xdk.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.drdaas, 19.0.0.0.0…
Patching component oracle.oraolap, 19.0.0.0.0…
Patching component oracle.rdbms.dv, 19.0.0.0.0…
Patching component oracle.javavm.server, 19.0.0.0.0…
Patching component oracle.ldap.ssl, 19.0.0.0.0…
Patching component oracle.ctx.atg, 19.0.0.0.0…
Patching component oracle.rdbms.hsodbc, 19.0.0.0.0…
Patching component oracle.xdk, 19.0.0.0.0…
Patching component oracle.mgw.common, 19.0.0.0.0…
Patching component oracle.oraolap.dbscripts, 19.0.0.0.0…
Patching component oracle.xdk.xquery, 19.0.0.0.0…
Patching component oracle.rdbms.rman, 19.0.0.0.0…
Patching component oracle.odbc, 19.0.0.0.0…
Patching component oracle.rdbms.install.plugins, 19.0.0.0.0…
Patching component oracle.oraolap.api, 19.0.0.0.0…
Patching component oracle.rdbms.scheduler, 19.0.0.0.0…
Patching component oracle.rdbms.install.common, 19.0.0.0.0…
Patching component oracle.xdk.parser.java, 19.0.0.0.0…
Patching component oracle.ovm, 19.0.0.0.0…
Patching component oracle.ctx.rsf, 19.0.0.0.0…
Patching component oracle.ldap.client, 19.0.0.0.0…
Patching component oracle.install.deinstalltool, 19.0.0.0.0…
Patching component oracle.dbtoolslistener, 19.0.0.0.0…
Patching component oracle.precomp.lang, 19.0.0.0.0…
Patching component oracle.precomp.common, 19.0.0.0.0…
Patching component oracle.jdk, 1.8.0.201.0…
Patch 34765931 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [34765931].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2023-03-20_20-51-42PM_1.log
OPatch succeeded.
[oracle@testdb ~]$
[oracle@testdb ~]$ /patch/patch_DB_19.18/34762026/34768559/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/19.0.0/db_1
Reading /u01/app/oracle/product/19.0.0/db_1/install/params.ora..
Reading /u01/app/oracle/product/19.0.0/db_1/install/params.ora..
Found uninstantiated /u01/app/oracle/product/19.0.0/db_1/crs/sbs/srvctl.sbs file, copying to /u01/app/oracle/product/19.0.0/db_1/bin/srvctl
Parsing file /u01/app/oracle/product/19.0.0/db_1/bin/srvctl
Parsing file /u01/app/oracle/product/19.0.0/db_1/bin/srvconfig
Parsing file /u01/app/oracle/product/19.0.0/db_1/bin/cluvfy
Parsing file /u01/app/oracle/product/19.0.0/db_1/bin/kfod
Verifying file /u01/app/oracle/product/19.0.0/db_1/bin/srvctl
Verifying file /u01/app/oracle/product/19.0.0/db_1/bin/srvconfig
Verifying file /u01/app/oracle/product/19.0.0/db_1/bin/cluvfy
Verifying file /u01/app/oracle/product/19.0.0/db_1/bin/kfod
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/srvctl
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/srvconfig
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/kfod
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/diskmon.bin
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/lsnodes
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/osdbagrp
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/rawutl
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/srvm/admin/ractrans
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/srvm/admin/getcrshome
Reapplying file permissions on /u01/app/oracle/product/19.0.0/db_1/bin/crsdiag.pl
Postpatch completed successfully
[oracle@testdb ~]$
+++++++++Run the post script as root user+++++++++
[root@testdb ~]# /u01/app/19.0.0/grid/rdbms/install/rootadd_rdbms.sh
[root@testdb ~]# /u01/app/19.0.0/grid/crs/install/roothas.sh -postpatch
Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/testdb/crsconfig/hapatch_2023-03-20_09-06-27PM.log
Redirecting to /bin/systemctl restart rsyslog.service
2023/03/20 21:06:30 CLSRSC-329: Replacing Clusterware entries in file ‘oracle-ohasd.service’
2023/03/20 21:07:58 CLSRSC-672: Post-patch steps for patching GI home successfully completed.
[root@testdb ~]#
[root@testdb ~]#
+++++++Start the CRS managed resources that were earlier running from DB homes+++++++
As the Oracle user execute:
[oracle@testdb ~]$ $ORACLE_HOME/bin/srvctl start home -o /u01/app/oracle/product/19.0.0/db_1 -s /patch/patch_DB_19.18/db_patch_stat.txt
[oracle@testdb ~]$
++++Run the datapatch utility+++++++++
As the oracle user execute:
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
——— ——————–
TESTDB READ WRITE
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.18.0.0.0
[oracle@testdb ~]$
cd $ORACLE_HOME/OPatch
[oracle@testdb OPatch]$ datapatch -verbose
SQL Patching tool version 19.18.0.0.0 Production on Mon Mar 20 21:12:13 2023
Copyright (c) 2012, 2023, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/
sqlpatch/sqlpatch_6988_2023_03_20_21_12_13/sqlpatch_invocation.log
Connecting to database…OK
Gathering database info…done
Bootstrapping registry and package to current versions…done
Determining current state…done
Current state of interim SQL patches:
No interim patches found
Current state of release update SQL patches:
Binary registry:
19.18.0.0.0 Release_Update 230127005551: Installed
SQL registry:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 17-03-23 8:33:41.098816 PM
Adding patches to installation queue and performing prereq checks…done
Installation queue:
No interim patches need to be rolled back
Patch 34765931 (DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)):
Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.18.0.0.0 Release_Update 230127005551
No interim patches need to be applied
Installing patches…
Patch installation complete. Total patches installed: 1
Validating logfiles…done
Patch 34765931 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/34765931/
25098466/34765931_apply_TESTDB_2023Mar20_21_13_24.log (no errors)
SQL Patching tool complete on Mon Mar 20 21:32:38 2023
[oracle@testdb OPatch]$
[oracle@testdb OPatch]$
+++Query the patches+++
As Oracle DB home owner:
========================
[oracle@testdb OPatch]$ opatch lspatches
34765931;DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)
34768559;OCW RELEASE UPDATE 19.18.0.0.0 (34768559)
OPatch succeeded.
[oracle@testdb OPatch]$
As GI home owner:
=================
[grid@testdb OPatch]$ opatch lspatches
34863894;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34863894)
34765931;DATABASE RELEASE UPDATE : 19.18.0.0.230117 (REL-JAN230131) (34765931)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
34768569;ACFS RELEASE UPDATE 19.18.0.0.0 (34768569)
34768559;OCW RELEASE UPDATE 19.18.0.0.0 (34768559)
OPatch succeeded.
[grid@testdb OPatch]$
+++Check the dba registry+++
SQL> set linesize 300
col VERSION for a10
col ACTION for a20
col NAMESPACE for a15
col COMMENTS for a47
col ACTION_TIME for a30
select ACTION_TIME, ACTION, NAMESPACE,VERSION,COMMENTS from dba_registry_history;
ACTION_TIME ACTION NAMESPACE VERSION COMMENTS
—————————— ——————– ————— ———- ———————————————–
BOOTSTRAP DATAPATCH 19 RDBMS_19.18.0.0.0DBRU_LINUX.X64_230111
17-03-23 8:33:27.624362 PM RU_APPLY SERVER 19.0.0.0.0 Patch applied on 19.3.0.0.0: Release_Update – 1
90410122720
20-03-23 9:30:34.835080 PM RU_APPLY SERVER 19.0.0.0.0 Patch applied from 19.3.0.0.0 to 19.18.0.0.0: R
elease_Update – 230127005551
SQL> set linesize 300
col status for a10
col ACTION for a10
col ACTION_TIME for a30
col DESCRIPTION for a30
select PATCH_ID,PATCH_TYPE,ACTION,ACTION_TIME,
SOURCE_VERSION,TARGET_VERSION,STATUS,description from dba_registry_sqlpatch order by ACTION_TIME;
PATCH_ID PATCH_TYPE ACTION ACTION_TIME SOURCE_VERSION TARGET_VERSION STATUS DESCRIPTION
———- ———- ———- —————————— ————— ————— ———- ——————————
29517242 RU APPLY 17-03-23 8:33:41.098816 PM 19.1.0.0.0 19.3.0.0.0 SUCCESS Database Release Update : 19.3
.0.0.190416 (29517242)
34765931 RU APPLY 20-03-23 9:32:38.308461 PM 19.3.0.0.0 19.18.0.0.0 SUCCESS DATABASE RELEASE UPDATE : 19.1
8.0.0.230117 (REL-JAN230131) (
34765931)
SQL>
+++Check the new version of GI+++
[grid@testdb ~]$ crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[grid@testdb ~]$
[grid@testdb ~]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [19.0.0.0.0]
[grid@testdb ~]$
[grid@testdb ~]$ crsctl query has releasepatch
Oracle Clusterware release patch level is [3161362881] and the complete list of patches [33575402 34765931 34768559 34768569 34863894 ] have been applied on the local node. The release patch string is [19.18.0.0.0].
[grid@testdb ~]$
[grid@testdb ~]$ crsctl query has softwarepatch
Oracle Clusterware patch level on node testdb is [3161362881].
[grid@testdb ~]$
+++Verify the Patch applicability for warnings+++
DB Patches:
[oracle@testdb ~]$ $ORACLE_HOME/OPatch/opatch lspatches -id 34768559 -verify
Files check OK: Files from Patch ID 34768559 are present in Oracle Home.
Inventory check OK: Patch ID 34768559 is registered in Oracle Home “/u01/app/oracle/product/19.0.0/db_1” inventory.
OPatch succeeded.
[oracle@testdb ~]$
[oracle@testdb ~]$ $ORACLE_HOME/OPatch/opatch lspatches -id 34765931 -verify
Files check OK: Files from Patch ID 34765931 are present in Oracle Home.
Inventory check OK: Patch ID 34765931 is registered in Oracle Home “/u01/app/oracle/product/19.0.0/db_1” inventory.
OPatch succeeded.
[oracle@testdb ~]$
GI Patches:
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch lspatches -id 34765931 -verify
Files check OK: Files from Patch ID 34765931 are present in Oracle Home.
Inventory check OK: Patch ID 34765931 is registered in Oracle Home “/u01/app/19.0.0/grid” inventory.
OPatch succeeded.
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch lspatches -id 34768559 -verify
Files check OK: Files from Patch ID 34768559 are present in Oracle Home.
Inventory check OK: Patch ID 34768559 is registered in Oracle Home “/u01/app/19.0.0/grid” inventory.
OPatch succeeded.
[grid@testdb ~]$
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch lspatches -id 34768569 -verify
Files check OK: Files from Patch ID 34768569 are present in Oracle Home.
Inventory check OK: Patch ID 34768569 is registered in Oracle Home “/u01/app/19.0.0/grid” inventory.
OPatch succeeded.
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch lspatches -id 34863894 -verify
Files check OK: Files from Patch ID 34863894 are present in Oracle Home.
Inventory check OK: Patch ID 34863894 is registered in Oracle Home “/u01/app/19.0.0/grid” inventory.
OPatch succeeded.
[grid@testdb ~]$ $ORACLE_HOME/OPatch/opatch lspatches -id 33575402 -verify
Files check OK: Files from Patch ID 33575402 are present in Oracle Home.
Inventory check OK: Patch ID 33575402 is registered in Oracle Home “/u01/app/19.0.0/grid” inventory.
OPatch succeeded.
[grid@testdb ~]$
+++Check the invalid objects and recomple, if any+++
cd $ORACLE_HOME/rdbms/admin
@utlrp.sql
SQL> @utlrp.sql
Session altered.
TIMESTAMP
——————————————————————————–
COMP_TIMESTAMP UTLRP_BGN 2023-03-20 21:41:46
DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC> objects in the database. Recompilation time is proportional to the
DOC> number of invalid objects in the database, so this command may take
DOC> a long time to execute on a database with a large number of invalid
DOC> objects.
DOC>
DOC> Use the following queries to track recompilation progress:
DOC>
DOC> 1. Query returning the number of invalid objects remaining. This
DOC> number should decrease with time.
DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC> 2. Query returning the number of objects compiled so far. This number
DOC> should increase with time.
DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC> This script automatically chooses serial or parallel recompilation
DOC> based on the number of CPUs available (parameter cpu_count) multiplied
DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC> On RAC, this number is added across all RAC nodes.
DOC>
DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC> recompilation. Jobs are created without instance affinity so that they
DOC> can migrate across RAC nodes. Use the following queries to verify
DOC> whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC> 1. Query showing jobs created by UTL_RECOMP
DOC> SELECT job_name FROM dba_scheduler_jobs
DOC> WHERE job_name like ‘UTL_RECOMP_SLAVE_%’;
DOC>
DOC> 2. Query showing UTL_RECOMP jobs that are running
DOC> SELECT job_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like ‘UTL_RECOMP_SLAVE_%’;
DOC>#
PL/SQL procedure successfully completed.
TIMESTAMP
——————————————————————————–
COMP_TIMESTAMP UTLRP_END 2023-03-20 21:41:48
DOC> The following query reports the number of invalid objects.
DOC>
DOC> If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#
OBJECTS WITH ERRORS
——————-
0
DOC> The following query reports the number of exceptions caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC> Note: Typical compilation errors (due to coding errors) are not
DOC> logged into this table: they go into DBA_ERRORS instead.
DOC>#
ERRORS DURING RECOMPILATION
—————————
0
Function created.
PL/SQL procedure successfully completed.
Function dropped.
PL/SQL procedure successfully completed.
SQL>
Reference:
==========
Supplemental Readme – Grid Infrastructure Release Update 12.2.0.1.x / 18c /19c (Doc ID 2246888.1)
Disclaimer:
==========
Please note the above information is only for educational purpose and practised in personal test database only. Always test in test database before implementing in production database. The pre-requisites and ways of implementing may vary from one environment to another. Hence, not providing guarantee that it will work in your environment.