How to check Bundle Patch applies to Exadata Database


oracle@bakuexa1dbadm01:~$ echo $ORACLE_SID
MISLIVE1
oracle@bakuexa1dbadm01:~$ sqlplus "/ as sysdba";
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 22 10:01:47 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> set linesize 1000
SQL> set pagesize 100
SQL> 
SQL> select substr(action_time,1,30) action_time,
 2 substr(id,1,10) id,
 3 substr(action,1,10) action,
 4 substr(version,1,8) version,
 5 substr(BUNDLE_SERIES,1,6) bundle,
 6 substr(comments,1,20) comments
 7 from registry$history;
ACTION_TIME ID ACTION VERSION BUNDLE COMMENTS
------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ---------------------------------------- -------------------------------- ------------------------ --------------------------------------------------------------------------------
27-NOV-14 05.25.44.591587 PM 0 APPLY 11.2.0.3 PSU Patchset 11.2.0.2.0
27-NOV-14 06.09.31.966719 PM 25 APPLY 11.2.0.3 EXA BP25
SQL> 
SQL> 
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
oracle@bakuexa1dbadm01:~$
Advertisements

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

%d bloggers like this: