Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Find out recent CPU and PSU Installed for 9i, 10g and 10g Databases

edited Jul 30, 2012 8:40AM in Database Install/Upgrade/Opatch (MOSC) 3 commentsAnswered
Folks,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center