This discussion is archived
7 Replies Latest reply: Sep 12, 2012 10:24 AM by SureshReddy RSS

DB version is  not reflecting after patching from 11.2.0.3.0 to 11.2.0.3.3

SureshReddy Newbie
Currently Being Moderated
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

Legend

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