Oracle Database: Find CPU or PSU Patch History

From Ittichai Chammavanijakul's Wiki
Jump to: navigation, search
  • 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