Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 20463 invoked from network); 20 Jun 2008 07:01:40 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 20 Jun 2008 07:01:40 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B7C08862F99; Fri, 20 Jun 2008 08:01:40 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11394-03; Fri, 20 Jun 2008 08:01:40 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2DF3E862F7C; Fri, 20 Jun 2008 08:01:40 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 20 Jun 2008 07:59:25 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 729B2862ABF for ; Fri, 20 Jun 2008 07:59:25 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11041-03 for ; Fri, 20 Jun 2008 07:59:25 -0400 (EDT) Received: from rv-out-0708.google.com (rv-out-0708.google.com [209.85.198.250]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 398B0862F5F for ; Fri, 20 Jun 2008 07:59:24 -0400 (EDT) Received: by rv-out-0708.google.com with SMTP id b17so6424207rvf.46 for ; Fri, 20 Jun 2008 04:59:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type:content-transfer-encoding :content-disposition; bh=r7yDvzcKoS5BntSO7wXQGrCX9SyzhvIVKhQI68vvf8A=; b=rSMbFPA3BuOhxye988Nvfc+shyv5trqYKvJzPYWE/zSPmy1SiRUspr3/cYuZ/7gpoP jHRbakDDebvhEiJC9tkLVhpx/EkiuIPO83iMK1E65j4TIBBErp4WUfgoiR0DpfgYzkJd JOvvQk1rGPvlEoP8OYOO5EUV2SFiilBYhaU4M= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type :content-transfer-encoding:content-disposition; b=ofnEMVyPtl0heDjP/DhX33MLolPCmBuqBChfHKl8K4h+c5WdoZVBWQ+JXDG81hcQXN 719kNqZF1KaHTCqhgiqeFVIhhmasky4SAry0ivmbKtNgZ9Zj8TNs517QGdtaICQGSVK/ CYnFjAku/IaAuKO8KgnKsvXAeTVQnAuIsvnW4= Received: by 10.140.164.1 with SMTP id m1mr7410474rve.266.1213963164417; Fri, 20 Jun 2008 04:59:24 -0700 (PDT) Received: by 10.140.186.18 with HTTP; Fri, 20 Jun 2008 04:59:24 -0700 (PDT) Message-ID: <5acbeade0806200459v5619309fybd7d74248c0a7c91@mail.gmail.com> Date: Fri, 20 Jun 2008 12:59:24 +0100 From: "Neil Overend" To: "Oracle-L Freelists" Subject: Installed Version History MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline X-archive-position: 8970 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: neiloverend@gmail.com Precedence: normal Reply-to: neiloverend@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain We've got the auditors in this week and I need to provide a list of what oracle patches were applied and when they were applied. I can do 'opatch lsinventory -all' which is good for interim patches (see below) but for the base install (10.2.0.1) and 10.2.0.3 patchset there are no dates. Does anyone know how to prove to the auditors when the (2) products were installed ? I've also got to do this for some 9.2.0.8 databases (Windows and Linux). We've got documentary evidence of when we did the changes but they want to check these against some actual evidence from the servers. Installed Top-level Products (2): Oracle Database 10g 10.2.0.1.0 Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0 There are 2 products installed in this Oracle Home. Interim patches (3) : Patch 5648872 : applied on Fri Mar 23 10:33:50 GMT 2007 Created on 19 Mar 2007, 22:03:23 hrs PST8PDT Bugs fixed: 5648872 Patch 5556081 : applied on Wed Dec 06 13:05:33 GMT 2006 Created on 9 Nov 2006, 22:20:50 hrs PST8PDT Bugs fixed: 5556081 Patch 5557962 : applied on Wed Dec 06 13:05:25 GMT 2006 Created on 9 Nov 2006, 23:23:06 hrs PST8PDT Bugs fixed: 4269423, 5557962, 5528974 Rgds Neil -- http://www.freelists.org/webpage/oracle-l