Just a quick note to show patch history.
No history just yet until catbunble.sql has been executed.
SQL> @pr 'select * from DBA_REGISTRY_HISTORY'; ============================== PL/SQL procedure successfully completed.
Executing catbundle.sql
SQL> @?/rdbms/admin/catbundle.sql psu apply ... SQL> SPOOL off SQL> SET echo off Check the following log file for errors: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_HA01_APPLY_2012Sep04_11_15_44.log SQL> @pr 'select * from DBA_REGISTRY_HISTORY'; ============================== ACTION_TIME : 04-SEP-12 11.16.55.741436 AM ACTION : APPLY NAMESPACE : SERVER VERSION : 11.2.0.3 ID : 3 BUNDLE_SERIES : PSU COMMENTS : PSU 11.2.0.3.3 ============================== PL/SQL procedure successfully completed.
Some more examples:
SQL> @pr 'select * from DBA_REGISTRY_HISTORY order by action_time desc'; ============================== ACTION_TIME : 13-MAY-12 08.39.12.947464 PM ACTION : APPLY NAMESPACE : SERVER VERSION : 11.2.0.3 ID : 0 BUNDLE_SERIES : PSU COMMENTS : Patchset 11.2.0.2.0 ============================== ACTION_TIME : 13-MAY-12 08.38.28.893140 PM ACTION : UPGRADE NAMESPACE : SERVER VERSION : 11.2.0.3.0 ID : BUNDLE_SERIES : COMMENTS : Upgraded from 11.2.0.2.0 ============================== ACTION_TIME : 13-MAY-12 08.38.16.903012 PM ACTION : VIEW INVALIDATE NAMESPACE : VERSION : ID : 8289601 BUNDLE_SERIES : COMMENTS : view invalidation ============================== ACTION_TIME : 11-DEC-10 09.23.47.556462 PM ACTION : APPLY NAMESPACE : SERVER VERSION : 11.2.0.2 ID : 0 BUNDLE_SERIES : PSU COMMENTS : Patchset 11.2.0.2.0 ============================== ACTION_TIME : 11-DEC-10 09.21.30.935646 PM ACTION : UPGRADE NAMESPACE : SERVER VERSION : 11.2.0.2.0 ID : BUNDLE_SERIES : COMMENTS : Upgraded from 10.2.0.4.0 ============================== ACTION_TIME : 11-DEC-10 09.21.19.113562 PM ACTION : VIEW INVALIDATE NAMESPACE : VERSION : ID : 8289601 BUNDLE_SERIES : COMMENTS : view invalidation ============================== ACTION_TIME : 05-OCT-08 07.32.45.614748 PM ACTION : UPGRADE NAMESPACE : SERVER VERSION : 10.2.0.4.0 ID : BUNDLE_SERIES : COMMENTS : Upgraded from 10.2.0.3.0 ============================== ACTION_TIME : 10-MAY-08 07.15.22.132383 PM ACTION : CPU NAMESPACE : SERVER VERSION : 10.2.0.3.0 ID : 6864068 BUNDLE_SERIES : COMMENTS : CPUApr2008 ============================== ACTION_TIME : 20-MAY-07 07.35.03.588584 PM ACTION : UPGRADE NAMESPACE : SERVER VERSION : 10.2.0.3.0 ID : BUNDLE_SERIES : COMMENTS : Upgraded from 10.2.0.2.0 ============================== PL/SQL procedure successfully completed.
