7 Replies Latest reply: Sep 12, 2012 12:24 PM by SureshReddy RSS

    DB version is  not reflecting after patching from 11.2.0.3.0 to 11.2.0.3.3

    SureshReddy
      we have applied the patch 13923374 to current oracle 11.2.0.3.0 installed , running on linux x86 32 bit server,
      the patch got installed successfully and the post installation step to execute the catbundle script is also performed.


      But stil wen we login to database , the db shows 11.2.0.3.0, and the registry history shows as below,



      SQL> select BUNDLE_SERIES,ACTION ,NAMESPACE,VERSION,ID,COMMENTS from registry$history;


      BUNDLE_SERIES ACTION NAMESPACE VERSION ID COMMENTS
      ------------------------------ ---------- ------------------------------ -------------------- ----- ------------------------------
      PSU APPLY SERVER 11.2.0.3 0 Patchset 11.2.0.2.0
      PSU APPLY SERVER 11.2.0.3 0 Patchset 11.2.0.2.0
      PSU APPLY SERVER 11.2.0.3 3 PSU 11.2.0.3.3

      SQL>



      and the out put of opatch inventory is as below.

      please let me know how do i confirm the patch is installed & db is in 11.2.0.3.3 and not 11.2.0.3.0.



      [oracle@localtesting OPatch]$ opatch lsinventory
      Oracle Interim Patch Installer version 11.2.0.3.0
      Copyright (c) 2012, Oracle Corporation. All rights reserved.


      Oracle Home : /u01/oracle/oracle/product/11.2.0/dbhome_1
      Central Inventory : /u01/oracle/oraInventory
      from : /u01/oracle/oracle/product/11.2.0/dbhome_1/oraInst.loc
      OPatch version : 11.2.0.3.0
      OUI version : 11.2.0.3.0
      Log file location : /u01/oracle/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-09-12_01-59-51AM_1.log

      Lsinventory Output file location : /u01/oracle/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2012-09-12_01-59-51AM.txt

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

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


      Interim patches (1) :

      Patch 13923374 : applied on Wed Sep 12 00:54:47 IST 2012
      Unique Patch ID: 14858653
      Patch description: "Database Patch Set Update : 11.2.0.3.3 (13923374)"
      Created on 14 Jun 2012, 19:31:29 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



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

      OPatch succeeded.
      [oracle@localtesting OPatch]$



      please let me know how do i confirm the patch is installed & db is in 11.2.0.3.3 and not 11.2.0.3.0.


      Thanks in advance.

      CTE