Re: Oracle patch levels

Thanks Niall,

I have looked on solaris and its in <inventory>/logs/installActions.log. I have not applied any patches to the database i have here and i have checked the file and it shows the 5 digit levels for every component installed. Looks like this will be the best I can get.

Thanks again

cheers

Pete

In article <3d5263e7$0$12039$ed9e5944_at_reading.news.pipex.net>, Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> writes
>ON NT at least (but probably *nix as well) <inventory directory>
>InstallActions.log ends with a listing of the current patch levels for each
>component (in mind numbing detail).
>
>
>--
>Niall Litchfield
>Oracle DBA
>Audit Commission UK
>*****************************************
>Please include version and platform
>and SQL where applicable
>It makes life easier and increases the
>likelihood of a good answer
>
>******************************************
>"Pete Finnigan" <pete_at_peterfinnigan.demon.co.uk> wrote in message
>news:BXt4G8A4YlU9Ew8c_at_peterfinnigan.demon.co.uk...
>> Hi
>>
>> I am writing the step-by-step guide to securing Oracle for the SANS
>> Institute and one of the actions I have added to the pre-amble section
>> of the book is to find and record OS, and Oracle versions and patch
>> levels. I have searched the documentation and also this groups archive
>> and although this question seems to have been asked a number of times I
>> have not found an answer that defines how to tell exactly which patches
>> are applied.
>>
>> I understand that the 4th digit shown in the version number from
>> v$version shows the patch level, although I have seen that this is not
>> always updated when patches are applied from personal experience.
>>
>> The question is to everyone, is there a way to find out exactly which
>> patches have been applied and if so how?, is it stored in the inventory
>> somewhere? or in an OS file somewhere, that I could query.
>>
>> Thanks in advance.
>>
>> kind regards
>>
>> Pete
>> --
>> Pete Finnigan
>>
>> pete_at_peterfinnigan.demon.co.uk
>> pete_at_petefinnigan.com
>>
>>
>
>

-- 
Pete Finnigan

pete_at_peterfinnigan.demon.co.uk
pete_at_petefinnigan.com

http://online.securityfocus.com/infocus/1522 - "A simple Oracle Security
Scanner"