Re: Identify CPU/PSU patch
Date: Thu, 01 Sep 2011 19:09:40 +0100
Message-ID: <4E5FCA64.2080600_at_petefinnigan.com>
Both,
DBA_REGISTRY_HISTORY is the proper interface..:-)
cheers
Pete
Sanjay Mishra wrote:
> Thanks David
>
>
>
> ________________________________
> From: David Fitzjarrell <oratune_at_yahoo.com>
> To: "smishra_97_at_yahoo.com" <smishra_97_at_yahoo.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> Sent: Wednesday, August 31, 2011 12:48 PM
> Subject: Re: Identify CPU/PSU patch
>
>
> Query REGISTRY$HISTORY for CPU/PSU information for an instance.
>
>
> David Fitzjarrell
>
>
> From: Sanjay Mishra <smishra_97_at_yahoo.com>
> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> Sent: Wednesday, August 31, 2011 9:09 AM
> Subject: Identify CPU/PSU patch
>
>
> Hi
>
>
> Does anyone know what is best way to identify as what CPU/PSU patch is applied to the existing Oracle Software. We have 100's of database servers and some new are added on regular basis. In order to make sure that new database got the CPU or PSU Patch applied and so what is best way to get this details.
>
>
> One way is to get this from Opatch and then take the latest patch number and search with metalink to get idea if this is part of which CPU.PSU patch. This is surely cumbersome or not efficient approach. Also cannot use existing database with existing software as it might be missed to apply the patch in the database.
>
> TIA
> Sanjay
-- Pete Finnigan CEO and Founder PeteFinnigan.com Limited Specialists in database security. Makers of PFCLScan the database security auditing tool. Makers of PFCLObfuscate the tool to protect IPR in your PL/SQL If you need help to audit or secure an Oracle database, please ask for details of our training courses and consulting services Phone: +44 (0)1904 791188 Fax : +44 (0)1904 791188 Mob : +44 (0)7759 277220 email: pete_at_petefinnigan.com site : http://www.petefinnigan.com Registered Office: 9 Beech Grove, Acomb, York, YO26 5LD, United Kingdom Company No : 4664901 VAT No. : 940668114 Please note that this email communication is intended only for the addressee and may contain confidential or privileged information. The contents of this email may be circulated internally within your organisation only and may not be communicated to third parties without the prior written permission of PeteFinnigan.com Limited. This email is not intended nor should it be taken to create any legal relations, contractual or otherwise. -- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 01 2011 - 13:09:40 CDT