Path: news.easynews.com!easynews!newshosting.com!news-xfer1.atl.newshosting.com!btnet-peer0!btnet!kibo.news.demon.net!news.demon.co.uk!demon!peterfinnigan.demon.co.uk!pete
From: Pete Finnigan <pete@peterfinnigan.demon.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle patch levels
Date: Thu, 8 Aug 2002 15:58:28 +0100
Organization: www.petefinnigan.com
Message-ID: <GaWp1yAUcoU9Ewth@peterfinnigan.demon.co.uk>
References: <BXt4G8A4YlU9Ew8c@peterfinnigan.demon.co.uk>
 <3d5263e7$0$12039$ed9e5944@reading.news.pipex.net>
NNTP-Posting-Host: peterfinnigan.demon.co.uk
X-NNTP-Posting-Host: peterfinnigan.demon.co.uk:212.228.17.70
X-Trace: news.demon.co.uk 1028818776 nnrp-08:23257 NO-IDENT peterfinnigan.demon.co.uk:212.228.17.70
X-Complaints-To: abuse@demon.net
MIME-Version: 1.0
X-Newsreader: Turnpike Integrated Version 5.01 S <ii6xnv5+bmXUulcu5AzBmAM5$X>
Lines: 75
Xref: easynews comp.databases.oracle.server:157274
X-Received-Date: Thu, 08 Aug 2002 08:09:07 MST (news.easynews.com)

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@reading.news.pipex.net>, Niall
Litchfield <n-litchfield@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@peterfinnigan.demon.co.uk> wrote in message
>news:BXt4G8A4YlU9Ew8c@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@peterfinnigan.demon.co.uk
>> pete@petefinnigan.com
>>
>>
>
>

-- 
Pete Finnigan

pete@peterfinnigan.demon.co.uk
pete@petefinnigan.com

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