With latest version of OPatch:
$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i ‘DATABASE PSU’
or
set lines 255
col action_time for a40
col action for a8
col namespace for a7
col version for a11
col comments for a40
select substr(ACTION_TIME,1,40) action_time,substr(ACTION,1,8) action,substr(NAMESPACE,1,7) namespace,
substr(VERSION,1,11) version,ID,substr(COMMENTS,1,40) comments,BUNDLE_SERIES
from registry$history;
To install latest OPatch, after download (make sure you only have OPatch zip for the correct Oracle version: 10.2, 11.1, 11.2):
- mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch.old
- unzip p6880880* -d $ORACLE_HOME