Friday, April 20, 2012

DBA_REGISTRY_HISTORY IS SHOWING 11.2.0.20 FOR THE COMMENT COLUMN FOR 11.2.0.3


DBA_REGISTRY_HISTORY IS SHOWING 11.2.0.20  FOR THE COMMENT COLUMN FOR 11.2.0.3

After upgrading from 11.2.0.2se to 11.2.0.3se, DBA_REGISTRY_HISTORY shows Patchset 11.2.0.2.0 for 11.2.0.3. For example:
select * from dba_registry_history order by action_time;
ACTION_TIME
ACTION
NAMESPACE
VERSION
ID
BUNDLE_SERIES
COMMENTS
2007-04-27 1:24:06.000000 PM
CPU
SERVER
10.2.0.2.0
5689957

CPUJan2007
2009-05-23 2:38:48.000000 AM
UPGRADE
SERVER
10.2.0.4.0


Upgraded from 10.2.0.2.0
2011-11-10 12:31:30.905842 PM
VIEW INVALIDATE


8289601

view invalidation
2011-11-10 12:31:31.708360 PM
UPGRADE
SERVER
11.2.0.3.0


Upgraded from 10.2.0.4.0
2011-11-10 12:59:23.315431 PM
APPLY
SERVER
11.2.0.3
0
PSU
Patchset 11.2.0.2.0

Oracle has confirmed that it is a bug (Bug 13360611).
DBA_REGISTRY_HISTORY provides information about upgrades, downgrades, and critical patch updates that have been performed on the database.
Column
Datatype
NULL
Description
ACTION_TIME
TIMESTAMP(6)

The time the upgrade, downgrade, or patch action was completed
ACTION
VARCHAR2(30)

The specific action (for example, UPGRADE or DOWNGRADE)
NAMESPACE
VARCHAR2(30)

The namespace of the components affected (for example, SERVER)
VERSION
VARCHAR2(30)

The version number of the server (for example, 10.2.0.1.0)
ID
NUMBER

The identification number of the Critical Patch Update
COMMENTS
VARCHAR2(255)

Additional comments about the action taken


No comments:

Post a Comment