Difference between revisions of "Oracle Database: Find CPU or PSU Patch History"

From Ittichai Chammavanijakul's Wiki
Jump to navigation Jump to search
(Created page with "* Check the COMMENTS column of the registry$history which will get updated after the post-patch step (catbundle.sql) ran. <pre> col ACTION_TIME format a30 col ACTION format a10 c...")
 
 
(No difference)

Latest revision as of 17:04, 9 August 2013

  • Check the COMMENTS column of the registry$history which will get updated after the post-patch step (catbundle.sql) ran.
col ACTION_TIME format a30
col ACTION format a10
col NAMESPACE format a10
col VERSION format A15
col BUNDLE_SERIES format a8
col COMMENTS format a30
set lines 120
select ACTION_TIME, ACTION, NAMESPACE, VERSION,BUNDLE_SERIES, COMMENTS
from sys.registry$history
order by ACTION_TIME;

ACTION_TIME                    ACTION     NAMESPACE  VERSION         BUNDLE_S COMMENTS
------------------------------ ---------- ---------- --------------- -------- ------------------------------
25-JUN-12 11.58.27.818024 PM   UPGRADE    SERVER     11.1.0.7.0               Upgraded from 11.1.0.7.0
26-JUN-12 07.06.06.048184 AM   UPGRADE    SERVER     11.1.0.7.0               Upgraded from 11.1.0.7.0
17-FEB-13 09.46.01.324012 AM   APPLY      SERVER     11.1.0.7        PSU      PSU 11.1.0.7.12