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
No comments:
Post a Comment