Amazon books

Tuesday, March 5, 2013

How to check Bundle Patch applies to Exadata Database

Query below can be used to check in which Bundle Patch (BP)  your Exadatabase Database is running.

#######################################################################
select substr(action_time,1,30) action_time,
  substr(id,1,10) id,
  substr(action,1,10) action,
  substr(version,1,8) version,
  substr(BUNDLE_SERIES,1,6) bundle,
  substr(comments,1,20) comments
from registry$history;

ACTION_TIME                     ID                                       ACTION     VERSION    BUNDLE                         COMMENTS
------------------------------- ---------------------------------------- ---------- ---------- ------------------------------ --------------------
26-DEC-12 04.04.43.992511 PM    0                                        APPLY      11.2.0.3   PSU                            Patchset 11.2.0.2.0
31-JAN-13 10.06.31.615873 PM    14                                       APPLY      11.2.0.3   EXA                            BP14
#######################################################################

Best Regards,
Paulo Portugal

1 comment: