Steps to apply latest (PSU 2020 January) Windows bundle patch in standalone ASM (GRID) database.
1) Set ORACLE_HOME as GRID home
C:\Users\Administrator>set ORACLE_HOME=C:\APP\oracle\product\12.2\grid
2) Stop OCR related resources, Oracle High Availability Services (OHASD), all Oracle Services and unlock the Grid Home.
If this is an Oracle Restart Home, execute- [ What is Oracle Restart Home? Oracle Restart Home is standalone ASM database since 11.2 R2]
C:\Users\Administrator>%ORACLE_HOME%\perl\bin\perl -I%ORACLE_HOME%\perl\lib -I%ORACLE_HOME%\crs\install %ORACLE_HOME%\crs\install\roothas.pl -prepatch
Note: roothas.pl -prepatch will down all OCR resources, HAS Daemon, Oracle services, instances ......
Using configuration parameter file: C:\APP\oracle\product\12.2\grid\crs\install\crsconfig_params
The log of current session can be found at:
C:\APP\oracle\grid\crsdata\win-4cvifa2uooh\crsconfig\hapatch_2020-03-28_01-00-57AM.log
2020/03/28 01:03:52 CLSRSC-347: Successfully unlock C:\APP\oracle\product\12.2\grid
3) C:\Users\Administrator>crsctl stat res -t -init
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Status failed, or completed with errors.
4) C:\Users\Administrator>net start | findstr /i ora
5) C:\Users\Administrator>net stop OraFenceService
The OraFenceService service was stopped successfully.
6) C:\Users\Administrator>cd C:\APP\oracle\product\12.2\grid\OPatch
C:\APP\oracle\product\12.2\grid\OPatch>opatch apply -local C:\soft\p30446296_122010_MSWIN-x86-64\30446296
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : C:\APP\oracle\product\12.2\grid
Central Inventory : C:\Program Files\Oracle\Inventory
from :
OPatch version : 12.2.0.1.19
OUI version : 12.2.0.1.4
Log file location : C:\APP\oracle\product\12.2\grid\cfgtoollogs\opatch\opatch2020-03-28_01-14-30AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 30446296
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 = 'C:\APP\oracle\product\12.2\grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '30446296' to OH 'C:\APP\oracle\product\12.2\grid'
ApplySession: Optional component(s) [ oracle.ntrdbms.admin, 12.2.0.1.0 ] , [ oracle.ntrdbms.oraconfig, 12.2.0.1.0 ] , [ oracle.precomp.common, 12.2.0.1.0 ] , [ oracle.xdk, 12.2.0.1.0 ] , [ oracle.precomp.lang, 12.2.0.1.0 ] , [ oracle.clrintg.ode_net_2, 12.2.0.1.0 ] , [ oracle.rdbms.ic, 12.2.0.1.0 ] , [ oracle.sdo, 12.2.0.1.0 ] , [ oracle.rdbms.dv, 12.2.0.1.0 ] , [ oracle.oraolap, 12.2.0.1.0 ] , [ oracle.ntoledb, 12.2.0.1.0 ] , [ oracle.rdbms.lbac, 12.2.0.1.0 ] , [ oracle.aspnet_2, 12.2.0.1.0 ] , [ oracle.ctx, 12.2.0.1.0 ] , [ oracle.rdbms.tg4db2, 12.2.0.1.0 ] , [ oracle.ntoramts, 12.2.0.1.0 ] , [ oracle.rdbms.olap, 12.2.0.1.0 ] , [ oracle.rdbms.scheduler, 12.2.0.1.0 ] , [ oracle.ntoledb.odp_net_2, 12.2.0.1.0 ] , [ oracle.odbc.ic, 12.2.0.1.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.precomp.rsf, 12.2.0.1.0...
Patching component oracle.tfa, 12.2.0.1.0...
Patching component oracle.assistants.server, 12.2.0.1.0...
Patching component oracle.xdk.parser.java, 12.2.0.1.0...
Patching component oracle.ldap.rsf.ic, 12.2.0.1.0...
Patching component oracle.network.client, 12.2.0.1.0...
Patching component oracle.rdbms.install.plugins, 12.2.0.1.0...
Patching component oracle.network.aso, 12.2.0.1.0...
Patching component oracle.has.common.cvu, 12.2.0.1.0...
Patching component oracle.usm, 12.2.0.1.0...
Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...
Patching component oracle.has.cfs, 12.2.0.1.0...
Patching component oracle.has.crs, 12.2.0.1.0...
Patching component oracle.has.common, 12.2.0.1.0...
Patching component oracle.oracore.rsf, 12.2.0.1.0...
Patching component oracle.sdo.locator, 12.2.0.1.0...
Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...
Patching component oracle.assistants.deconfig, 12.2.0.1.0...
Patching component oracle.xdk.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.rsf, 12.2.0.1.0...
Patching component oracle.has.deconfig, 12.2.0.1.0...
Patching component oracle.wlm.dbwlm, 12.2.0.1.0...
Patching component oracle.has.cvu, 12.2.0.1.0...
Patching component oracle.has.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.util, 12.2.0.1.0...
Patching component oracle.tomcat.crs, 12.2.0.1.0...
Patching component oracle.rdbms.deconfig, 12.2.0.1.0...
Patching component oracle.sdo.locator.jrf, 12.2.0.1.0...
Patching component oracle.has.db, 12.2.0.1.0...
Patching component oracle.sqlplus.ic, 12.2.0.1.0...
Patching component oracle.ldap.client, 12.2.0.1.0...
Patching component oracle.rdbms.rman, 12.2.0.1.0...
Patching component oracle.network.rsf, 12.2.0.1.0...
Patching component oracle.assistants.acf, 12.2.0.1.0...
Patching component oracle.usm.deconfig, 12.2.0.1.0...
Patching component oracle.rdbms, 12.2.0.1.0...
Patching component oracle.ldap.rsf, 12.2.0.1.0...
Patch 30446296 successfully applied.
Log file location: C:\APP\oracle\product\12.2\grid\cfgtoollogs\opatch\opatch2020-03-28_01-14-30AM_1.log
OPatch succeeded.
7) C:\APP\oracle\product\12.2\grid\OPatch>crssetup.exe deinstallfence
<1:35:08> Started
<1:35:08> arguements 2
<1:35:08> crssetup.exe
<1:35:08> deinstallfence
<1:35:08> returning 0x0
8) C:\APP\oracle\product\12.2\grid\OPatch>crssetup.exe installfence
<1:35:46> Started
<1:35:46> arguements 2
<1:35:46> crssetup.exe
<1:35:46> installfence
<1:35:49> returning 0x0
9) C:\APP\oracle\product\12.2\grid\OPatch>net start OraFenceService
The OraFenceService service was started successfully.
10) C:\APP\oracle\product\12.2\grid\OPatch>%ORACLE_HOME%\perl\bin\perl -I%ORACLE_HOME%\perl\lib -I%ORACLE_HOME%\crs\install %ORACLE_HOME%\crs\install\roothas.pl -postpatch
Using configuration parameter file: C:\APP\oracle\product\12.2\grid\crs\install\crsconfig_params
The log of current session can be found at:
C:\APP\oracle\grid\crsdata\win-4cvifa2uooh\crsconfig\hapatch_2020-03-28_01-36-46AM.log
11) C:\APP\oracle\product\12.2\grid\OPatch>set ORACLE_HOME=C:\APP\oracle\base\product\12.2.0\dbhome_1
12) C:\APP\oracle\product\12.2\grid\OPatch>%ORACLE_HOME%\bin\srvctl stop database -d ORCL
PRCC-1016 : orcl was already stopped
13) C:\APP\oracle\product\12.2\grid\OPatch>net stop OracleServiceORCL
The OracleServiceORCL service is stopping..........................
The OracleServiceORCL service was stopped successfully.
14) C:\APP\oracle\product\12.2\grid\OPatch>opatch apply -local C:\soft\p30446296_122010_MSWIN-x86-64\30446296
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : C:\APP\oracle\base\product\12.2.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
from :
OPatch version : 12.2.0.1.19
OUI version : 12.2.0.1.4
Log file location : C:\APP\oracle\base\product\12.2.0\dbhome_1\cfgtoollogs\opatch\opatch2020-03-28_01-46-35AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 30446296
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 = 'C:\APP\oracle\base\product\12.2.0\dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '30446296' to OH 'C:\APP\oracle\base\product\12.2.0\dbhome_1'
ApplySession: Optional component(s) [ oracle.usm, 12.2.0.1.0 ] , [ oracle.rdbms.ic, 12.2.0.1.0 ] , [ oracle.has.cfs, 12.2.0.1.0 ] , [ oracle.has.crs, 12.2.0.1.0 ] , [ oracle.wlm.dbwlm, 12.2.0.1.0 ] , [ oracle.has.cvu, 12.2.0.1.0 ] , [ oracle.tomcat.crs, 12.2.0.1.0 ] , [ oracle.rdbms.tg4db2, 12.2.0.1.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.precomp.rsf, 12.2.0.1.0...
Patching component oracle.tfa, 12.2.0.1.0...
Patching component oracle.assistants.server, 12.2.0.1.0...
Patching component oracle.ntrdbms.admin, 12.2.0.1.0...
Patching component oracle.xdk.parser.java, 12.2.0.1.0...
Patching component oracle.ldap.rsf.ic, 12.2.0.1.0...
Patching component oracle.ntrdbms.oraconfig, 12.2.0.1.0...
Patching component oracle.network.client, 12.2.0.1.0...
Patching component oracle.precomp.common, 12.2.0.1.0...
Patching component oracle.rdbms.install.plugins, 12.2.0.1.0...
Patching component oracle.xdk, 12.2.0.1.0...
Patching component oracle.network.aso, 12.2.0.1.0...
Patching component oracle.precomp.lang, 12.2.0.1.0...
Patching component oracle.has.common.cvu, 12.2.0.1.0...
Patching component oracle.clrintg.ode_net_2, 12.2.0.1.0...
Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...
Patching component oracle.has.common, 12.2.0.1.0...
Patching component oracle.sdo, 12.2.0.1.0...
Patching component oracle.oracore.rsf, 12.2.0.1.0...
Patching component oracle.sdo.locator, 12.2.0.1.0...
Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...
Patching component oracle.assistants.deconfig, 12.2.0.1.0...
Patching component oracle.rdbms.dv, 12.2.0.1.0...
Patching component oracle.oraolap, 12.2.0.1.0...
Patching component oracle.xdk.rsf, 12.2.0.1.0...
Patching component oracle.ntoledb, 12.2.0.1.0...
Patching component oracle.rdbms.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.lbac, 12.2.0.1.0...
Patching component oracle.has.deconfig, 12.2.0.1.0...
Patching component oracle.has.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.util, 12.2.0.1.0...
Patching component oracle.rdbms.deconfig, 12.2.0.1.0...
Patching component oracle.sdo.locator.jrf, 12.2.0.1.0...
Patching component oracle.has.db, 12.2.0.1.0...
Patching component oracle.aspnet_2, 12.2.0.1.0...
Patching component oracle.sqlplus.ic, 12.2.0.1.0...
Patching component oracle.ctx, 12.2.0.1.0...
Patching component oracle.ldap.client, 12.2.0.1.0...
Patching component oracle.rdbms.rman, 12.2.0.1.0...
Patching component oracle.ntoramts, 12.2.0.1.0...
Patching component oracle.network.rsf, 12.2.0.1.0...
Patching component oracle.assistants.acf, 12.2.0.1.0...
Patching component oracle.usm.deconfig, 12.2.0.1.0...
Patching component oracle.rdbms.olap, 12.2.0.1.0...
Patching component oracle.rdbms.scheduler, 12.2.0.1.0...
Patching component oracle.ntoledb.odp_net_2, 12.2.0.1.0...
Patching component oracle.odbc.ic, 12.2.0.1.0...
Patching component oracle.rdbms, 12.2.0.1.0...
Patching component oracle.ldap.rsf, 12.2.0.1.0...
Patch 30446296 successfully applied.
Log file location: C:\APP\oracle\base\product\12.2.0\dbhome_1\cfgtoollogs\opatch\opatch2020-03-28_01-46-35AM_1.log
OPatch succeeded.
15)C:\APP\oracle\product\12.2\grid\OPatch>%ORACLE_HOME%\bin\srvctl start database -d ORCL
16) C:\APP\oracle\product\12.2\grid\OPatch>datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Sat Mar 28 01:58:45 2020
Copyright (c) 2012, 2020, Oracle. All rights reserved.
Log file for this invocation: C:\APP\oracle\base\cfgtoollogs\sqlpatch\sqlpatch_1300_2020_03_28_01_58_47\sqlpatch_invocation.log
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Bundle series PSU:
ID 200114 in the binary registry and not installed in the SQL registry
Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
30446296 (WINDOWS DB BUNDLE PATCH 12.2.0.1.200114(64bit):30446296)
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...
Patch 30446296 apply: SUCCESS
logfile: C:\APP\oracle\base\cfgtoollogs\sqlpatch\30446296\23327209/30446296_apply_ORCL_2020Mar28_02_12_17.log (no errors)
SQL Patching tool complete on Sat Mar 28 02:17:27 2020
16) C:\APP\oracle\product\12.2\grid\OPatch>opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : C:\APP\oracle\base\product\12.2.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
from :
OPatch version : 12.2.0.1.19
OUI version : 12.2.0.1.4
Log file location : C:\APP\oracle\base\product\12.2.0\dbhome_1\cfgtoollogs\opatch\opatch2020-03-28_02-57-13AM_1.log
Lsinventory Output file location : C:\APP\oracle\base\product\12.2.0\dbhome_1\cfgtoollogs\opatch\lsinv\lsinventory2020-03-28_02-57-13AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: WIN-4CVIFA2UOOH
ARU platform id: 233
ARU platform description:: Microsoft Windows (64-bit AMD)
Installed Top-level Products (1):
Oracle Database 12c 12.2.0.1.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 30446296 : applied on Sat Mar 28 01:53:00 PDT 2020
Unique Patch ID: 23327209
Patch description: "WINDOWS DB BUNDLE PATCH 12.2.0.1.200114(64bit):30446296"
Created on 21 Jan 2020, 00:01:01 hrs PST8PDT
Bugs fixed:
28767240, 25752755, 27828794, 27314206, 23065002, 25313154, 28274557
26051656, 25809524, 26361057, 23169712, 25971286, 25360661, 25797305
25051465, 28165439, 28757685, 25579458, 25299807, 29831371, 25356118
26968670, 23599216, 28821847, 24661214, 27119820, 25263960, 24567222
25216003, 25810704, 29375984, 28483184, 28632559, 29850849, 26243617
27511443, 23533647, 27131551, 24967993, 18774543, 27087426, 29846645
28494942, 24383086, 26436168, 25604406, 26554987, 26545688, 25063971
24363144, 26765212, 29379299, 26088770, 27061736, 25973152, 25662088
28836716, 24912588, 28023399, 26979409, 27951817, 25448462, 28522441
25026470, 25822410, 27288638, 27339115, 25411036, 26610406, 26019148
28960211, 25120668, 20532077, 25914276, 25382812, 25958554, 28831971
24820676, 28867992, 29380201, 25970731, 28209985, 26452606, 27849056
25553616, 27623159, 24796183, 27873412, 28397317, 26492866, 30088912
26201113, 25795865, 24663993, 26223039, 25303756, 21479706, 25464098
24425056, 25646592, 29667994, 24445680, 26309047, 29353821, 25093872
27712736, 26659182, 23278750, 26546632, 29218185, 25206864, 27758544
28200829, 28565771, 25893446, 22970869, 24435982, 25639019, 27991463
29510497, 26584641, 29024054, 27567477, 27543657, 24289874, 26745002
26556014, 24759556, 26593581, 24714096, 27232983, 27465480, 28647065
28584193, 27995248, 25942868, 26907236, 29061016, 29314539, 28357401
25723158, 25730614, 23481673, 25535668, 25694206, 24845157, 26204212
25463844, 23026585, 28263591, 27153755, 27348081, 27314390, 22950945
26126424, 28692275, 29383695, 24801915, 25943805, 24608727, 27259307
27333106, 24376875, 27284499, 29951620, 28199085, 26406731, 25184453
28201419, 25795447, 29228869, 27834569, 25120284, 25685286, 28188330
27959594, 29126913, 24960044, 27587905, 29944660, 27729678, 27126122
26670273, 25810476, 28242712, 25240188, 23746128, 26733698, 24486237
22564336, 26476244, 25100063, 25996923, 25950442, 25570929, 26911000
25477657, 26242677, 24844841, 28708023, 28612674, 29852422, 26629381
27691939, 26237338, 27532009, 28050201, 25644425, 25557886, 26775602
27490150, 26494006, 26824833, 23853297, 22594071, 24328857, 25489367
24831514, 28991884, 28128264, 24764085, 25945130, 27447782, 26399626
29746229, 25964954, 27972466, 28171079, 25792962, 24674955, 26477705
23645516, 26970175, 25251648, 25451531, 25742471, 27106915, 21095391
27092508, 26474627, 29511611, 24403922, 27864047, 27135647, 25045228
23600861, 27101105, 24570214, 22367053, 27486805, 26123175, 26185431
27350267, 25653109, 25492219, 27985767, 30046297, 27861226, 23297046
25871639, 24818566, 26376373, 30355981, 27162390, 25175723, 27079651
25894005, 25036006, 26371725, 25788879, 27321179, 26256131, 23709062
26436993, 27154002, 25800464, 25029423, 27877830, 28023482, 30453442
21186167, 24611527, 28369092, 27440427, 28642469, 24334708, 22591010
26439748, 27466597, 26751171, 26672262, 24839101, 25164293, 26198926
27399499, 24330708, 26423085, 27935493, 24911709, 23308065, 26162499
28285234, 22729345, 27525909, 27945870, 24578464, 28608211, 26615680
25505841, 28392168, 27579910, 29027694, 26985002, 27207110, 27766085
22645009, 28226179, 25257085, 26269790, 27835925, 28530171, 28468493
27396672, 29278684, 26817995, 27739957, 29847709, 26391418, 25716769
29213320, 26513067, 21216226, 25408895, 27133637, 25890056, 25995938
30252156, 24471079, 25599425, 26238195, 25654936, 24357348, 20866970
24330428, 26042633, 27090765, 25498994, 25089164, 25459958, 25123585
29224605, 29885887, 26115103, 29530515, 28710827, 30223712, 27998003
26759355, 26087754, 27304410, 25269635, 26680105, 24713381, 25776294
25178101, 25395696, 27658186, 24827654, 21547051, 22864303, 26038086
27313580, 28585411, 24737954, 25561296, 25518447, 25953857, 25954054
26907327, 29237575, 26536320, 28949888, 26820076, 26145560, 27248917
30281591, 26832884, 25762221, 25941836, 26755171, 24687075, 30176330
26166315, 20087519, 26981902, 25415713, 27489107, 25616268, 26410240
27432826, 27942503, 27346709, 27526362, 25427662, 26478970, 27846298
25557335, 27970426, 24294174, 27710072, 27266245, 26494536, 25832725
28820669, 25838361, 26200693, 29230252, 29394003, 20118035, 24908321
23326243, 29170232, 27439835, 27769361, 27320576, 28830691, 27468303
25537470, 27593587, 23840305, 25223839, 25823754, 24717183, 27274456
27533780, 25192729, 26095327, 27740424, 24471473, 28666719, 24744383
27396813, 28587723, 22322021, 24642495, 24908629, 25888073, 26527054
26396215, 28026866, 27424405, 25099497, 27122162, 29822515, 25858672
29557261, 28256164, 24445255, 25643889, 25870579, 26944190, 24786669
25037011, 28004853, 26307166, 26739322, 21159907, 25998093, 20120236
25558986, 27358232, 27882764, 23698980, 24674652, 22734786, 26911212
27607563, 19614243, 26617804, 25616417, 29676089, 24835458, 24963543
25536819, 27709046, 28512336, 27144928, 26934551, 21973494, 26362155
27533819, 29347943, 25655495, 26552807, 28891984, 29483771, 25997716
25241625, 25915863, 25416731, 28454215, 30218044, 25095982, 29418447
27151826, 22265788, 27256000, 25137752, 25774482, 27565906, 23733981
26421667, 25606091, 26088426, 28749289, 25810263, 25575628, 21679331
29250230, 29484290, 28742555, 25100966, 27275533, 25433696, 25865785
26546754, 26664476, 29375355, 24841671, 26523432, 28271119, 25564644
25757748, 23126545, 29784139, 26569225, 25722055, 29200700, 26391502
26664295, 28236305, 23179662, 25667162, 27825241, 26034119, 27329612
24470606, 26727397, 24657753, 26582460, 25092777, 28390461, 26909504
28477613, 27222938, 24929210, 27576354, 27364854, 25736599, 27000158
26299727, 22107360, 26650540, 29884958, 26271001, 26257953, 24686368
27338912, 24387054, 28104361, 25785441, 27824540, 25804573, 23749454
26169345, 27516078, 25130312, 23104033, 24361558, 27971015, 26641610
25476125, 26967713, 26558437, 25029022, 27203055, 25186079, 26111842
26366517, 26970717, 25710420, 25597525, 28600233, 25259611, 21837606
18521691, 25209912, 25789579, 24796092, 26237431, 24938784, 24802934
25296876, 24680959, 27999638, 26635897, 27983174, 24651269, 28454242
26108337, 27124624, 20511294, 27200959, 20736227, 25195901, 25267006
25576767, 25425451, 24566167, 28442896, 27688099, 28627255, 25435038
25700654, 26482376, 25057811, 26272761, 26420561, 27302730, 28927452
26124078, 25948946, 28101630, 27148384, 25492821, 25772669, 26567325
26493289, 25715179, 27748954, 22070853, 20549013, 25171084, 26263721
26399839, 25852885, 28901519, 28863424, 26244115, 16187463, 26755613
28535272, 27028251, 27815019, 26136597, 28125947, 26248143, 25393714
27038986, 27555481, 25225795, 23715460, 23761358, 26080410, 21147908
27162405, 27006120, 25687460, 25224242, 28951026, 27426363, 29177886
25032818, 25320555, 29782211, 26261327, 28617631, 26198757, 16438495
28547068, 25813931, 25573623, 24509056, 27034890, 28774416, 30150416
28810696, 27850736, 24670214, 24345420, 25818707, 27250547, 28384353
27693713, 21985256, 27359178, 26121788, 29237698, 26714486, 27367194
25609727, 26090893, 25305405, 26729611, 23760401, 25980770, 25478885
22746853, 14690846, 25307368, 26422277, 25728787, 25826740, 28330971
26754328, 26833932, 27855490, 27248708, 24583356, 30408515, 24902553
25699321, 24924667, 26626879, 22504793, 25124363, 25895224, 24923338
29483672, 27161071, 25802510, 27758653, 27097854, 26442308, 26373967
28642899, 28636676, 25269133, 27445727, 29173817, 27995215, 28022101
27093423, 28223871, 25131739, 26240920, 28810550, 24515918, 25646373
27013146, 27902561, 25202355, 23125560, 23151677, 23301767, 26324206
25066549, 28333072, 20436508, 29464779, 26353617, 28255672, 25250109
25631933, 20003668, 25362958, 29726695, 26712331, 26615291, 23602213
25856821, 26768025, 26709107, 27242657, 25248384, 28508557, 22826067
28161214, 26136205, 27039712, 27163928, 24385983, 8975044, 27930851
24515127, 25893570, 27536738, 25759916, 25489607, 25872127, 30076951
28819640, 27997875, 25736747, 25882264, 25760608, 14221306, 24425998
21882528, 25303284, 28889730, 23127945, 29524859, 24341675, 25771235
27504770, 25078611, 24699619, 26327418, 25492379, 25388896, 25741955
24373528, 22913923, 24835919, 25760195, 25201454, 26943004, 26822082
28691965, 25530080, 29962927, 24760407, 26439462, 27613530, 25749273
27162931, 24953946, 27114112, 27622810, 27274536, 28396445, 27308088
27037839, 27396624, 27193315, 27379846, 25768681, 27576342, 23197730
27595973, 26007010, 25633101, 27949947, 26116932, 25191872, 25680221
25184555, 30098251, 25906886, 26575788, 26430323, 26548363, 24600330
25754606, 25397498, 28489150, 24923790, 23588722, 26637273, 28797711
26323308, 21178363, 24421668, 27629756, 25551676, 24485034, 23328639
28043157, 28129791, 27554304, 24595699, 23300142, 25098160, 25448476
26829845, 24593740, 27772815, 26035888, 27378959, 29146157, 27404668
25980605, 25329664, 25865563, 24308349, 19702201, 25947195, 26123636
22364044, 29301463, 26816582, 25410180, 24755559, 25717371, 25977302
24486059, 28122716, 28710469, 27305039, 25753105, 25047363, 27056711
29048792, 28817449, 27875430, 27640450, 21212954, 26822620, 28969877
27222423, 26359091, 28621470, 25058080, 28406406, 23572982, 24766309
25686739, 26827699, 25445168, 29629430, 25580664, 29580395, 25412450
25546608, 26374791, 26871815, 29703195, 28181021, 26966916, 24578718
26121990, 25027852, 27560928, 24400947, 26130486, 22599050, 27833785
25211628, 22007324, 28071549, 28127661, 30591740, 24485174, 25054064
27686197, 27882176, 24372941, 26006625, 23061453, 28258926, 25317989
23491861, 26268756, 29189889, 22310426, 28432129, 19647894, 22645496
29454978, 27119861, 23306590, 25981498, 22898198, 26435073, 28279837
26658759, 26587652, 23548817, 27558861, 25660847, 24437162, 25602488
28728040, 23271203, 26898563, 25698636, 27909478, 26426967, 24761751
26029777, 27386467, 21089435, 30345140, 26479173, 25499276, 26299769
22495673, 20324049, 24468470, 27704237, 25515359, 20976443, 27994325
26397265, 27695063, 26078437, 26909100, 27304906, 26412540, 30075990
21517767, 23567857, 25509979, 21374587, 25050160, 27338946, 27285244
25797092, 28229360, 27044297, 25835365, 27931299, 25099339, 24453200
25300427, 25262869, 28085865, 25663488, 27018734, 25957038, 30236693
29242017, 22144696, 23735292, 29902311, 25256522, 28391210, 30359615
26285933, 20559126, 26521043, 25060506, 29853340, 28965095, 25240590
25803364, 25764672, 29131772, 27181897, 25803545, 24710696, 24693290
29009513, 19649997, 27793533, 24652931, 27208795, 28537715, 26758841
25065563, 27628221, 26979533, 24966788, 26639167, 25348956, 25861398
26433972, 27403244, 26839266, 28507324, 29429264, 26153372, 19327292
26474662, 24942749, 27365680, 25205861, 21418655, 25472112, 26375052
24570598, 19211433, 28863487, 23019710, 28572407, 24940060, 28447958
29307109, 24409977, 27726780, 28079127, 27400416, 25071820, 28250843
27664844, 25086233, 29173618, 21638600, 25515215, 28190796, 25485737
27068526, 27375542, 26724511, 29398488, 27998559, 26415890, 26238935
27258578, 24289289, 23110523, 25569634, 23080557, 27433385, 24374976
28435902, 27934464, 27688692, 27006664, 29549071, 23521523, 29637215
22508689, 26138085, 25100579, 29198092, 27601441, 28578945, 25726952
27032785, 28023081, 26351334, 24460392, 27135993, 25197395, 27433870
26434999, 25921828, 28639299, 28838066, 25129925, 22454940, 28852691
30140462, 27515630, 29343861, 27405645, 27540613, 26110259, 26203132
25540738, 26418088, 25337332, 24590367, 25883438, 28076730, 22347493
26274660, 27195935, 25600342, 26379711, 25730014, 27138685, 25178032
24457597, 28617959, 25904273, 25524193, 26153977, 28378446, 26083489
25437699, 26230199, 26438612, 25789051, 26045732, 25210268, 25871753
12763598, 28965787, 24509984, 25834581, 28040776, 25832935, 29483626
26983726, 26325856, 23087119, 27739006, 23170674, 24451580, 25591394
26187943, 26969321, 25728967, 28302049, 25230870, 27671633, 26890646
24352981, 27426753, 28915251, 27757888, 28000269, 26818064, 30053298
25496699, 25199585, 27493674, 26367012, 22568728, 24907917, 25789277
26499442, 8932139, 24623975, 27185188, 29376346, 28045903, 28073470
25114561, 27199245, 24617969, 25192528, 29536342, 24848746, 22628825
25110233, 26083298, 27142373, 28420457, 24415926, 27262945, 29724063
30485255, 25908728, 27680669, 25479164, 26751106, 15931756, 23722215
28540666, 27735534, 26440169, 29309202, 25028996, 29633753, 26657593
24010030, 30244787, 26844019, 27921251, 26110632, 29632752, 24737064
29799836, 25634317, 24735430, 25072986, 28845277, 24797972, 22363790
28371123, 25890673, 25662028, 24831792, 28340023, 29483723, 27824543
25182817, 29399336, 27288894, 19526548, 26318627, 25743479, 25826162
24673586, 24355111, 25797124, 29254863, 25405100, 27560602, 26855855
27060859, 27833672, 25963024, 29182901, 8480838, 24589081, 22261900
25323773, 30402386, 25933494, 25322117, 26762705, 27886087, 25756945
26584906, 29190663, 26966588, 24591506, 27065861, 28856172, 25575414
28546290, 28644549, 26624184, 23327988, 27756093, 29462569, 24401351
28220398, 29500257, 25825910, 25099758, 25145163, 27397048, 23105538
30294734, 29707896, 22981722, 27002286, 27496806, 30125995, 29339155
28194173, 17027695, 27507494, 24752618, 27276231, 24836489, 29702582
29760546, 25966987, 27432062, 26580633, 26714910, 27036867, 27249531
22104866, 24693010, 25951778, 27663329, 28655841, 24978100, 26844870
28538439, 27142529, 24689376, 28319114, 27477527, 26406387, 24683149
25890782, 24757934, 27033520, 28758722, 24303148, 25150925, 25243753
25904490, 28099662, 26375250, 25244807, 18878420, 22379010, 26758193
25481087, 25832312, 28734355, 26986173, 24674197, 24368004, 27693416
28423598, 28305362, 26025681, 29626154, 18308268, 30190314, 26797591
25472885, 27555886, 25604442, 26474703, 26198627, 26798411, 26327775
24421372, 25493588, 26187578, 23761724, 27423478, 27613080, 29183084
27052607, 26385189, 25299227, 25982666, 25943271, 26433979, 27529661
28734910, 25616359, 29651520, 27967484, 27819881, 25932728, 29158680
25404202, 26633558, 14309181, 26966616, 28761812, 27355984, 26203182
25879685, 25425760, 25482971, 24411578, 29040739, 27169796, 28215510
27897759, 26275740, 24831158, 27012440, 25367588, 27242226, 25335790
26764561, 29914449, 25210690, 25557064, 24443539, 29678163, 27698953
25469612, 24690973, 27761402, 28309406, 30133851, 26837702, 24326444
24923223, 25764020, 22700845, 27691920, 23581777, 26650226, 27675947
26078493, 28072567, 29832062, 28396217, 26639937, 24481112, 29865188
27966472, 29240759, 26740700, 25997810, 26376208, 29400176, 26426526
25729214, 20588486, 26620029, 27360733, 28986231, 27479358, 25313411
25594901, 25455795, 25785331, 17947871, 26555172, 27505229, 25361169
23741944, 25546580, 29511705, 28502343, 24348685, 24968162, 28526389
23109325, 25785676, 27012234, 29032276, 27700466, 29409149, 27349393
30037106, 26006257, 26542135, 28986257, 25417050, 28098160, 27119621
25121089, 25162645, 21935698, 28794230, 26257547, 26817286, 23249829
25203656, 25042823, 28956908, 25612095, 24412150, 30252098, 27768034
25975723, 24609996, 28905143, 26263328, 25476149, 27634991, 23706534
24934298, 30342878, 25874678, 24960809, 26338953, 28320399, 16002385
25098392, 27138325, 25812390, 25990907, 24464953, 22087683, 25410802
26537307, 25385515, 24336249, 27972271, 24624166, 27231051, 25077278
24403950, 25328518, 25369170, 25600421, 27297582, 24923080, 27490139
24696235, 27984314, 27552370, 26163462, 19611459, 25489342, 17533661
29161923, 25685152, 21433452, 25825732, 24797119, 25739065, 28120951
25530814, 21495155, 25591658, 25227381, 26317991, 26526799, 22072543
30189023, 26434436, 21197098, 25230051, 29013832, 24784414, 25553939
25856024, 25832420, 25440818, 27601118, 25442559, 25384462, 24396050
25062592, 26613848, 28402313, 28074713, 25954022, 26242031, 25967544
25491831, 23066146, 27666312, 29007353, 25462714, 24485161, 28281094
25022574, 28282606, 27190262, 23310101, 27632114, 25932524, 28678804
23177923, 29171683, 24555417, 20617383, 26802503, 28849751, 26333037
27110878, 24976007, 27283960, 26444601, 28067846, 27959048, 25429959
24516314, 28434028, 27828859, 28513333, 27839353, 25205954, 29379978
26431982, 24964969, 24926999, 24416451, 23499160, 26243698, 26024732
28290434, 25734963, 28326679, 29997804, 24307571, 25603923, 26204214
27818389, 26399592, 27634676, 25832375, 25524955, 28574555, 26828994
23312077, 25430120, 26513709, 29033896, 25034396, 27937914, 24792678
21493004, 28294563, 22581771, 27459948, 22282748, 25807997, 27404599
27657712, 26744595, 25051628, 27731019, 24554533, 27383281, 27244337
25575369, 29896074, 25397936, 25560487, 26380097, 24811725, 25444961
27393570, 28156196, 25715167, 25409838, 26419112, 27264464, 28589509
28987439, 26281476, 25607726, 21981529, 26798516, 26883456, 24961731
25398306, 27502420, 26169341, 26743240, 25036474, 29962939, 28959493
24346821, 21520266, 27795376, 28692103, 27834551, 24565834, 22654475
25674386, 24563422, 25072880, 27530905, 30006937, 27013207, 25830492
11714349, 25555252, 25709368, 27345231, 24719799, 24677696, 23237091
25360754, 25540583, 23340259, 28164480, 26784509, 25888984, 18701017
26430737, 26399691, 27548131, 29645349, 28173995, 27579159, 26973611
22845846, 26748520, 28390273, 24560906, 27133662, 26654363, 22999793
28893832, 25301463, 25526314, 25323525, 25251382, 26037215, 28758090
25480028, 27525224, 25337640, 29163567, 27226913, 27216046, 29538631
24654629, 24921478, 24668398, 27534289, 27416997, 24957555, 25354530
27125872, 26987969, 28951382, 28066655, 27096108, 25393605, 22530986
25405813, 27252023, 27381498, 25547901, 29791152, 25307145, 26248428
26908788, 25335360, 12816839, 21744603, 27475272, 27544973, 27721111
25927065, 28596549, 26526726, 27688036, 26275023, 25376850, 26680584
26036748, 30150731, 27683893, 30365745, 28174827, 27841399, 26546664
26319152, 24812047, 27801337, 26388538, 29669299, 26498354, 21164557
18594510, 27108474, 28803345, 25335249, 24332831, 26729494, 26405036
24440648, 24844549, 25539063, 25919622, 22503297, 25241448, 26032573
24578797, 28107426, 29719146, 27799032, 24664211, 25179774, 24792446
27165231, 25230945, 23730961, 26096382, 26716568, 25947799, 27953102
25569149, 25951571, 26137367, 27213224, 29616244, 26794786, 27786669
25616645, 24739791, 28481149, 25353173, 25634348, 26939314, 30107816
24556967, 26108080, 26581118, 27073314, 28106306, 19072655, 24385235
27751755, 29311336, 25516250, 25662524, 26633228, 25655966, 27867091
26623652, 23346234, 21143725, 29494011, 27595801, 24932026, 29412269
23342170, 27066451, 25742704, 27044169, 26171113, 27759077, 25691904
29946371, 28501075, 26918946, 25245759, 25183818, 25283790, 25375360
26276901, 25802473, 24371491, 28714988, 24573817, 24827228, 28499119
24966594, 27105900, 25894239, 25722608, 25790699, 27927431, 25131365
29378913, 28958624, 25670786, 27236722, 27440094, 26577716, 29372069
25537905, 25576813, 24326846, 27758972, 27115422, 26301456, 28227512
30134453, 26546070, 25696520, 30266960, 26308703, 25672640, 28090453
26029780, 16727454, 25541343, 26532186, 22939829, 26354420, 26840654
30391272, 24692973, 30164714, 26091640, 29452251, 28697806, 27186837
27757979, 27434193, 26963310, 29767177, 26277439, 23762756, 28578164
28401116, 23184263, 28365111, 25885148, 22070473, 27986817, 27244999
29216723, 25405687, 29630212, 24588377, 25775444, 27223075, 25410877
27850112, 26029075, 24534401, 25074866, 25789041, 26791882, 28468312
26493466, 25715140, 26486365, 25367721, 27687880, 24403376, 25031461
22900591, 25871177, 22843979, 29817278, 27611612, 24350620, 27400598
29434301, 22174392, 28373960, 25151248, 25107662, 24737403, 27303287
25386748, 28545134, 27510959, 25087436, 21415870, 24923215, 24718260
26637824, 25159176, 27541863, 25873336, 26024784, 26039623, 25898228
28291441, 28030440, 25747760, 27870441, 25643818, 23527363, 25906117
27160922, 28388910, 27370933, 28180464, 27106179, 28124631, 23665623
28468785, 25353983, 28247681, 24717859, 26330994, 26558603, 26176002
27971503, 25729507, 23336559, 27399762, 25986062, 25697364, 25811650
26115835, 24609592, 26186998, 25197670, 26608238, 23743596, 28791725
27929287, 25803563, 27839996, 28108003, 23018676, 27300007, 25044977
28777174, 26237773, 25655390, 24744686, 24800423, 29794462, 25037836
27588271, 27170305, 25417958, 21788462, 26372145, 27058530, 29115857
26591240, 26844406, 27686599, 13554903, 26547521, 24801152, 29125374
26185271, 27212837, 23715518, 27251690, 28856060, 27060167, 27600706
28386259, 23738553, 25643931, 28528349, 26992964, 24422155, 27160360
26654615, 25579761, 25326099, 29060216, 25873521, 27174938, 26112621
26884984, 28850873, 27255377, 26354448, 26597140, 24556862, 25826440
25417056, 26270685, 25528838, 25319173, 13250991, 24330981, 26762083
24737581, 28855922, 27751006, 25911724, 27302711, 24423416, 25383204
27309269, 26615690, 24337882, 26962111, 29364171, 26895149, 26110500
27757567, 24848923, 26818368, 26367460, 22446455, 27508985, 26849779
28571483, 27049254, 29135406, 29670713, 26910716, 27072923, 26189861
26327624, 26608137, 27554074, 29542449, 22503283, 19721304, 23738304
24461826, 27999073, 27134734, 25662421, 26040483, 29825525, 26259265
25178179, 23047782, 29002488, 21320338, 24467122, 27293599, 28534493
25293659, 24656487, 27009164, 29991257, 26522439, 26877592, 29875459
29394749, 26542835, 29050886, 28086550, 24655717, 27542831, 28361221
24824518, 28120036, 22480200, 29956349, 28865162, 26725687, 29286300
29853485, 27457891, 25890662, 27334316, 26875822, 29260956, 24343905
29944035, 27351628, 24373756, 27423251, 25695903, 29437712, 24922704
27593501, 27562488, 30147928, 25192044, 29818625, 27036163, 25648731
25790353, 26544823, 29893132, 26111524, 25166187, 26336977, 30282501
24965426, 24462646, 28218832, 26275415, 24843188, 26407408, 28402823
29797504, 25556203, 26710631, 25325522, 25714525, 25309116, 25207410
24679041, 22726044, 27238077, 23234232, 26896659, 26717528, 28033429
27898015, 27620808, 20591151, 25171041, 22921674, 25838755, 26950548
27929509, 24953434, 24697323, 28521330, 25457409, 25647325, 27668379
29869404, 25120742, 28071462, 28387384, 26170715, 25659655, 25265499
25780343, 28375383, 26261135, 26007720, 27442041, 26133777, 25357142
27035653
--------------------------------------------------------------------------------
OPatch succeeded.
Check the PSU(Windows patch applied or not in view sys.dba_registry_sqlpatch
C:\APP\oracle\product\12.2\grid\OPatch> sqlplus sys as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sat Mar 28 06:14:22 2020
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> SET LINESIZE 400
SET PAGESIZE 100
COLUMN action_time FORMAT A20
COLUMN action FORMAT A10
COLUMN status FORMAT A10
COLUMN description FORMAT A40
COLUMN version FORMAT A10
COLUMN bundle_series FORMAT A10
SQL> SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
action, status, description, version, patch_id, bundle_series FROM sys.dba_registry_sqlpatch ORDER by action_time;
ACTION_TIME ACTION STATUS DESCRIPTION VERSION PATCH_ID BUNDLE_SER
-------------------- ---------- ---------- ---------------------------------------- ---------- ---------- ----------
28-MAR-2020 02:17:27 APPLY SUCCESS WINDOWS DB BUNDLE PATCH 12.2.0.1.200114( 12.2.0.1 30446296 PSU
64bit):30446296
