Re: Identify CPU/PSU patch
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: "pete@xxxxxxxxxxxxxxxx" <pete@xxxxxxxxxxxxxxxx>
- Date: Mon, 5 Sep 2011 08:38:52 -0700 (PDT)
Thanks Pete. THis will surely good if DB has patch applied or what is applied
in database. Also other Opatch command can provide what is on Software level
________________________________
From: Pete Finnigan <pete@xxxxxxxxxxxxxxxx>
To: smishra_97@xxxxxxxxx
Cc: David Fitzjarrell <oratune@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx"
<oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, September 1, 2011 2:09 PM
Subject: Re: Identify CPU/PSU patch
Both,
DBA_REGISTRY_HISTORY is the proper interface..:-)
cheers
Pete
Sanjay Mishra wrote:
> Thanks David
>
>
>
> ________________________________
> From: David Fitzjarrell <oratune@xxxxxxxxx>
> To: "smishra_97@xxxxxxxxx" <smishra_97@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx"
> <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxxx>
> To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
