How to check which PSU is installed…if any

Oracle PSUs (Patch Set Updates) are referenced by their 5-place version number.  Unfortunately they do not change version numbers in the Oracle binaries, product banners and such though (see MOS 861152.1), so here’s how to identify which PSU your ORACLE_HOME is at…

Database Server:

$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i -E 'DATABASE PSU|DATABASE PATCH SET UPDATE'
$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | egrep -i 'DATABASE PSU|DATABASE PATCH SET UPDATE'

(The first command above being for Linux)

…or using the following SQL:

select comments, version, bundle_series
from sys.registry$history
where bundle_series = 'PSU'
order by action_time;

COMMENTS                       VERSION                        BUNDLE_SERIES
------------------------------ ------------------------------ -----------------
Patchset 11.2.0.2.0            11.2.0.3                       PSU
PSU 11.2.0.3.5                 11.2.0.3                       PSU

The above view is populated when catbundle.sql is executed.  If the query above ends with “ORA-00904: “BUNDLE_SERIES”: invalid identifier” then no bundle patch (PSU or CPU) has been applied.

Grid Infrastructure:

$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i 'GI PSU'

Cluster Ready Services:

$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i 'TRACKING BUG' | grep -i 'PSU'

Enterprise Manager Agent:

$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i 'ENTERPRISE MANAGER AGENT' | grep -i 'PSU'

Enterprise Manager OMS:

$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i 'ENTERPRISE MANAGER OMS' | grep -i 'PSU'

WebLogic Server:

. $WLS_HOME/server/bin/setWLSEnv.sh
java weblogic.version|grep PSU

5 thoughts on “How to check which PSU is installed…if any

  1. Unfortunately this will not work for 11.2.0.4.6

    Is able to grep till 11.2.0.4.5, again deviation from standard. ugh. Even though 11.2.0.4.6 is installed. Oh well such is life

    $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | egrep -i ‘DATABASE PSU|DATABASE PATCH SET UPDATE’
    19769489 19769489 Thu May 14 13:25:36 EDT 2015 DATABASE PATCH SET UPDATE 11.2.0.4.5 (INCLUDES CPU
    19121551 19121551 Thu May 14 13:25:10 EDT 2015 DATABASE PATCH SET UPDATE 11.2.0.4.4 (INCLUDES CPU
    18522509 18522509 Fri Nov 14 15:06:27 EST 2014 DATABASE PATCH SET UPDATE 11.2.0.4.3 (INCLUDES CPU
    18031668 18031668 Fri Nov 14 15:05:56 EST 2014 DATABASE PATCH SET UPDATE 11.2.0.4.2 (INCLUDES CPU
    17478514 17478514 Fri Nov 14 15:05:24 EST 2014 DATABASE PATCH SET UPDATE 11.2.0.4.1 (INCLUDES CPU

Leave a comment

Your email address will not be published. Required fields are marked *