Oracle Database Commands and Practical Examples

Tuesday 15 January 2019

OPatch completed with warnings. Opatch rollback -id 27475613 on 12.2.0.1.0 database server

On this article we found while applying PSU patch on 12.2.0.1.0 database server we found that patch not applied successfully shows message OPatch completed with warnings. So we rollback the patch id on it, Just wanted to share knowledge with you all. This issue i have faced on both linux and window environment and resolved easily. All the best .

[oracle@zabbix backup]$ cd 27726453
[oracle@zabbix 27726453]$ ll
total 32
drwxr-xr-x 4 oracle oinstall 4096 Mar 13 14:05 27475613
drwxr-xr-x 4 oracle oinstall 4096 Apr 9 13:13 27674384
-rw-r--r-- 1 oracle oinstall 19815 Apr 17 13:38 README.html
-rw-r--r-- 1 oracle oinstall 21 Apr 17 13:39 README.txt
[oracle@zabbix 27726453]$ cd 27475613
[oracle@zabbix 27475613]$ ll
total 76
drwxr-x--- 3 oracle oinstall 4096 Mar 13 14:05 etc
drwxr-x--- 5 oracle oinstall 4096 Mar 13 14:05 files
-rw-rw-r-- 1 oracle oinstall 60600 Apr 16 16:55 README.html
-rw-r--r-- 1 oracle oinstall 11 Mar 13 14:05 README.txt
[oracle@zabbix 27475613]$ export ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1
[oracle@zabbix 27475613]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[oracle@zabbix 27475613]$export PATH=$ORACLE_HOME/perl/bin:$PATH
[oracle@zabbix 27475613]$
[oracle@zabbix 27475613]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.13
Copyright (c) 2018, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/oracle/product/12.2.0.1/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.13
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2018-05-29_21-10-51PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@zabbix 27475613]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.13
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.2.0.1/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.13
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2018-05-29_21-11-03PM_1.log

Verifying environment and performing prerequisite checks...

The following patch(es) are duplicate patches with patches installed in the Oracle Home.
[ 27475613]
You have already installed same patch(es) with same UPI(s) or same version(s).
These patch(es) will be skipped.

OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2018-05-29_21-11-03PM_1.log

OPatch completed with warnings.
[oracle@zabbix 27475613]$

[oracle@zabbix OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.13
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.2.0.1/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.13
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2018-05-29_21-14-24PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-05-29_21-14-24PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: zabbix.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c 12.2.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 27475613 : applied on Tue May 29 21:00:07 IST 2018
Unique Patch ID: 22028200
Patch description: "OJVM RELEASE UPDATE: 12.2.0.1.180417 (27475613)"
Created on 13 Mar 2018, 01:35:52 hrs PST8PDT
Bugs fixed:
25811105, 25890046, 26023042, 26570134, 27000702, 27461740

Patch 27674384 : applied on Tue May 29 20:44:04 IST 2018
Unique Patch ID: 22098633
Patch description: "Database Apr 2018 Release Update : 12.2.0.1.180417 (27674384)"
Created on 9 Apr 2018, 00:43:55 hrs PST8PDT
Bugs fixed:
23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877
25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421
25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959
25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846
24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398
24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007
25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332
25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017
22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726
25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817
24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628
24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167
25967985, 26546754, 26546664, 26544823, 26575788, 26271001, 26198926
26025681, 26078437, 25789579, 25034396, 24655717, 25124363, 23527363
25530814, 21981529, 25062592, 25057811, 23179662, 25530080, 25528838
25417056, 25100579, 25739065, 25700654, 25655966, 25631933, 25616645
25616417, 25594901, 25825910, 25789041, 22568728, 21159907, 20736227
19327292, 14690846, 25099497, 24938784, 25257085, 25237577, 25230945
25425760, 25337640, 25263960, 22654475, 21186167, 23491861, 23300142
23234232, 23151677, 22981722, 23733981, 24556967, 24485161, 24457597
24737064, 24578718, 24792678, 20324049, 17533661, 17027695, 22645009
22628825, 23521523, 23499160, 24289874, 24421668, 24332831, 24425998
24555417, 24737403, 25121089, 25192729, 25164293, 25150925, 25579761
25570929, 25980605, 25954022, 25797124, 26308650, 26261327, 26088836
25874050, 25178179, 25176408, 22072543, 23735292, 21985256, 22950945
23746128, 25175723, 25451531, 25575628, 25838361, 25932524, 26479173
26526726, 26609942, 24717183, 26362821, 25397936, 25554787, 26523432
26599395, 26331743, 26476244, 26388538, 25498930, 26421667, 26446098
26108080, 25648731, 25087436, 24812047, 25382812, 25695903, 25797092
22179537, 26111842, 19285025, 25558986, 25551676, 24642495, 25633101
25852885, 25897615, 26486365, 26333141, 26537307, 26444887, 26396790
26358670, 26244115, 25489607, 25947799, 26095405, 26492866, 25248384
26430737, 26187943, 26426526, 22898198, 23581777, 25694206, 26088426
26045732, 24693290, 26153977, 25654936, 25870579, 20003668, 24912588
25638456, 25320555, 25240590, 23599216, 25182817, 24735430, 25872127
25192044, 20620169, 26324769, 24960044, 24677696, 25995938, 23125560
23061453, 25166187, 25722608, 25662524, 25598473, 25774077, 19614243
24664211, 25145215, 25123585, 24968162, 25241625, 25472112, 25463844
25410802, 25383204, 22446455, 23481673, 23055900, 26249718, 25967544
22087683, 23730961, 24376875, 24368004, 25162645, 25029022, 25099339
25093872, 25433696, 25392535, 25357142, 25328518, 25553616, 25970731
25953857, 26169345, 26169341, 26091640, 26032573, 22503297, 24341675
24850622, 25186079, 25602488, 25861398, 25980770, 26096382, 26765212
23035249, 24797119, 25405813, 24443539, 25098160, 25384462, 24593740
25241448, 26751171, 26751106, 26545688, 26367012, 25871639, 25597525
25546580, 25063971, 24654629, 23105538, 24401351, 25764020, 25259611
25244807, 25265499, 26650226, 26330994, 26658759, 26351334, 22347493
25140197, 26659182, 25990907, 25660847, 25411036, 24845157, 25888073
20591151, 25954054, 25822410, 25788879, 25335790, 25199585, 24717859
22564336, 24461826, 24337882, 24010030, 22826067, 26680105, 26626879
26641610, 26189861, 25826740, 25335249, 25335360, 25100063, 21216226
26327624, 25977302, 26597140, 26493289, 26435073, 25895224, 25634317
24617969, 19211433, 25911724, 22599050, 24843188, 24486059, 24922704
18594510, 19649997, 24680959, 25107662, 25964954, 23645516, 26237431
25754606, 23572982, 25045228, 25462714, 25722720, 24848746, 24760407
25203656, 25444961, 21520266, 23600861, 24600330, 24415926, 24423416
17947871, 23066146, 24326444, 24346821, 24623975, 24699619, 24801152
24786669, 24710696, 25065563, 25179774, 25129925, 25417958, 26237773
27087426, 27009164, 26969321, 26366517, 26898563, 26784509, 26522439
23271203, 22364044, 25307368, 26758193, 26542135, 15931756, 26548363
25710420, 26434999, 25207410, 26223039, 25524955, 25579458, 25489367
25313411, 24554533, 20756305, 25478885, 25858672, 26036748, 24966788
24766309, 21178363, 23715460, 23197730, 23602213, 25072986, 25729507
25890056, 25807997, 25206864, 23065002, 24345420, 24303148, 22864303
24435982, 24848923, 24978100, 24953434, 25210268, 25209912, 25981498
25919622, 25871177, 26569225, 26744595, 26908788, 25313154, 27135993
26635897, 26939314, 26983259, 26820076, 25785441, 27142373, 26729494
20532077, 23249829, 27073314, 26629381, 27079140, 26911000, 26944190
25305405, 23741944, 25348956, 25768681, 26794786, 25646373, 24570598
26399626, 25674386, 25225795, 25224242, 25536819, 25296876, 26375250
25963024, 26615690, 26442308, 25476149, 26170715, 25685152, 24307571
19526548, 24468470, 24744383, 25171084, 24713381, 24827654, 24343905
21433452, 24373756, 24923790, 24911709, 26019148, 24940060, 24595699
25691904, 25687460, 25672640, 25874678, 25785331, 22379010, 18521691
8480838, 25159176, 25227381, 25561296, 25440818, 23588722, 24470606
24692973, 24674197, 20118035, 24563422, 24759556, 25201454, 27165231
27052607, 22007324, 26037215, 25830492, 25086233, 26584641, 21147908
26110632, 24403922, 25386748, 24350620, 27305039, 22503283, 22581771
25945130, 26967713, 22367053, 26478970, 19647894, 26149904, 25437699
18774543, 26849779, 26121990, 26374791, 24374976, 25202355, 26608137
27034890, 22970869, 25489342, 25717371, 16727454, 27117822, 25557886
20087519, 25904273, 26637273, 25078611, 26006257, 25803545, 26038086
24689376, 25941836, 23709062, 19072655, 25634348, 25661819, 24486237
25388896, 22104866, 22070853, 25647325, 22504793, 26418088, 25287072
26633355, 26909100, 23080557, 25120284, 26245237, 23126545, 24616637
26256131, 23019710, 24308349, 22700845, 27169796, 25975723, 26797591
26080410, 24923338, 27213224, 27044297, 25813931, 22495673, 24802934
26263328, 25653109, 26840654, 25914276, 25492379, 26822620, 26556014
26198757, 25722055, 25516250, 21479706, 27124624, 26029780, 25760195
25790353, 22843979, 25616268, 26095327, 26775602, 20866970, 25353983
26981902, 25103996, 26740700, 26243698, 26259265, 25555252, 26875822
26452606, 26263721, 25639019, 25635149, 27060167, 24437162, 24589081
26546070, 25775213, 25865785, 24609592, 25943271, 26513709, 27274536
27508985, 27548131, 27611612, 26712331, 27338912, 26090767, 24473736
26444601, 27501373, 16942578, 21320338, 26907327, 26353617, 27329612
27394703, 25832935, 24737581, 25871753, 26091786, 24923080, 25680221
27207110, 24844549, 25784002, 25982666, 26412540, 26201113, 26729611
25226665, 26475419, 24757934, 25654459, 25614866, 27333106, 26637824
26498354, 20976443, 26138085, 27229389, 24793511, 26714910, 25058080
24719799, 23184263, 26802503, 24800423, 25540738, 27367194, 27292213
27138325, 27441326, 27502420

--------------------------------------------------------------------------------

OPatch succeeded.
[oracle@zabbix OPatch]$ opatch rollback -id 27475613
-bash: opatch: command not found
[oracle@zabbix OPatch]$ ./opatch rollback -id 27475613
Oracle Interim Patch Installer version 12.2.0.1.13
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.2.0.1/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.13
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2018-05-29_21-16-04PM_1.log

Patches will be rolled back in the following order:
27475613
The following patch(es) will be rolled back: 27475613

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.2.0.1/db_1')

Is the local system ready for patching? [y|n]
yes
User Responded with: Y

Rolling back patch 27475613...

RollbackSession rolling back interim patch '27475613' from OH '/u01/app/oracle/product/12.2.0.1/db_1'

Patching component oracle.javavm.server, 12.2.0.1.0...

Patching component oracle.javavm.server.core, 12.2.0.1.0...

Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...

Patching component oracle.rdbms, 12.2.0.1.0...
RollbackSession removing interim patch '27475613' from inventory
Log file location: /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2018-05-29_21-16-04PM_1.log

OPatch succeeded.
[oracle@zabbix OPatch]$

[oracle@zabbix OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.13
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.2.0.1/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.13
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2018-05-29_21-14-24PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-05-29_21-14-24PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: zabbix.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c 12.2.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 27475613 : applied on Tue May 29 21:00:07 IST 2018
Unique Patch ID: 22028200
Patch description: "OJVM RELEASE UPDATE: 12.2.0.1.180417 (27475613)"
Created on 13 Mar 2018, 01:35:52 hrs PST8PDT
Bugs fixed:
25811105, 25890046, 26023042, 26570134, 27000702, 27461740

Patch 27674384 : applied on Tue May 29 20:44:04 IST 2018
Unique Patch ID: 22098633
Patch description: "Database Apr 2018 Release Update : 12.2.0.1.180417 (27674384)"
Created on 9 Apr 2018, 00:43:55 hrs PST8PDT
Bugs fixed:
23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877
25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421
25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959
25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846
24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398
24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007
25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332
25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017
22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726
25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817
24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628
24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167
25967985, 26546754, 26546664, 26544823, 26575788, 26271001, 26198926
26025681, 26078437, 25789579, 25034396, 24655717, 25124363, 23527363
25530814, 21981529, 25062592, 25057811, 23179662, 25530080, 25528838
25417056, 25100579, 25739065, 25700654, 25655966, 25631933, 25616645
25616417, 25594901, 25825910, 25789041, 22568728, 21159907, 20736227
19327292, 14690846, 25099497, 24938784, 25257085, 25237577, 25230945
25425760, 25337640, 25263960, 22654475, 21186167, 23491861, 23300142
23234232, 23151677, 22981722, 23733981, 24556967, 24485161, 24457597
24737064, 24578718, 24792678, 20324049, 17533661, 17027695, 22645009
22628825, 23521523, 23499160, 24289874, 24421668, 24332831, 24425998
24555417, 24737403, 25121089, 25192729, 25164293, 25150925, 25579761
25570929, 25980605, 25954022, 25797124, 26308650, 26261327, 26088836
25874050, 25178179, 25176408, 22072543, 23735292, 21985256, 22950945
23746128, 25175723, 25451531, 25575628, 25838361, 25932524, 26479173
26526726, 26609942, 24717183, 26362821, 25397936, 25554787, 26523432
26599395, 26331743, 26476244, 26388538, 25498930, 26421667, 26446098
26108080, 25648731, 25087436, 24812047, 25382812, 25695903, 25797092
22179537, 26111842, 19285025, 25558986, 25551676, 24642495, 25633101
25852885, 25897615, 26486365, 26333141, 26537307, 26444887, 26396790
26358670, 26244115, 25489607, 25947799, 26095405, 26492866, 25248384
26430737, 26187943, 26426526, 22898198, 23581777, 25694206, 26088426
26045732, 24693290, 26153977, 25654936, 25870579, 20003668, 24912588
25638456, 25320555, 25240590, 23599216, 25182817, 24735430, 25872127
25192044, 20620169, 26324769, 24960044, 24677696, 25995938, 23125560
23061453, 25166187, 25722608, 25662524, 25598473, 25774077, 19614243
24664211, 25145215, 25123585, 24968162, 25241625, 25472112, 25463844
25410802, 25383204, 22446455, 23481673, 23055900, 26249718, 25967544
22087683, 23730961, 24376875, 24368004, 25162645, 25029022, 25099339
25093872, 25433696, 25392535, 25357142, 25328518, 25553616, 25970731
25953857, 26169345, 26169341, 26091640, 26032573, 22503297, 24341675
24850622, 25186079, 25602488, 25861398, 25980770, 26096382, 26765212
23035249, 24797119, 25405813, 24443539, 25098160, 25384462, 24593740
25241448, 26751171, 26751106, 26545688, 26367012, 25871639, 25597525
25546580, 25063971, 24654629, 23105538, 24401351, 25764020, 25259611
25244807, 25265499, 26650226, 26330994, 26658759, 26351334, 22347493
25140197, 26659182, 25990907, 25660847, 25411036, 24845157, 25888073
20591151, 25954054, 25822410, 25788879, 25335790, 25199585, 24717859
22564336, 24461826, 24337882, 24010030, 22826067, 26680105, 26626879
26641610, 26189861, 25826740, 25335249, 25335360, 25100063, 21216226
26327624, 25977302, 26597140, 26493289, 26435073, 25895224, 25634317
24617969, 19211433, 25911724, 22599050, 24843188, 24486059, 24922704
18594510, 19649997, 24680959, 25107662, 25964954, 23645516, 26237431
25754606, 23572982, 25045228, 25462714, 25722720, 24848746, 24760407
25203656, 25444961, 21520266, 23600861, 24600330, 24415926, 24423416
17947871, 23066146, 24326444, 24346821, 24623975, 24699619, 24801152
24786669, 24710696, 25065563, 25179774, 25129925, 25417958, 26237773
27087426, 27009164, 26969321, 26366517, 26898563, 26784509, 26522439
23271203, 22364044, 25307368, 26758193, 26542135, 15931756, 26548363
25710420, 26434999, 25207410, 26223039, 25524955, 25579458, 25489367
25313411, 24554533, 20756305, 25478885, 25858672, 26036748, 24966788
24766309, 21178363, 23715460, 23197730, 23602213, 25072986, 25729507
25890056, 25807997, 25206864, 23065002, 24345420, 24303148, 22864303
24435982, 24848923, 24978100, 24953434, 25210268, 25209912, 25981498
25919622, 25871177, 26569225, 26744595, 26908788, 25313154, 27135993
26635897, 26939314, 26983259, 26820076, 25785441, 27142373, 26729494
20532077, 23249829, 27073314, 26629381, 27079140, 26911000, 26944190
25305405, 23741944, 25348956, 25768681, 26794786, 25646373, 24570598
26399626, 25674386, 25225795, 25224242, 25536819, 25296876, 26375250
25963024, 26615690, 26442308, 25476149, 26170715, 25685152, 24307571
19526548, 24468470, 24744383, 25171084, 24713381, 24827654, 24343905
21433452, 24373756, 24923790, 24911709, 26019148, 24940060, 24595699
25691904, 25687460, 25672640, 25874678, 25785331, 22379010, 18521691
8480838, 25159176, 25227381, 25561296, 25440818, 23588722, 24470606
24692973, 24674197, 20118035, 24563422, 24759556, 25201454, 27165231
27052607, 22007324, 26037215, 25830492, 25086233, 26584641, 21147908
26110632, 24403922, 25386748, 24350620, 27305039, 22503283, 22581771
25945130, 26967713, 22367053, 26478970, 19647894, 26149904, 25437699
18774543, 26849779, 26121990, 26374791, 24374976, 25202355, 26608137
27034890, 22970869, 25489342, 25717371, 16727454, 27117822, 25557886
20087519, 25904273, 26637273, 25078611, 26006257, 25803545, 26038086
24689376, 25941836, 23709062, 19072655, 25634348, 25661819, 24486237
25388896, 22104866, 22070853, 25647325, 22504793, 26418088, 25287072
26633355, 26909100, 23080557, 25120284, 26245237, 23126545, 24616637
26256131, 23019710, 24308349, 22700845, 27169796, 25975723, 26797591
26080410, 24923338, 27213224, 27044297, 25813931, 22495673, 24802934
26263328, 25653109, 26840654, 25914276, 25492379, 26822620, 26556014
26198757, 25722055, 25516250, 21479706, 27124624, 26029780, 25760195
25790353, 22843979, 25616268, 26095327, 26775602, 20866970, 25353983
26981902, 25103996, 26740700, 26243698, 26259265, 25555252, 26875822
26452606, 26263721, 25639019, 25635149, 27060167, 24437162, 24589081
26546070, 25775213, 25865785, 24609592, 25943271, 26513709, 27274536
27508985, 27548131, 27611612, 26712331, 27338912, 26090767, 24473736
26444601, 27501373, 16942578, 21320338, 26907327, 26353617, 27329612
27394703, 25832935, 24737581, 25871753, 26091786, 24923080, 25680221
27207110, 24844549, 25784002, 25982666, 26412540, 26201113, 26729611
25226665, 26475419, 24757934, 25654459, 25614866, 27333106, 26637824
26498354, 20976443, 26138085, 27229389, 24793511, 26714910, 25058080
24719799, 23184263, 26802503, 24800423, 25540738, 27367194, 27292213
27138325, 27441326, 27502420

--------------------------------------------------------------------------------

OPatch succeeded.
[oracle@zabbix OPatch]$ ll
total 188
drwxr-s--- 6 oracle oinstall 4096 Apr 16 14:28 auto
drwxr-s--- 2 oracle oinstall 4096 Apr 16 14:17 config
-rwxr-x--- 1 oracle oinstall 589 Apr 16 14:17 datapatch
-rwxr-x--- 1 oracle oinstall 627 Apr 16 14:17 datapatch.bat
drwxr-s--- 2 oracle oinstall 4096 Apr 16 14:28 docs
-rwxr-x--- 1 oracle oinstall 23518 Apr 16 14:17 emdpatch.pl
drwxr-s--- 2 oracle oinstall 4096 Apr 16 14:17 jlib
drwxr-s--- 5 oracle oinstall 4096 Apr 16 13:59 jre
drwxr-s--- 9 oracle oinstall 4096 Apr 16 14:28 modules
drwxr-s--- 5 oracle oinstall 4096 Apr 16 14:17 ocm
-rwxr-x--- 1 oracle oinstall 46949 Apr 16 14:17 opatch
-rwxr-x--- 1 oracle oinstall 1442 Apr 16 14:28 opatchauto
-rwxr-x--- 1 oracle oinstall 393 Apr 16 14:28 opatchauto.cmd
-rwxr-x--- 1 oracle oinstall 15596 Apr 16 14:17 opatch.bat
-rwxr-x--- 1 oracle oinstall 4290 Apr 16 14:17 opatch_env.sh
-rw-r----- 1 oracle oinstall 2541 Apr 16 14:17 opatch.pl
drwxr-s--- 4 oracle oinstall 4096 Apr 16 14:17 opatchprereqs
-rwxr-x--- 1 oracle oinstall 3159 Apr 16 14:17 operr
-rwxr-x--- 1 oracle oinstall 4218 Apr 16 14:17 operr.bat
-rw-r----- 1 oracle oinstall 3177 Apr 16 14:17 operr_readme.txt
drwxr-s--- 2 oracle oinstall 4096 Apr 16 14:28 oplan
drwxr-s--- 3 oracle oinstall 4096 Apr 16 14:28 oracle_common
drwxr-s--- 3 oracle oinstall 4096 Apr 16 14:28 plugins
-rw-r----- 1 oracle oinstall 2980 Apr 16 14:17 README.txt
drwxr-s--- 2 oracle oinstall 4096 Apr 16 14:17 scripts
-rw-r----- 1 oracle oinstall 27 Apr 16 14:17 version.txt
[oracle@zabbix OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.13
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.2.0.1/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.13
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2018-05-29_21-20-59PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-05-29_21-20-59PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: zabbix.com
ARU platform id: 226
ARU platform description:: Linux x86-64

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 27674384 : applied on Tue May 29 20:44:04 IST 2018
Unique Patch ID: 22098633
Patch description: "Database Apr 2018 Release Update : 12.2.0.1.180417 (27674384)"
Created on 9 Apr 2018, 00:43:55 hrs PST8PDT
Bugs fixed:
23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877
25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421
25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959
25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846
24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398
24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007
25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332
25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017
22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726
25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817
24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628
24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167
25967985, 26546754, 26546664, 26544823, 26575788, 26271001, 26198926
26025681, 26078437, 25789579, 25034396, 24655717, 25124363, 23527363
25530814, 21981529, 25062592, 25057811, 23179662, 25530080, 25528838
25417056, 25100579, 25739065, 25700654, 25655966, 25631933, 25616645
25616417, 25594901, 25825910, 25789041, 22568728, 21159907, 20736227
19327292, 14690846, 25099497, 24938784, 25257085, 25237577, 25230945
25425760, 25337640, 25263960, 22654475, 21186167, 23491861, 23300142
23234232, 23151677, 22981722, 23733981, 24556967, 24485161, 24457597
24737064, 24578718, 24792678, 20324049, 17533661, 17027695, 22645009
22628825, 23521523, 23499160, 24289874, 24421668, 24332831, 24425998
24555417, 24737403, 25121089, 25192729, 25164293, 25150925, 25579761
25570929, 25980605, 25954022, 25797124, 26308650, 26261327, 26088836
25874050, 25178179, 25176408, 22072543, 23735292, 21985256, 22950945
23746128, 25175723, 25451531, 25575628, 25838361, 25932524, 26479173
26526726, 26609942, 24717183, 26362821, 25397936, 25554787, 26523432
26599395, 26331743, 26476244, 26388538, 25498930, 26421667, 26446098
26108080, 25648731, 25087436, 24812047, 25382812, 25695903, 25797092
22179537, 26111842, 19285025, 25558986, 25551676, 24642495, 25633101
25852885, 25897615, 26486365, 26333141, 26537307, 26444887, 26396790
26358670, 26244115, 25489607, 25947799, 26095405, 26492866, 25248384
26430737, 26187943, 26426526, 22898198, 23581777, 25694206, 26088426
26045732, 24693290, 26153977, 25654936, 25870579, 20003668, 24912588
25638456, 25320555, 25240590, 23599216, 25182817, 24735430, 25872127
25192044, 20620169, 26324769, 24960044, 24677696, 25995938, 23125560
23061453, 25166187, 25722608, 25662524, 25598473, 25774077, 19614243
24664211, 25145215, 25123585, 24968162, 25241625, 25472112, 25463844
25410802, 25383204, 22446455, 23481673, 23055900, 26249718, 25967544
22087683, 23730961, 24376875, 24368004, 25162645, 25029022, 25099339
25093872, 25433696, 25392535, 25357142, 25328518, 25553616, 25970731
25953857, 26169345, 26169341, 26091640, 26032573, 22503297, 24341675
24850622, 25186079, 25602488, 25861398, 25980770, 26096382, 26765212
23035249, 24797119, 25405813, 24443539, 25098160, 25384462, 24593740
25241448, 26751171, 26751106, 26545688, 26367012, 25871639, 25597525
25546580, 25063971, 24654629, 23105538, 24401351, 25764020, 25259611
25244807, 25265499, 26650226, 26330994, 26658759, 26351334, 22347493
25140197, 26659182, 25990907, 25660847, 25411036, 24845157, 25888073
20591151, 25954054, 25822410, 25788879, 25335790, 25199585, 24717859
22564336, 24461826, 24337882, 24010030, 22826067, 26680105, 26626879
26641610, 26189861, 25826740, 25335249, 25335360, 25100063, 21216226
26327624, 25977302, 26597140, 26493289, 26435073, 25895224, 25634317
24617969, 19211433, 25911724, 22599050, 24843188, 24486059, 24922704
18594510, 19649997, 24680959, 25107662, 25964954, 23645516, 26237431
25754606, 23572982, 25045228, 25462714, 25722720, 24848746, 24760407
25203656, 25444961, 21520266, 23600861, 24600330, 24415926, 24423416
17947871, 23066146, 24326444, 24346821, 24623975, 24699619, 24801152
24786669, 24710696, 25065563, 25179774, 25129925, 25417958, 26237773
27087426, 27009164, 26969321, 26366517, 26898563, 26784509, 26522439
23271203, 22364044, 25307368, 26758193, 26542135, 15931756, 26548363
25710420, 26434999, 25207410, 26223039, 25524955, 25579458, 25489367
25313411, 24554533, 20756305, 25478885, 25858672, 26036748, 24966788
24766309, 21178363, 23715460, 23197730, 23602213, 25072986, 25729507
25890056, 25807997, 25206864, 23065002, 24345420, 24303148, 22864303
24435982, 24848923, 24978100, 24953434, 25210268, 25209912, 25981498
25919622, 25871177, 26569225, 26744595, 26908788, 25313154, 27135993
26635897, 26939314, 26983259, 26820076, 25785441, 27142373, 26729494
20532077, 23249829, 27073314, 26629381, 27079140, 26911000, 26944190
25305405, 23741944, 25348956, 25768681, 26794786, 25646373, 24570598
26399626, 25674386, 25225795, 25224242, 25536819, 25296876, 26375250
25963024, 26615690, 26442308, 25476149, 26170715, 25685152, 24307571
19526548, 24468470, 24744383, 25171084, 24713381, 24827654, 24343905
21433452, 24373756, 24923790, 24911709, 26019148, 24940060, 24595699
25691904, 25687460, 25672640, 25874678, 25785331, 22379010, 18521691
8480838, 25159176, 25227381, 25561296, 25440818, 23588722, 24470606
24692973, 24674197, 20118035, 24563422, 24759556, 25201454, 27165231
27052607, 22007324, 26037215, 25830492, 25086233, 26584641, 21147908
26110632, 24403922, 25386748, 24350620, 27305039, 22503283, 22581771
25945130, 26967713, 22367053, 26478970, 19647894, 26149904, 25437699
18774543, 26849779, 26121990, 26374791, 24374976, 25202355, 26608137
27034890, 22970869, 25489342, 25717371, 16727454, 27117822, 25557886
20087519, 25904273, 26637273, 25078611, 26006257, 25803545, 26038086
24689376, 25941836, 23709062, 19072655, 25634348, 25661819, 24486237
25388896, 22104866, 22070853, 25647325, 22504793, 26418088, 25287072
26633355, 26909100, 23080557, 25120284, 26245237, 23126545, 24616637
26256131, 23019710, 24308349, 22700845, 27169796, 25975723, 26797591
26080410, 24923338, 27213224, 27044297, 25813931, 22495673, 24802934
26263328, 25653109, 26840654, 25914276, 25492379, 26822620, 26556014
26198757, 25722055, 25516250, 21479706, 27124624, 26029780, 25760195
25790353, 22843979, 25616268, 26095327, 26775602, 20866970, 25353983
26981902, 25103996, 26740700, 26243698, 26259265, 25555252, 26875822
26452606, 26263721, 25639019, 25635149, 27060167, 24437162, 24589081
26546070, 25775213, 25865785, 24609592, 25943271, 26513709, 27274536
27508985, 27548131, 27611612, 26712331, 27338912, 26090767, 24473736
26444601, 27501373, 16942578, 21320338, 26907327, 26353617, 27329612
27394703, 25832935, 24737581, 25871753, 26091786, 24923080, 25680221
27207110, 24844549, 25784002, 25982666, 26412540, 26201113, 26729611
25226665, 26475419, 24757934, 25654459, 25614866, 27333106, 26637824
26498354, 20976443, 26138085, 27229389, 24793511, 26714910, 25058080
24719799, 23184263, 26802503, 24800423, 25540738, 27367194, 27292213
27138325, 27441326, 27502420

--------------------------------------------------------------------------------

OPatch succeeded.
[oracle@zabbix OPatch]$

PSU and OJVM Patch on Production and Physical Standby database server 11.2.0.4.0. version

PSU PATCH on 11.2.0.4 Enterprise (Edition Primary and Standby server)

eg:
OJVM +PPSU Patch April : p25440428_112040_Linux-x86-64.zip
p6880880_112000_Linux-x86-64.zip

#######################################################################

### Window Path set ###

set ORACLE_HOME=C:\app\varunyadav\product\12.1.0\dbhome_1

set PATH=%ORACLE_HOME%\OPatch;%PATH%

set PATH=%ORACLE_HOME%\perl\bin;%PATH%

### Linux Path Set ####

12c
export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1
export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
export PATH=$ORACLE_HOME/perl/bin:$PATH

11g

export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1

export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin

export PATH=$ORACLE_HOME/perl/bin:$PATH

############################## PSU Patch applied on Standby server #################################
STEP 1:
1. Download patch from oracle support

STEP 2 :

Transfer patch to primary and DR server

STEP 3 :

check optach version and opatch lsinventory

STEP 4 : FOR VERSION SUPPORT BEFORE APPLYING PATCH CHECK IT

unzip p6880880_112000_Linux-x86-64.zip (for version support)

mv OPatch OPatch_old

unzip p6880880_112000_Linux-x86-64.zip

make backup copy of oracle home

STEP 5 : AFTER COPYING AND UNZIP p6880880 RECHECK USING OPATCH LSINVENTORY

cd /database/app/oracle/product/11.2.0/dbhome_1/OPatch
./opatch lsinventory

STEP6 :stop database and listener

STEP 7 : MAKE TAR FILE OF ORACLE HOME

cd /database/app/oracle/

tar -cvzf product.tar.gz product

STEP 8: GO TO PATCH LOCATION

cd /db02/patching_may17 and unzip the patch

STEP 9: set oracle home and path before patch

[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1

[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin

[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export PATH=$ORACLE_HOME/perl/bin:$PATH

STEP 9: Run precheck opatch prereq CheckConflictAgainstOHWithDetail -ph ./

[914495421@750960-GCBLUSRS02CCS01 24732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-42-51AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

STEP 10 : APPLY PATCH

[914495421@750960-GCBLUSRS02CCS01 25434033]$ ./opatch apply

STEP 11 : AFTER APPLYING PATCHES GO TO OPATCH LSINVENTORY AND CHECK THE SAME.

cd /database/app/oracle/product/11.2.0/dbhome_1/OPatch
./opatch lsinventory

STEP 12 : (startup standby database server) and listener

--> sqlplus

--> startup mount

######################################################## APPLY PATCH ON PRODUCTION SERVER #################################################

GO TO PRODUCTION DATABASE AND FOLLOW THESE STEPS :

[914495421@731089-GCULUSRS01APP01 ~]$ ps -ef |grep pmon
784 8386 1 0 2016 ? 00:39:20 ora_pmon_owcsprod
784 45714 44571 0 03:01 pts/1 00:00:00 grep pmon
[914495421@731089-GCULUSRS01APP01 ~]$ . oraenv
ORACLE_SID = [914495421] ? owcsprod
The Oracle base has been set to /database/app/oracle

STEP 1: STOP DATABASE AND LISTENER and agent , stop backup from oem12c or 13c (if it is scheduled from crontab than disable it)

[914495421@731089-GCULUSRS01APP01 ~]$ sqlplus sys@owcsprod as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun May 28 03:01:47 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
OWCSPROD READ WRITE PRIMARY

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

[914495421@731089-GCULUSRS01APP01 ~]$ lsnrctl stop

cd /database/app/agent12c/agent_inst/bin

[914495421@731089-GCULUSRS01APP01 bin]$ ./emctl stop agent

opatch prereq CheckConflictAgainstOHWithDetail -ph ./

[914495421@731089-GCULUSRS01APP01 OPatch]$ export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1
[914495421@731089-GCULUSRS01APP01 OPatch]$
[914495421@731089-GCULUSRS01APP01 OPatch]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[914495421@731089-GCULUSRS01APP01 OPatch]$
[914495421@731089-GCULUSRS01APP01 OPatch]$ export PATH=$ORACLE_HOME/perl/bin:$PATH

STEP 2 : GO TO PATCH LOCATION AND CHECK PRE- REQUESTORIES

[914495421@731089-GCULUSRS01APP01 24732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

STEP 3 : APPLY PATCH

$ opatch apply

STEP 4 :

START DATABASE

[914495421@731089-GCULUSRS01APP01 24732075]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Sun May 28 03:11:38 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 3290345472 bytes
Fixed Size 2257720 bytes
Variable Size 1828719816 bytes
Database Buffers 1442840576 bytes
Redo Buffers 16527360 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/catbundle.sql psu apply

SQL> set head off
SQL> select * from registry$history order by id;

STEP 5: AFTER APPLYING PATCHES GO TO OPATCH LSINVENTORY AND CHECK THE SAME.

cd /database/app/oracle/product/11.2.0/dbhome_1/OPatch
./opatch lsinventory
./opatch lspatches
./opatch version

############################ Brief Summary #######################################

First apply patch on standby than apply it on production database.

Database : OWCSPROD
Version : Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

OJVM +PPSU Patch April : p25440428_112040_Linux-x86-64.zip
p6880880_112000_Linux-x86-64.zip

p6880880_112000_Linux-x86-64.zip

[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 24732075

[914495421@750960-GCBLUSRS02CCS01 25440428]$ ls -lrt
total 28
-rw-r--r-- 1 914495421 oinstall 19578 Apr 17 05:41 README.html -- Always read everthing written over there
drwxr-xr-x 5 914495421 oinstall 4096 Apr 17 05:41 25434033 (OJVM)
drwxr-xr-x 15 914495421 oinstall 4096 Apr 17 05:41 24732075(PSU)

Physical Standby Database
###########################################################################

1. Download patch from oracle support

2. Transfer patch to primary and DR server

3. check optach version and opatch lsinventory

4. unzip p6880880_112000_Linux-x86-64.zip (for version support)

mv OPatch OPatch_old

unzip p6880880_112000_Linux-x86-64.zip

cd /database/app/oracle/product/11.2.0/dbhome_1/OPatch
./opatch lsinventory

4.stop database and listener

cd /database/app/oracle/

tar -cvzf product.tar.gz product

3. cd /db02/patching_may17 and unzip the patch

[914495421@731089-GCULUSRS01APP01 patching_may17]$ . oraenv
ORACLE_SID = [914495421] ? owcsprod
The Oracle base has been set to /database/app/oracle
[914495421@731089-GCULUSRS01APP01 patching_may17]$ sqlplus / as sysdba

shutdown immediate;

[914495421@750960-GCBLUSRS02CCS01 24732075]$ ps -ef |grep lsnr
512 4492 3330 0 06:43 pts/1 00:00:00 grep lsnr
512 64905 1 0 06:29 ? 00:00:00 /database/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
[914495421@750960-GCBLUSRS02CCS01 24732075]$ lsnrctl stop

4. ls -lrt
drwxr-xr-x 4 914495421 oinstall 4096 Apr 17 05:41 25440428
-rw-rw-r-- 1 914495421 oinstall 80522 Apr 18 14:29 PatchSearch.xml
-rw-r--r-- 1 914495421 oinstall 152664496 May 26 12:43 p25440428_112040_Linux-x8
-rw-r--r-- 1 914495421 oinstall 99065778 May 27 07:33 p6880880_112000_Linux-x86

cd 25440428

5. set oracle home and path before patch

[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1

[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin

[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export PATH=$ORACLE_HOME/perl/bin:$PATH

[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 24732075

[914495421@750960-GCBLUSRS02CCS01 25440428]$ ls -lrt
total 28
-rw-r--r-- 1 914495421 oinstall 19578 Apr 17 05:41 README.html
drwxr-xr-x 5 914495421 oinstall 4096 Apr 17 05:41 25434033
drwxr-xr-x 15 914495421 oinstall 4096 Apr 17 05:41 24732075
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 24732075

[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 24732075

[914495421@750960-GCBLUSRS02CCS01 24732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-42-51AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 24732075]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-44-10AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111 24732075

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/database/app/oracle/product/11.2.0/dbhome_1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.sdo, 11.2.0.4.0...

Patching component oracle.sysman.agent, 10.2.0.4.5...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.sdo.locator, 11.2.0.4.0...

Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...

Patching component oracle.xdk.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '18031668' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.ldap.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.crs, 11.2.0.4.0...

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '18522509' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '19121551' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.ordim.client, 11.2.0.4.0...

Patching component oracle.ordim.jai, 11.2.0.4.0...
Applying sub-patch '19769489' to OH '/database/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.ovm, 11.2.0.4.0...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.rdbms.util, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.xdk.parser.java, 11.2.0.4.0...

Patching component oracle.oraolap, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.xdk.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20299013' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms.dv, 11.2.0.4.0...

Patching component oracle.rdbms.oci, 11.2.0.4.0...

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.sysman.agent, 10.2.0.4.5...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.sysman.common, 10.2.0.4.5...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.xdk.parser.java, 11.2.0.4.0...

Patching component oracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.xdk.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.sysman.common.core, 10.2.0.4.5...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20760982' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '21352635' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.sysman.agent, 10.2.0.4.5...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '21948347' to OH '/database/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.sysman.agent, 10.2.0.4.5...

Patching component oracle.ovm, 11.2.0.4.0...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...

Patching component oracle.xdk.parser.java, 11.2.0.4.0...

Patching component oracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.xdk.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.sysman.oms.core, 10.2.0.4.5...
Applying sub-patch '22502456' to OH '/database/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.olap, 11.2.0.4.0...

Patching component oracle.oraolap, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '23054359' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms.dv, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '24006111' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.sqlplus.ic, 11.2.0.4.0...

Patching component oracle.sqlplus, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '24732075' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...

Patching component oracle.sqlplus.ic, 11.2.0.4.0...

Patching component oracle.sqlplus, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.util, 11.2.0.4.0...

Patching component oracle.ordim.client, 11.2.0.4.0...

Patching component oracle.ordim.jai, 11.2.0.4.0...

Patching component oracle.ordim.server, 11.2.0.4.0...
Composite patch 24732075 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-44-10AM_1.log

OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 24732075]$

###################################################

[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 25434033
[914495421@750960-GCBLUSRS02CCS01 25434033]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-53-47AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[914495421@750960-GCBLUSRS02CCS01 25434033]$ ./opatch apply
-bash: ./opatch: No such file or directory
[914495421@750960-GCBLUSRS02CCS01 25434033]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-54-10AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 25434033

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/database/app/oracle/product/11.2.0/dbhome_1')

Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '25434033' to OH '/database/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.javavm.server, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.dbjava.jdbc, 11.2.0.4.0...

Patching component oracle.dbjava.ic, 11.2.0.4.0...

Patching component oracle.javavm.client, 11.2.0.4.0...

--------------------------------------------------------------------------------

*******************************************************************************************************
*******************************************************************************************************
** ATTENTION **
** **
** It is critical and essential to complete the post installation (if you are applying the patch) or **
** post deinstallation (if you are doing rollback of the patch) as per Readme to have a working **
** and functional Oracle JavaVM Component. **
** Failure to follow the instructions could lead to inconsistencies in the database. **
** **
*******************************************************************************************************
*******************************************************************************************************

--------------------------------------------------------------------------------

Patch 25434033 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-54-10AM_1.log

OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$

OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$ cd $ORACLE_HOME
[914495421@750960-GCBLUSRS02CCS01 dbhome_1]$ cd OPatch
[914495421@750960-GCBLUSRS02CCS01 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-55-58AM_1.log

Lsinventory Output file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-28_06-55-58AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: 750960-GCBLUSRS02CCS01.genpact.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 25434033 : applied on Sun May 28 06:54:41 UTC 2017
Unique Patch ID: 21061924
Patch description: "OJVM PATCH SET UPDATE 11.2.0.4.170418"
Created on 28 Feb 2017, 08:19:35 hrs PST8PDT
Bugs fixed:
18933818, 19176885, 17201047, 25067795, 14774730, 19153980, 21911849
23727132, 18166577, 24448240, 17056813, 21811517, 19909862, 25494379
22675136, 24534298, 19895326, 22253904, 17804361, 19231857, 17528315
19058059, 19554117, 19007266, 17285560, 22670385, 18458318, 19187988
23265914, 19006757, 19374518, 19223010, 25076732, 22118835, 19852360
20408829, 21047766, 21566944

Patch 24732075 : applied on Sun May 28 06:46:21 UTC 2017
Unique Patch ID: 21176096
Patch description: "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Created on 22 Feb 2017, 21:40:49 hrs PST8PDT
Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
Bugs fixed:
17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 18441944
13837378, 16314254, 16731148, 17835048, 13558557, 17201159, 17853498
17246576, 18356166, 18440047, 18681862, 16875449, 19788842, 17296856
21330264, 14010183, 17648596, 17551063, 17025461, 17267114, 22507210
17912217, 17889583, 18202441, 17040764, 16524926, 17478145, 19358317
22148226, 18747196, 18641419, 17036973, 17811789, 14285317, 16542886
18009564, 16618694, 8322815, 16692232, 18247991, 22507234, 17570240
17848897, 17441661, 14034426, 17465741, 16596890, 17437634, 20506706
21343897, 21453153, 18339044, 22321741, 17951233, 18430495, 21787056
22380919, 20506715, 17811429, 19721304, 18230522, 19554106, 19458377
17612828, 6599380, 22092979, 22321756, 17040527, 17811438, 18641461
14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549
19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898
24842886, 17546761, 18203835, 18964939, 18203838, 18203837, 17313525
22195457, 18139690, 16837842, 22296366, 14106803, 17842825, 22657942
21352646, 20657441, 16360112, 22195441, 17389192, 14565184, 17205719
18440095, 22195448, 14354737, 14764829, 13944971, 16571443, 21868720
17186905, 17080436, 18673342, 22905130, 17027426, 19972569, 19972568
19972566, 17282229, 19972564, 16870214, 19615136, 17390431, 18762750
16613964, 18098207, 17957017, 18471685, 19730508, 21538485, 18264060
17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 17655634
16228604, 20074391, 19972570, 18996843, 19854503, 16042673, 17835627
20334344, 18000422, 20861693, 17393683, 17551709, 20506699, 19006849
18456514, 18277454, 17258090, 17174582, 17242746, 16399083, 17824637
17762296, 17397545, 16450169, 12364061, 20067212, 18856999, 19211724
19463893, 21343775, 19463897, 17853456, 18673304, 20004021, 21668627
16194160, 17477958, 16538760, 12982566, 20296213, 18293054, 17610798
19699191, 18135678, 17311728, 16785708, 10136473, 24560906, 17786518
18315328, 18334586, 12747740, 19032867, 18096714, 17390160, 17232014
16422541, 18673325, 18155762, 14015842, 19827973, 22683225, 17726838
18554871, 23177648, 18051556, 20803583, 17922254, 15990359, 21972320
18282562, 16855292, 16668584, 21343838, 20299015, 17446237, 18093615
17694209, 17288409, 17274537, 13955826, 16934803, 17634921, 17501491
16315398, 22683212, 17006183, 13829543, 18191164, 17655240, 19393542
18384391, 21538567, 16198143, 21847223, 17892268, 20142975, 19584068
17165204, 18508861, 21756699, 16901385, 18554763, 18189036, 17443671
17385178, 17936109, 14829250, 20925795, 17478514, 16850630, 13951456
16595641, 15861775, 14054676, 16912439, 17299889, 17297939, 18619917
16833527, 17798953, 17816865, 18607546, 17571306, 21286665, 17341326
17851160, 20558005, 17586955, 19049453, 21051840, 17587063, 16956380
18328509, 14133975, 18061914, 21051833, 18522509, 18765602, 18199537
17332800, 13609098, 18384537, 22502493, 14338435, 17945983, 21067387
16392068, 17752995, 21051862, 25505382, 17237521, 16863422, 18244962
19544839, 24433711, 17156148, 18973907, 17877323, 17449815, 18180390
17088068, 17037130, 20004087, 19466309, 25505371, 11733603, 18084625
21051858, 18674024, 21051852, 18091059, 25369547, 16306373, 18306996
19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015
17346091, 18228645, 17721717, 18436307, 21756677, 11883252, 17891943
22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719
25505394, 17265217, 17071721, 16721594, 21756661, 18262334, 15913355
17891946, 17672719, 17602269, 17239687, 17042658, 17238511, 17811456
17284817, 17752121, 17394950, 16579084, 17011832, 22195465, 14602788
18325460, 24476265, 24476274, 12611721, 16903536, 17006570, 16043574
18783224, 16494615, 21526048, 19197175, 16069901, 17811447, 17308789
22195477, 17865671, 19013183, 17343514, 18316692, 17325413, 16180763
17348614, 14368995, 21983325, 17393915, 16285691, 20331945, 17883081
24316947, 17705023, 17614227, 22195485, 14084247, 13645875, 16777840
19727057, 14852021, 18744139, 18674047, 17716305, 18482502, 17622427
19289642, 22195492, 14458214, 18723434, 17767676, 25505407, 19258504
17786278, 17082983, 21351877, 13498382, 18331812, 16065166, 18031668
22893153, 16943711, 21517440, 17649265, 13866822, 18094246, 24528741
14245531, 17783588, 17082359, 20448824, 18280813, 23330119, 16268425
17302277, 18018515, 17215560, 24411921, 19271443, 17016369, 20777150
23330124, 20441797, 19769489, 25093656, 17545847, 18260550, 13853126
23536835, 17227277, 9756271, 18868646, 17614134, 17546973, 19680952
18704244, 18828868, 18273830, 17050888, 17360606, 16992075, 17375354
12905058, 18362222, 17571039, 17468141, 18436647, 17235750, 21168487
16220077, 16929165

--------------------------------------------------------------------------------

OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 OPatch]$

(startup standby database server)

sqlplus

startup mount

##################### Apply patch on production database ####################

production

[914495421@731089-GCULUSRS01APP01 ~]$ ps -ef |grep pmon
784 8386 1 0 2016 ? 00:39:20 ora_pmon_owcsprod
784 45714 44571 0 03:01 pts/1 00:00:00 grep pmon
[914495421@731089-GCULUSRS01APP01 ~]$ . oraenv
ORACLE_SID = [914495421] ? owcsprod
The Oracle base has been set to /database/app/oracle
[914495421@731089-GCULUSRS01APP01 ~]$ sqlplus sys@owcsprod as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun May 28 03:01:47 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
OWCSPROD READ WRITE PRIMARY

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

[914495421@731089-GCULUSRS01APP01 ~]$ lsnrctl stop

cd /database/app/agent12c/agent_inst/bin

[914495421@731089-GCULUSRS01APP01 bin]$ ./emctl stop agent

opatch prereq CheckConflictAgainstOHWithDetail -ph ./

[914495421@731089-GCULUSRS01APP01 OPatch]$ export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1
[914495421@731089-GCULUSRS01APP01 OPatch]$
[914495421@731089-GCULUSRS01APP01 OPatch]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[914495421@731089-GCULUSRS01APP01 OPatch]$
[914495421@731089-GCULUSRS01APP01 OPatch]$ export PATH=$ORACLE_HOME/perl/bin:$PATH

[914495421@731089-GCULUSRS01APP01 24732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_03-07-46AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[914495421@731089-GCULUSRS01APP01 24732075]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_03-07-54AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111 24732075

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/database/app/oracle/product/11.2.0/dbhome_1')

Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.sdo, 11.2.0.4.0...

Patching component oracle.sysman.agent, 10.2.0.4.5...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.sdo.locator, 11.2.0.4.0...

Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...

Patching component oracle.xdk.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '18031668' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.ldap.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.crs, 11.2.0.4.0...

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '18522509' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '19121551' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.ordim.client, 11.2.0.4.0...

Patching component oracle.ordim.jai, 11.2.0.4.0...
Applying sub-patch '19769489' to OH '/database/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.ovm, 11.2.0.4.0...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.rdbms.util, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.xdk.parser.java, 11.2.0.4.0...

Patching component oracle.oraolap, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.xdk.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20299013' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms.dv, 11.2.0.4.0...

Patching component oracle.rdbms.oci, 11.2.0.4.0...

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.sysman.agent, 10.2.0.4.5...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.sysman.common, 10.2.0.4.5...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.xdk.parser.java, 11.2.0.4.0...

Patching component oracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.xdk.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.sysman.common.core, 10.2.0.4.5...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20760982' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '21352635' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.sysman.agent, 10.2.0.4.5...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '21948347' to OH '/database/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.sysman.agent, 10.2.0.4.5...

Patching component oracle.ovm, 11.2.0.4.0...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...

Patching component oracle.xdk.parser.java, 11.2.0.4.0...

Patching component oracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.xdk.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.sysman.oms.core, 10.2.0.4.5...
Applying sub-patch '22502456' to OH '/database/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.olap, 11.2.0.4.0...

Patching component oracle.oraolap, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '23054359' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms.dv, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '24006111' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.sqlplus.ic, 11.2.0.4.0...

Patching component oracle.sqlplus, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '24732075' to OH '/database/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...

Patching component oracle.sqlplus.ic, 11.2.0.4.0...

Patching component oracle.sqlplus, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.util, 11.2.0.4.0...

Patching component oracle.ordim.client, 11.2.0.4.0...

Patching component oracle.ordim.jai, 11.2.0.4.0...

Patching component oracle.ordim.server, 11.2.0.4.0...
Composite patch 24732075 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_03-07-54AM_1.log

OPatch succeeded.
[914495421@731089-GCULUSRS01APP01 24732075]$

Composite patch 24732075 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_03-07-54AM_1.log

OPatch succeeded.
[914495421@731089-GCULUSRS01APP01 24732075]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Sun May 28 03:11:38 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 3290345472 bytes
Fixed Size 2257720 bytes
Variable Size 1828719816 bytes
Database Buffers 1442840576 bytes
Redo Buffers 16527360 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/catbundle.sql psu apply
or
For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the catbundle.sql script as follows:
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
########################################################################################################

[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 25434033
[914495421@750960-GCBLUSRS02CCS01 25434033]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-53-47AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[914495421@750960-GCBLUSRS02CCS01 25434033]$ ./opatch apply
-bash: ./opatch: No such file or directory
[914495421@750960-GCBLUSRS02CCS01 25434033]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-54-10AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 25434033

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/database/app/oracle/product/11.2.0/dbhome_1')

Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '25434033' to OH '/database/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.javavm.server, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.dbjava.jdbc, 11.2.0.4.0...

Patching component oracle.dbjava.ic, 11.2.0.4.0...

Patching component oracle.javavm.client, 11.2.0.4.0...

--------------------------------------------------------------------------------

*******************************************************************************************************
*******************************************************************************************************
** ATTENTION **
** **
** It is critical and essential to complete the post installation (if you are applying the patch) or **
** post deinstallation (if you are doing rollback of the patch) as per Readme to have a working **
** and functional Oracle JavaVM Component. **
** Failure to follow the instructions could lead to inconsistencies in the database. **
** **
*******************************************************************************************************
*******************************************************************************************************

--------------------------------------------------------------------------------

Patch 25434033 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-54-10AM_1.log

OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$

OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$ cd $ORACLE_HOME
[914495421@750960-GCBLUSRS02CCS01 dbhome_1]$ cd OPatch
[914495421@750960-GCBLUSRS02CCS01 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-55-58AM_1.log

Lsinventory Output file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-28_06-55-58AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: 750960-GCBLUSRS02CCS01.genpact.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 25434033 : applied on Sun May 28 06:54:41 UTC 2017
Unique Patch ID: 21061924
Patch description: "OJVM PATCH SET UPDATE 11.2.0.4.170418"
Created on 28 Feb 2017, 08:19:35 hrs PST8PDT
Bugs fixed:
18933818, 19176885, 17201047, 25067795, 14774730, 19153980, 21911849
23727132, 18166577, 24448240, 17056813, 21811517, 19909862, 25494379
22675136, 24534298, 19895326, 22253904, 17804361, 19231857, 17528315
19058059, 19554117, 19007266, 17285560, 22670385, 18458318, 19187988
23265914, 19006757, 19374518, 19223010, 25076732, 22118835, 19852360
20408829, 21047766, 21566944

Patch 24732075 : applied on Sun May 28 06:46:21 UTC 2017
Unique Patch ID: 21176096
Patch description: "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Created on 22 Feb 2017, 21:40:49 hrs PST8PDT
Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
Bugs fixed:
17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 18441944
13837378, 16314254, 16731148, 17835048, 13558557, 17201159, 17853498
17246576, 18356166, 18440047, 18681862, 16875449, 19788842, 17296856
21330264, 14010183, 17648596, 17551063, 17025461, 17267114, 22507210
17912217, 17889583, 18202441, 17040764, 16524926, 17478145, 19358317
22148226, 18747196, 18641419, 17036973, 17811789, 14285317, 16542886
18009564, 16618694, 8322815, 16692232, 18247991, 22507234, 17570240
17848897, 17441661, 14034426, 17465741, 16596890, 17437634, 20506706
21343897, 21453153, 18339044, 22321741, 17951233, 18430495, 21787056
22380919, 20506715, 17811429, 19721304, 18230522, 19554106, 19458377
17612828, 6599380, 22092979, 22321756, 17040527, 17811438, 18641461
14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549
19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898
24842886, 17546761, 18203835, 18964939, 18203838, 18203837, 17313525
22195457, 18139690, 16837842, 22296366, 14106803, 17842825, 22657942
21352646, 20657441, 16360112, 22195441, 17389192, 14565184, 17205719
18440095, 22195448, 14354737, 14764829, 13944971, 16571443, 21868720
17186905, 17080436, 18673342, 22905130, 17027426, 19972569, 19972568
19972566, 17282229, 19972564, 16870214, 19615136, 17390431, 18762750
16613964, 18098207, 17957017, 18471685, 19730508, 21538485, 18264060
17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 17655634
16228604, 20074391, 19972570, 18996843, 19854503, 16042673, 17835627
20334344, 18000422, 20861693, 17393683, 17551709, 20506699, 19006849
18456514, 18277454, 17258090, 17174582, 17242746, 16399083, 17824637
17762296, 17397545, 16450169, 12364061, 20067212, 18856999, 19211724
19463893, 21343775, 19463897, 17853456, 18673304, 20004021, 21668627
16194160, 17477958, 16538760, 12982566, 20296213, 18293054, 17610798
19699191, 18135678, 17311728, 16785708, 10136473, 24560906, 17786518
18315328, 18334586, 12747740, 19032867, 18096714, 17390160, 17232014
16422541, 18673325, 18155762, 14015842, 19827973, 22683225, 17726838
18554871, 23177648, 18051556, 20803583, 17922254, 15990359, 21972320
18282562, 16855292, 16668584, 21343838, 20299015, 17446237, 18093615
17694209, 17288409, 17274537, 13955826, 16934803, 17634921, 17501491
16315398, 22683212, 17006183, 13829543, 18191164, 17655240, 19393542
18384391, 21538567, 16198143, 21847223, 17892268, 20142975, 19584068
17165204, 18508861, 21756699, 16901385, 18554763, 18189036, 17443671
17385178, 17936109, 14829250, 20925795, 17478514, 16850630, 13951456
16595641, 15861775, 14054676, 16912439, 17299889, 17297939, 18619917
16833527, 17798953, 17816865, 18607546, 17571306, 21286665, 17341326
17851160, 20558005, 17586955, 19049453, 21051840, 17587063, 16956380
18328509, 14133975, 18061914, 21051833, 18522509, 18765602, 18199537
17332800, 13609098, 18384537, 22502493, 14338435, 17945983, 21067387
16392068, 17752995, 21051862, 25505382, 17237521, 16863422, 18244962
19544839, 24433711, 17156148, 18973907, 17877323, 17449815, 18180390
17088068, 17037130, 20004087, 19466309, 25505371, 11733603, 18084625
21051858, 18674024, 21051852, 18091059, 25369547, 16306373, 18306996
19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015
17346091, 18228645, 17721717, 18436307, 21756677, 11883252, 17891943
22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719
25505394, 17265217, 17071721, 16721594, 21756661, 18262334, 15913355
17891946, 17672719, 17602269, 17239687, 17042658, 17238511, 17811456
17284817, 17752121, 17394950, 16579084, 17011832, 22195465, 14602788
18325460, 24476265, 24476274, 12611721, 16903536, 17006570, 16043574
18783224, 16494615, 21526048, 19197175, 16069901, 17811447, 17308789
22195477, 17865671, 19013183, 17343514, 18316692, 17325413, 16180763
17348614, 14368995, 21983325, 17393915, 16285691, 20331945, 17883081
24316947, 17705023, 17614227, 22195485, 14084247, 13645875, 16777840
19727057, 14852021, 18744139, 18674047, 17716305, 18482502, 17622427
19289642, 22195492, 14458214, 18723434, 17767676, 25505407, 19258504
17786278, 17082983, 21351877, 13498382, 18331812, 16065166, 18031668
22893153, 16943711, 21517440, 17649265, 13866822, 18094246, 24528741
14245531, 17783588, 17082359, 20448824, 18280813, 23330119, 16268425
17302277, 18018515, 17215560, 24411921, 19271443, 17016369, 20777150
23330124, 20441797, 19769489, 25093656, 17545847, 18260550, 13853126
23536835, 17227277, 9756271, 18868646, 17614134, 17546973, 19680952
18704244, 18828868, 18273830, 17050888, 17360606, 16992075, 17375354
12905058, 18362222, 17571039, 17468141, 18436647, 17235750, 21168487
16220077, 16929165

--------------------------------------------------------------------------------

OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 OPatch]$

Install the SQL portion of the patch by running the following command for a single instance environment.

cd $ORACLE_HOME/sqlpatch/25434033
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> startup upgrade
SQL> @postinstall.sql
SQL> shutdown
SQL> startup

After installing the SQL portion of the patch, some packages could become INVALID. This will get recompiled upon access or you can run utlrp.sql to get them back into a VALID state.
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

SQL> set head off
SQL> select * from registry$history order by id;

24-AUG-13 12.03.45.119862 PM
APPLY SERVER
11.2.0.4 0
Patchset 11.2.0.2.0
PSU

16-DEC-15 03.52.59.628370 PM
APPLY SERVER
11.2.0.4 0
Patchset 11.2.0.2.0
PSU

28-MAY-17 03.21.23.641574 AM
APPLY SERVER
11.2.0.4.170418OJVMPSU 0
OJVM PSU post-install

28-MAY-17 03.21.23.591024 AM
jvmpsu.sql SERVER
11.2.0.4.170418OJVMPSU 0
RAN jvmpsu.sql

28-MAY-17 03.14.03.231179 AM
APPLY SERVER
11.2.0.4 170418
PSU 11.2.0.4.170418
PSU

28-MAY-17 03.21.23.644209 AM
APPLY
25434033
Patch 25434033 applied

6 rows selected.

SQL>