Find out recent CPU and PSU Installed for 9i, 10g and 10g Databases
I need to figure out recently Installed CPU, PSU for 9i,10g and 11g databases
Are there ways apart from these?
To figure out the CPU
set linesize 90
set pagesize 100
select substr(action_time,1,30) action_time,
substr(id,1,8) id,
substr(action,1,10) action,
substr(version,1,8) version,
substr(comments,1,20) comments
from registry$history;
To figure out PSU
echo $ORACLE_SID
echo $ORACLE_HOME
cd $ORACLE_HOME/OPatch
pwd
./opatch lsinventory -bugs_fixed | egrep -i 'PSU|DATABASE PATCH SET UPDATE'
Regards
Philomin