Oracle Database Discussions

Hello Gurus,

Is there any way to find out which cpu patch is applied on database server ?

Output of select from registry$history :*

sql> select * from registry$history;

ACTION_TIME
---------------------------------------------------------------------------
ACTION NAMESPACE VERSION
------------------------------ ------------------------------ ------------------------------
ID
----------
COMMENTS
----------------------------------------------------------------------------------------------------
22-AUG-07 02.18.53.701711 PM
UPGRADE SERVER 10.2.0.3.0

Upgraded from 10.2.0.2.0


Output of opatch lsinventory

Invoking OPatch 10.2.0.3.0

Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..


Oracle Home : /u01/app/oracle/product/10.2.0
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /u01/app/oracle/product/10.2.0/oui
Log file location : /u01/app/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2009-04-21_09-24-53AM.log

Lsinventory Output file location : /u01/app/oracle/product/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory2009-04-21_09-24-53AM.txt

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

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0
There are 2 products installed in this Oracle Home.


Interim patches (22) :

Patch 6375952 : applied on Mon Mar 17 18:28:31 GMT+01:00 2008
Created on 28 Sep 2007, 15:37:38 hrs PST8PDT
Bugs fixed:
6375952

Patch 6069085 : applied on Sun Mar 02 18:13:16 GMT+01:00 2008
Created on 25 Oct 2007, 22:54:52 hrs US/Pacific
Bugs fixed:
4684070, 6069085, 5190392

Patch 6069074 : applied on Sun Mar 02 18:13:10 GMT+01:00 2008
Created on 14 Jun 2007, 06:11:35 hrs US/Pacific
Bugs fixed:
6069074, 5677680, 5584790, 5770059

Patch 5744428 : applied on Sun Mar 02 18:12:56 GMT+01:00 2008
Created on 14 Jun 2007, 06:07:38 hrs US/Pacific
Bugs fixed:
5744428

Patch 5472702 : applied on Sun Mar 02 18:12:51 GMT+01:00 2008
Created on 14 Jun 2007, 06:07:00 hrs US/Pacific
Bugs fixed:
5472702

Patch 5287523 : applied on Sun Mar 02 18:12:45 GMT+01:00 2008
Created on 14 Jun 2007, 06:05:20 hrs US/Pacific
Bugs fixed:
5287523

Patch 6010833 : applied on Sun Mar 02 18:09:03 GMT+01:00 2008
Created on 22 Jun 2007, 02:29:22 hrs US/Pacific
Bugs fixed:
6010833

Patch 5998544 : applied on Sun Mar 02 18:08:57 GMT+01:00 2008
Created on 22 Jun 2007, 02:25:59 hrs US/Pacific
Bugs fixed:
5238386, 5934150, 4690705, 4538727, 5998544, 5399901, 5951587, 5089522

Patch 5844945 : applied on Sun Mar 02 18:08:45 GMT+01:00 2008
Created on 22 Jun 2007, 02:28:39 hrs US/Pacific
Bugs fixed:
5844945

Patch 5209867 : applied on Sun Mar 02 18:08:38 GMT+01:00 2008
Created on 22 Jun 2007, 02:27:14 hrs US/Pacific
Bugs fixed:
5209867

Patch 6607968 : applied on Sun Mar 02 17:45:29 GMT+01:00 2008
Created on 14 Nov 2007, 03:22:55 hrs PST8PDT
Bugs fixed:
5640593, 5093060, 6607968

Patch 6500033 : applied on Sun Mar 02 17:42:03 GMT+01:00 2008
Created on 13 Nov 2007, 10:19:47 hrs PST8PDT
Bugs fixed:
6500033

Patch 6267873 : applied on Sun Mar 02 17:35:48 GMT+01:00 2008
Created on 7 Feb 2008, 04:26:52 hrs PST8PDT
Bugs fixed:
5723260, 6067600, 6267873, 5575674, 5370578, 5883622, 6017440, 6064864
5087369, 5865842, 5602452, 5581472, 5206649, 5225733, 5170394, 5512840
5515703, 5867943

Patch 6043052 : applied on Sun Mar 02 17:33:28 GMT+01:00 2008
Created on 24 Sep 2007, 21:04:29 hrs PST8PDT
Bugs fixed:
6043052

Patch 5857313 : applied on Sun Mar 02 17:10:49 GMT+01:00 2008
Created on 5 Nov 2007, 05:25:04 hrs PST8PDT
Bugs fixed:
5857313

Patch 5623403 : applied on Sun Mar 02 17:05:36 GMT+01:00 2008
Created on 28 Sep 2007, 15:30:46 hrs PST8PDT
Bugs fixed:
5623403

Patch 5201883 : applied on Sun Mar 02 17:00:06 GMT+01:00 2008
Created on 23 Apr 2007, 23:28:22 hrs PST8PDT
Bugs fixed:
5201883

Patch 5029334 : applied on Sun Mar 02 16:54:20 GMT+01:00 2008
Created on 13 Jul 2007, 05:37:35 hrs US/Pacific
Bugs fixed:
5029334

Patch 4475206 : applied on Sun Mar 02 16:44:04 GMT+01:00 2008
Created on 6 Nov 2007, 09:02:16 hrs PST8PDT,M3.2.0,M11.1.0
Bugs fixed:
4475206

Patch 5728380 : applied on Fri Sep 21 13:56:57 GMT+01:00 2007
Created on 25 Jul 2007, 02:24:32 hrs PST8PDT
Bugs fixed:
5728380

Patch 5556081 : applied on Wed Aug 22 15:21:54 GMT+01:00 2007
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081

Patch 5557962 : applied on Wed Aug 22 15:17:01 GMT+01:00 2007
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974

I am confused with output of registry$history and opatch lsinventory.

Any kind of help is very beneficial for me.


Thanks in advance.

Edited by: user7632087 on Apr 21, 2009 2:07 AM