How to check Bundle Patch applies to Exadata Database


oracle@anarexadatatest:~$ echo $ORACLE_SID

ANARLIVE1

oracle@anarexadatatest:~$ 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@anarexadatatest:~$

 

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: