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
#######################################################################
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
Nice info, thanks
ReplyDelete