This discussion is archived
9 Replies Latest reply: Nov 18, 2013 7:19 PM by Hemant K Chitale RSS

which patches should be applied

968751 Explorer
Currently Being Moderated

DB-Version: 11.2.0.2.0  ---- got from v$version

OS : SUNOS 5.10 sparc (this means 32 bit right?)

Two node Rac cluster

 

Hello guys, I have a bit of a situation with patch terminology. My manager came to me and told me that we had to find out which patches to be applied and after that we had to go to metalink and find out what patches are available for our systems.

 

so first off, I logged into one node, went to $ORACLE_HOME/Opatch/ and did the following "opatch lsinventory" and got the following information.

 

Now my question is, how do I use the following info to find out what other patches to be applied?

 

{code}

Oracle Interim Patch Installer version 11.2.0.3.3

Copyright (c) 2012, Oracle Corporation.  All rights reserved.

 

 

 

 

Oracle Home       : /clu01/oracle/product/1120

Central Inventory : /clu01/oracle/oraInventory

   from           : /clu01/oracle/product/1120/oraInst.loc

OPatch version    : 11.2.0.3.3

OUI version       : 11.2.0.2.0

Log file location : /clu01/oracle/product/1120/cfgtoollogs/opatch/opatch2013-10-17_15-41-20PM_1.log

 

 

Lsinventory Output file location : /clu01/oracle/product/1120/cfgtoollogs/opatch/lsinv/lsinventory2013-10-17_15-41-20PM.txt

 

 

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

Installed Top-level Products (1):

 

 

Oracle Database 11g                                                  11.2.0.2.0

There are 1 products installed in this Oracle Home.

 

 

 

 

Interim patches (2) :

 

 

Patch  14727315     : applied on Sat Feb 16 16:34:03 EST 2013

Unique Patch ID:  15707185

Patch description:  "Database Patch Set Update : 11.2.0.2.9 (14727315)"

   Created on 4 Jan 2013, 07:14:17 hrs PST8PDT

Sub-patch  14275621; "Database Patch Set Update : 11.2.0.2.8 (14275621)"

Sub-patch  13923804; "Database Patch Set Update : 11.2.0.2.7 (13923804)"

Sub-patch  13696224; "Database Patch Set Update : 11.2.0.2.6 (13696224)"

   Bugs fixed:

     13080778, 10114837, 10373381, 14461358, 10035737, 12737666, 11065646

     13769501, 12639234, 12586495, 10630870, 12880299, 9715581, 10218814

     9860769, 10332111, 15896431, 14263036, 10367188, 12830339, 14263073

     9651350, 12586489, 11683713, 14107388, 10097711, 12950644, 10113990

     12370722, 12586491, 12899768, 15896427, 9414040, 14613900, 9373370

     11724916, 13769503, 9578670, 10285022, 10399808, 11877623, 10248523

     12586493, 9972680, 10092858, 12546006, 12797765, 12586487, 13769509

     11830777, 10055063, 10648873, 10419984, 10077191, 11063191, 10220033

     11858315, 11061775, 9478199, 12649442, 12326708, 11708510, 10127360

     11734067, 10396041, 10190642, 13737746, 10396874, 10233732, 10209232

     12595561, 9956835, 11666137, 10061015, 9672816, 11695416, 9744252

     10620808, 9858539, 11694127, 11894889, 9382956, 10204358, 12713993

     10080579, 12764337, 11738259, 10084145, 10363186, 12670165, 10324294

     14107384, 10158493, 10155605, 10013177, 13343424, 11686968, 10013431

     14546575, 12586496, 11674485, 13476583, 9877980, 10126822, 10284570

     10329146, 10326338, 15896429, 11064851, 11063821, 12655433, 10314582

     10051315, 12326246, 10332589, 13467683, 10368698, 12586486, 9724970

     13769507, 11815753, 9905049, 10053725, 12834027, 10229886, 9869287

     9735237, 9896536, 12846268, 9912965, 12794305, 10022980, 14546673

     13503598, 11695285, 12595730, 13399435, 13343244, 14023636, 12371955

     12633340, 13257247, 10039731, 11674898, 13769505, 9824435, 6892311

     11841309, 10031806, 12894807, 11076894, 10170431, 12748240, 9965655

     12323180, 12531263, 10219583, 12417369, 12419331, 9539440, 10622001

     14107385, 10227288, 11867127, 10258337, 11814891, 10228393, 10621169

     9847634, 8547978, 15896435, 10159846, 10142857, 10187168, 10269503

     10395345, 12596444, 9564886, 10373013, 11785938, 10213073, 11827088

     10302581, 12569482, 10278372, 14546638, 9795214, 12397410, 9707965

     9443361, 10210507, 10126094, 10073683, 10172453, 11811073, 10230571

     12419321, 12656535, 10312847, 9943960, 10052141, 12408350, 13250244

     9903826, 12409916, 11056082, 10026601, 12420002, 8685446, 8223165

     9401552, 12780098, 10094823, 11716621, 12589039, 14390377, 10228151

     10623249, 10356513, 12345717, 11057263, 11856395, 11775474, 11670161

     15896433, 11924400, 14841437, 10094201, 10378005, 10115630, 9835264

     10422126, 10021111, 14258925, 11818335, 10281887, 11707302, 10140809

     10317487, 12586488, 10322959, 9727147, 10151017, 13386082, 11706168

     10245086, 14469008, 10205230, 10158965, 11937253, 11733179, 9829397

     10278773, 14107387, 11882425, 10419629, 12586494, 12337012, 12848798

     10388660, 9788588, 10239480, 6523037, 10417716, 9842573, 12879027

     11883472, 12586492, 10200404, 10232083, 12685431, 9881076, 14275621

     10157402, 9709292, 11830778, 14461357, 10207092, 12586490, 11800170

     9683047, 12391602, 14262913, 10417216, 10635701, 9869401, 10157249

     10131867, 13632725, 9970255, 14683459, 13468884, 15896428, 11830776

     10633840, 12976376, 11695333, 10200390, 10142909, 13326736, 10237773

     12366627, 7312717, 10019218, 11664046, 9233544, 12569737, 14107389

     13001379, 13099577, 10222719, 9873405, 11834448, 9819805, 11872103

     10165083, 13769502, 10193846, 10285394, 11715084, 12827726, 9375300

     14040433, 11723722, 10264696, 10264680, 13769508, 11842991, 12845115

     14473913, 9436324, 10358019, 10089333, 14741727, 14038791, 13550185

     10175192, 8672862, 10207551, 9956713, 12639177, 11853815, 14461356

     10180307, 10048701, 12828071, 10079168, 12423475, 13923804, 9771278

     10356782, 14127510, 13769506, 10229719, 12340939, 9966609, 11651810

     14035825, 9078442, 10137324, 13769504, 10219576, 12378147, 10217802

     10142788, 10129643, 12400751, 12539000, 11724984, 9735282, 10040921

     9591812, 9906422, 9746210, 12917230, 9770451, 10021022, 12846269

     10110863, 12579349, 11067567, 10411618, 11699057, 10425676, 13916709

     12635537, 14076523, 11707699, 9895207, 11890804, 10299224, 10018789

     14205448, 9926929, 11800854, 11866952, 14467061, 10384285, 10636231

     11069199, 11689702, 14624146, 10427260, 10324526, 13696224, 12543639

     11690639, 9285259, 10284838, 10082277, 9952554, 9470768, 15896430

     11785390, 10310299, 10412247, 12313857, 12431716, 14107386, 10102506

     10238786, 10132870, 10247152, 9953542, 14727315, 9572787, 15896434

     11800959, 13769510, 10052956, 12374212, 10040531, 15896432, 9681133

     10190172, 11878443, 10040035, 12620422, 10171273, 11893621, 10249791

     11788856, 11664719, 9748749, 13554409, 11889177

 

Patch  13696242     : applied on Sat Feb 16 16:19:11 EST 2013

Unique Patch ID:  14622431

Patch description:  "Grid Infrastructure Patch Set Update : 11.2.0.2.6 (13696242)"

   Created on 2 Apr 2012, 05:03:14 hrs PST8PDT

   Bugs fixed:

     13696242, 10157506, 10178670, 10425672, 12311357, 12419353, 12827731

     13343447, 13653086, 9959110, 10374874, 10272615, 10314123, 10014392

     10089120, 10057296, 11692271, 9864003, 11775080, 13635562, 9916145

     12695202, 12593451, 10044622, 11705438, 10365625, 12767231, 9935308

     12399977, 11882456, 12421404, 12862012, 11744343, 12340700, 10056713

     10637741, 9939306, 9795321, 9902536, 10007185, 10376847, 10038791

     11741224, 12823479, 11655840, 10048487, 10322157, 11768599, 10260251

     10052721, 10028235, 10027079, 12412303, 10357258, 11664015, 11871469

     10045436, 10231906, 12722095, 10622973, 11724464, 9891341, 10072474

     10036834, 10029900, 9974223, 10161846, 10016083, 12597463, 9918485

     11781515, 10040647, 13332363, 12651595, 12345151, 11925641, 10069541

     10029119, 12709476, 10233159, 12332919, 9812956, 10036193, 10015210

     12424479, 12340501, 10621175, 9686152, 12556028, 12605690, 11877079

     8906163, 10111010, 12366642, 11777648, 10115514, 10104377, 10121931

     10057680, 10280665, 10078086, 9944948, 10146768, 10052529, 10011084

     10012319, 10073075, 10233811, 12720728, 10299006, 12426375, 10248739

     10236074, 10128191, 11071429, 10019726, 9975837, 10253630, 12615394

     10420872, 9949676, 11936945, 11820787, 10637483, 13036424, 13396479

     10379703, 12677816, 10157622, 11698552, 10385838, 10053985, 12718811

     10229297, 10425674, 9812970, 11828633, 12538907, 12359585, 11899801

     10083789, 12728585, 9876201, 10073372, 9963327, 10428946, 11077756

     10375649, 12398492, 9336825, 11682409, 10062301, 12767563, 12546712

     10018215, 10105195, 10419987, 13355549, 10071992, 11807012, 10634513

     9926027, 10103954, 12743755, 12406573, 10028343, 12425730, 11768055

     11866171, 10065216, 9907089, 9897335, 10190153, 11744313, 10175855

     12600343, 12422324, 10284828, 10028637, 10361177, 12800501, 9979706

     12950415, 10324594, 10015460, 11818524, 9971646, 11782423, 11654726

     9978765, 10398810, 11904778, 10397652, 13768473, 9915329, 10107380

     10110969, 10305361, 10331452, 10083009, 10631693, 10008467, 10048027

     10040109, 9944978, 10370797, 10033106, 12700217, 11840629, 10042143

     9978195, 10284693, 12639016, 10638381, 11839004, 9679401, 11663339

     10075643, 10057719, 11834289, 9458055, 10205290, 10124517, 12680491

     13334158, 11069614, 10165314, 9593552, 10168006

 

 

 

 

 

 

Rac system comprising of multiple nodes

  Local node = hcs391chprpd301

  Remote node = hcs391chprpd302

 

 

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

 

 

OPatch succeeded.

{code}

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points