How to apply OCW patch on database home - 21352649 - OCW Patch Set Update : 11.2.0.4.8 (21352649)
This morning one of my colleagues "Birata" just ask me "How to apply OCW patch on database home"?
Prerequisites:
Download new Opatch version and update oracle home on destination home for patching
- Patch # 6880880 - Select a Release: 11.2 - https://updates.oracle.com/download/6880880.html
Create OCM Response file to Apply a Patch in Silent Mode
- How to Create an OCM Response file to Apply a Patch in Silent Mode - opatch silent (Doc ID 966023.1)
- Download Patch 21523375 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.8 (Oct2015) (Includes Database PSU 11.2.0.4.8) from Metalink and upload on destination server for patching
Patching:
Create OCM Response file to Apply a Patch in Silent Mode
Switch to the user related to the Oracle Home for patching, in our case is -> oracle
Execute following to create response file
[oracle@lab13]# /oracle/DBABG/1124/OPatch/ocm/bin/emocmrsp -no_banner -output /oracle/depot/Patches/ocm.rsp |
Unzip Patch to depot location
[oracle@lab13]# unzip p21523375_112040_Linux-x86-64.zip -d /oracle/depot/GIPSU [oracle@lab13]# /oracle/DBABG/1124/OPatch/opatch version |
Checking Oracle Inventory
[oracle@lab13~]$ opatch lsinv Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/DBABG/1124 Central Inventory : /oracle/oraInventory from : /oracle/DBABG/1124/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 |
Stop database running from the Oracle Home related to the patching
- srvctl stop database –d DBABG
Execute following to start with the patching
[root@lab13 OPatch]# ./opatch auto /oracle/depot/Patches/GIPSU/21523375 -oh /oracle/DBABG/1124 -ocmrf /oracle/depot/Patches/ocm.rsp
Executing /oracle/GRD/1212/perl/bin/perl ./crs/patchDB.pl -patchdir /oracle/depot/GIPSU -patchn 21523375 -oh /oracle/DBABG/1124 -ocmrf /oracle/depot/Patches/ocm.rsp
This is the main log file: /oracle/DBABG/1124/cfgtoollogs/opatchauto2017-02-22_09-58-04.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /oracle/DBABG/1124/cfgtoollogs/opatchauto2017-02-22_09-58-04.report.log
Stopping RAC /oracle/DBABG/1124 ... Stopped RAC /oracle/DBABG/1124 successfully
patch /oracle/depo/DBABG_Patches/GIPSU/21523375/21352635 apply successful for home /oracle/DBABG/1124 patch /oracle/depot/DBABG_Patches/GIPSU/21523375/21352649/custom/server/21352649 apply successful for home /oracle/DBABG/1124
Starting RAC /oracle/DBABG/1124 ... Started RAC /oracle/DBABG/1124 successfully
opatch auto succeeded. |
Switch to oracle user
Checking Oracle Inventory :
Output:
[oracle@lab13 ~]$ opatch lsinv Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /oracle/DBABG/1124 Central Inventory : /oracle/oraInventory from : /oracle/DBABG/1124/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 Log file location : /oracle/DBABG/1124/cfgtoollogs/opatch/opatch2017-02-22_10-00-43AM_1.log Lsinventory Output file location : /oracle/DBABG/1124/cfgtoollogs/opatch/lsinv/lsinventory2017-02-22_10-00-43AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: lab13.dba.bg 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 (3) : Patch 21352649 : applied on Wed Feb 22 09:59:02 CET 2017 Unique Patch ID: 19203841 Patch description: "OCW Patch Set Update : 11.2.0.4.8 (21352649)" Created on 2 Sep 2015, 23:43:42 hrs PST8PDT Bugs fixed: 19270660, 18328800, 18508710, 18691572, 21251192, 20365005, 17750548 17387214, 17617807, 14497275, 20219458, 17733927, 18180541, 18962892 17292250, 17378618, 16759171, 20110156, 17843489, 17065496, 13991403 17273020, 17155238, 21245437, 18261183, 18053580, 20218012, 20995001 17039197, 17947785, 16317771, 10052729, 20340620, 20317221, 15917869 18199185, 18399991, 20186278, 17374271, 18024089, 16849642, 20746251 20246071, 14270845, 18882642, 18414137, 17001914, 17927970, 14378120 16346413, 15986647, 18068871, 21222147, 18143836, 16206997, 19168690 20235511, 18343490, 16613232, 19276791, 17722664, 20440643, 12928658 18952577, 18520351, 16249829, 18226143, 18265482, 18229842, 17172091 20676340, 17818075, 20091753, 18231837, 14373486, 17483479, 18120545 18729166, 13843841, 21225209, 17405302, 18709496, 18330979, 18744838 17087371, 20531190, 14525998, 18187697, 20598625, 14385860, 18348155 19479503, 12928592, 17516024, 18370031, 17764053, 19272663, 17551223 14671408, 18272135, 14207615, 17500165, 18875012, 18464784, 19558324 18848125, 19241857, 14851828, 17955615, 20315294, 14693336, 16284825 17352230, 20014326, 17238586, 17089344, 17405605, 17531342, 17159489 17640316, 13823394, 16543190, 17983675, 17598201, 17481314, 16281493 18346135, 15986311, 19601468, 17208793, 18700935, 18999857, 14076173 18428146, 18352845, 17435488, 18352846, 17391726, 17387779, 14777968 15851860, 16206882, 20141091, 20175174, 17305100, 15832129, 19885321 16901346, 17985714, 18536826, 17780903, 18752378, 18946768, 16876500 16875342, 17769597, 19955755, 16429265, 18336452, 17273003, 17209968 16988311, 20094984, 19319357, 17059927, 17046460, 18053631, 16867761 18774591, 21442094, 20235486, 19359787, 15869775, 19642566, 17447588 16798862, 15920201
Patch 18353141 : applied on Wed Feb 22 00:23:47 CET 2017 Unique Patch ID: 17501032 Created on 8 Apr 2014, 10:47:07 hrs PST8PDT Bugs fixed: 18353141
Patch 21352635 : applied on Wed Mar 02 00:22:41 CET 2016 Unique Patch ID: 19227862 Patch description: "Database Patch Set Update : 11.2.0.4.8 (21352635)" Created on 1 Sep 2015, 07:49:44 hrs 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: 17288409, 21051852, 18607546, 17205719, 17811429, 17816865, 20506699 17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817 16992075, 17446237, 14015842, 19972569, 21538558, 20925795, 17449815 17375354, 19463897, 17982555, 17235750, 13866822, 18317531, 17478514 18235390, 14338435, 20803583, 13944971, 20142975, 17811789, 16929165 18704244, 20506706, 17546973, 20334344, 14054676, 17088068, 18264060 17346091, 17343514, 21538567, 19680952, 18471685, 19211724, 13951456 16315398, 18744139, 16850630, 19049453, 18673304, 17883081, 19915271 18641419, 18262334, 17006183, 16065166, 18277454, 16833527, 10136473 18051556, 17865671, 17852463, 18554871, 17853498, 18334586, 17588480 17551709, 19827973, 17842825, 17344412, 18828868, 17025461, 11883252 13609098, 17239687, 17602269, 19197175, 18316692, 17313525, 12611721 19544839, 18964939, 17600719, 18191164, 19393542, 17571306, 18482502 20777150, 19466309, 17040527, 17165204, 18098207, 16785708, 17174582 16180763, 17465741, 16777840, 12982566, 19463893, 12816846, 16875449 17237521, 19358317, 17811438, 17811447, 17945983, 18762750, 17184721 16912439, 18061914, 17282229, 18331850, 18202441, 17082359, 18723434 19554106, 14034426, 18339044, 19458377, 17752995, 20448824, 17891943 17258090, 17767676, 16668584, 18384391, 17040764, 17381384, 15913355 18356166, 14084247, 20506715, 13853126, 18203837, 14245531, 16043574 17848897, 17877323, 17468141, 17786518, 17912217, 17037130, 18155762 16956380, 17478145, 17394950, 18189036, 18641461, 18619917, 17027426 21352646, 16268425, 19584068, 18436307, 17265217, 17634921, 13498382 20004087, 17443671, 18000422, 20004021, 17571039, 21067387, 16344544 18009564, 14354737, 18135678, 18614015, 20441797, 18362222, 17835048 16472716, 17936109, 17050888, 17325413, 14010183, 18747196, 17761775 16721594, 17082983, 20067212, 21179898, 17302277, 18084625, 15990359 18203835, 17297939, 17811456, 16731148, 17215560, 13829543, 14133975 17694209, 18091059, 17385178, 8322815, 17586955, 17201159, 17655634 18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614 17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317 19289642, 14764829, 18328509, 17622427, 16943711, 14368995, 17346671 18996843, 17783588, 16618694, 17672719, 18856999, 18783224, 17851160 17546761, 17798953, 18273830, 19972566, 16384983, 17726838, 17360606 13645875, 18199537, 16542886, 17889549, 14565184, 17071721, 20299015 17610798, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058 18641451, 12747740, 18430495, 17042658, 17016369, 14602788, 19972568 18508861, 19788842, 14657740, 17332800, 13837378, 19972564, 17186905 18315328, 19699191, 17437634, 19006849, 19013183, 17296856, 18674024 17232014, 16855292, 21051840, 14692762, 17762296, 17705023, 19121551 19854503, 19309466, 18681862, 18554763, 20558005, 17390160, 18456514 16306373, 13955826, 18139690, 17501491, 17299889, 17752121, 17889583 18673325, 18293054, 17242746, 17951233, 17649265, 18094246, 19615136 17011832, 16870214, 17477958, 18522509, 20631274, 16091637, 17323222 16595641, 16524926, 18228645, 18282562, 17596908, 17156148, 18031668 16494615, 17545847, 17614134, 13558557, 17341326, 17891946, 17716305 16392068, 19271443, 18092127, 18440047, 17614227, 14106803, 16903536 18973907, 18673342, 17389192, 16194160, 17006570, 17612828, 17721717 17570240, 17390431, 16863422, 18325460, 19727057, 16422541, 19972570 17267114, 18244962, 21538485, 18765602, 18203838, 16198143, 17246576 14829250, 17835627, 18247991, 14458214, 21051862, 16692232, 17786278 17227277, 16042673, 16314254, 16228604, 16837842, 17393683, 17787259 20331945, 20074391, 15861775, 16399083, 18018515, 18260550, 21051858 17036973, 16613964, 17080436, 16579084, 18384537, 18280813, 20296213 16901385, 15979965, 18441944, 16450169, 9756271, 17892268, 11733603 16285691, 17587063, 16538760, 18180390, 18193833, 21051833, 17238511 17824637, 16571443, 18306996, 14852021, 18674047, 17853456, 12364061 -------------------------------------------------------------------------------- OPatch succeeded. |