What db patches are installed

[thomgreen]

Sorry for the dumb question but... Can anyone tell me how to find out what patches have been istalled?

[davey23uk]

check out your oraInventory - everything (should) go in there

select * from v$version will tell you your latest patch set

[edwardstoever]

When I apply an Oracle patch to our database, a text entry is made into a file by the patch installer program:
ORACLE_HOME:[patches]patches_history.txt;1
--that's VMS notation, for UNIX it would be:
$ORACLE_HOME/patches/patches_history.txt

I am not sure if UNIX/LINUX or windows has a patches_history.txt file.

--Edward Stoever www.database-expert.com

[stmontgo]

Originally posted by edwardstoever
When I apply an Oracle patch to our database, a text entry is made into a file by the patch installer program:
ORACLE_HOME:[patches]patches_history.txt;1
--that's VMS notation, for UNIX it would be:
$ORACLE_HOME/patches/patches_history.txt

I am not sure if UNIX/LINUX or windows has a patches_history.txt file.

--Edward Stoever www.database-expert.com

provided of course you have used the OUI or oracrap...uh humm..excuse me..orapatch