Path: news.easynews.com!easynews!cyclone2.usenetserver.com!news.webusenet.com!newsfeed.icl.net!newsfeed.fjserv.net!diablo.theplanet.net!newspeerenv1.svr.pol.co.uk!newsfeed.wirehub.nl!bnewspeer00.bru.ops.eu.uu.net!bnewsifeed00.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server References: Subject: Re: Oracle patch levels Date: Thu, 8 Aug 2002 13:28:22 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 50 Message-ID: <3d5263e7$0$12039$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: host9.audit-commission.gov.uk X-Trace: 1028809703 reading.news.pipex.net 12039 193.128.236.219 X-Complaints-To: abuse@uk.uu.net Xref: easynews comp.databases.oracle.server:157259 X-Received-Date: Thu, 08 Aug 2002 05:25:28 MST (news.easynews.com) ON NT at least (but probably *nix as well) 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" 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 > >