2 Replies Latest reply: Aug 27, 2012 12:45 PM by 737281 RSS

    Confirm whether patch has been applied or not

    user10697869
      Hi,

      I have applied patch to my RAC env.(11.2.0.3.0 to 11.2.0.3.3)

      the output of opatch lsinventory is the following... is this sufficient proof that patch that patch has been successful...


      Oracle Interim Patch Installer version 11.2.0.3.0
      Copyright (c) 2012, Oracle Corporation. All rights reserved.


      Oracle Home : /u01/11.2.0/grid
      Central Inventory : /u01/app/oraInventory
      from : /u01/11.2.0/grid/oraInst.loc
      OPatch version : 11.2.0.3.0
      OUI version : 11.2.0.3.0
      Log file location : /u01/11.2.0/grid/cfgtoollogs/opatch/opatch2012-08-19_23-30-16PM_1.log

      Lsinventory Output file location : /u01/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2012-08-19_23-30-16PM.txt

      --------------------------------------------------------------------------------
      Installed Top-level Products (1):

      Oracle Grid Infrastructure 11.2.0.3.0
      There are 1 products installed in this Oracle Home.


      Interim patches (2) :

      Patch 13923374 : applied on Sun Aug 19 23:17:37 EDT 2012
      Unique Patch ID: 14849164
      Patch description: "Database Patch Set Update : 11.2.0.3.3 (13923374)"
      Created on 13 Jun 2012, 00:02:44 hrs PST8PDT
      Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
      Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
      Bugs fixed:
      13419660, 10350832, 13632717, 14063281, 12919564, 13467683, 13588248
      13420224, 12646784, 12861463, 12834027, 13036331, 12880299, 13499128
      12998795, 13492735, 12829021, 13503598, 10133521, 12718090, 13742433
      12905058, 12401111, 13742434, 12849688, 13362079, 12950644, 13742435
      12917230, 13923374, 12879027, 12535346, 12588744, 11877623, 13916709
      12847466, 13340388, 13528551, 13366202, 12894807, 13981051, 13343438
      12582664, 12748240, 12797765, 12923168, 13466801, 13772618, 11063191
      13070939, 13035804, 12797420, 13041324, 12976376, 13742437, 14062795
      13035360, 13742438, 13326736, 13332439, 14038787, 14062796, 12913474
      13001379, 13370330, 14062797, 13742436, 9873405, 14062794, 9858539
      12960925, 12662040, 9703627, 12617123, 13338048, 12938841, 12658411
      12620823, 12656535, 12845115, 14062793, 12764337, 12678920, 13354082
      14062792, 12612118, 9761357, 13742464, 13457582, 13527323, 12780983
      12780098, 13502183, 13696216, 11840910, 13903046, 13554409, 13657605
      13103913, 14063280

      Patch 13919095 : applied on Sun Aug 19 23:14:36 EDT 2012
      Unique Patch ID: 14849164
      Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.3 (13919095)"
      Created on 25 Jun 2012, 22:06:05 hrs PST8PDT
      Bugs fixed:
      13919095, 13696251, 13348650, 12659561, 13039908, 13036424, 12794268
      13011520, 13569812, 12758736, 13077654, 13001901, 13430715, 13806545
      14082976, 12771830, 12538907, 13066371, 13483672, 12594616, 12897651
      12897902, 13241779, 12896850, 12726222, 12829429, 12728585, 13079948
      12876314, 13090686, 12925041, 12995950, 13251796, 12650672, 12398492
      12848480, 13652088, 12990582, 13857364, 12975811, 12917897, 13082238
      12947871, 13037709, 13371153, 12878750, 10114953, 11772838, 13058611
      13001955, 11836951, 12965049, 13440962, 12765467, 13425727, 12885323
      13339443, 12784559, 13332363, 13074261, 12971251, 13811209, 12709476
      12857064, 13719731, 13396284, 12899169, 13111013, 12867511, 12639013
      12959140, 13085732, 12829917, 12934171, 12849377, 12349553, 12680491
      12914824, 13789135, 12730342, 13334158, 12950823, 13355963, 13531373
      13776758, 12720728, 13620816, 13002015, 13024624, 12791719, 13886023
      13255295, 13821454, 12782756, 12873909, 12914722, 13243172, 12842804
      13045518, 12765868, 12772345, 13345868, 14059576, 13683090, 12932852
      12695029, 13146560, 13038806, 13396356, 13258062, 12834777, 12996572
      13941934, 13657366, 13019958, 12810890, 13502441, 13726162, 13880925
      13506114, 12820045, 13604057, 12823838, 12823042, 13582706, 13617861
      12825835, 13263435, 13025879, 13853089, 13410987, 13570879, 13637590
      12827493, 13247273, 13068077



      Rac system comprising of multiple nodes
      Local node = proddb1
      Remote node = proddb2

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

      OPatch succeeded.


      ----
      Also, resitry$history shows the following..

      ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDLE_SERIES
      ------------------------------ ---------- ---------- ------------------------------ ---------- -------------------- ------------------------------
      17-SEP-11 10.21.11.595816 AM APPLY SERVER 11.2.0.3 0 Patchset 11.2.0.2.0 PSU
      26-MAR-12 06.25.10.400287 PM APPLY SERVER 11.2.0.3 0 Patchset 11.2.0.2.0 PSU
      19-AUG-12 11.28.45.290355 PM APPLY SERVER 11.2.0.3 3 PSU 11.2.0.3.3 PSU


      is this fine??

      please confirm..

      Thanks in advance..