Re: Installed Version History

Hi,

Granted that you have applied all patchsets in place - you can list the content of the log directory in the inventory.

ls -ltr $ORACLE_BASE/oraInventory/logs

--romas

On 6/20/08, Neil Overend <neiloverend_at_gmail.com> wrote:
>
> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l