Thinking Out Loud

September 5, 2012

Patch History – DBA_REGISTRY_HISTORY

Filed under: 11g,oracle — mdinh @ 4:15 am

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.
About these ads

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 313 other followers

%d bloggers like this: