Re: version including the PSU patch level
- From: Jack van Zanen <jack@xxxxxxxxxxxx>
- To: rajendra.pande@xxxxxxx
- Date: Wed, 27 Oct 2010 09:25:04 +1100
When you create a new database from a patched oracle_home there is strictly
speaking no requirement to run the database scripts for the PSU applied to
that home. As a result the registry$history will not have the entry for the
PSU in it.
Our procedure is to always run the database script for the PSU even if not
strictly neccesary. At least than you can query the database for the PSU
applied.
Jack van Zanen
-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation
On Wed, Oct 27, 2010 at 6:37 AM, <rajendra.pande@xxxxxxx> wrote:
> Registry$history
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Terrian, Thomas J Mr
> CTR DLA J6DIB
> Sent: Tuesday, October 26, 2010 3:27 PM
> To: lyallbarbour@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Subject: RE: version including the PSU patch level
>
> Is there any way to do this for an ASM instance...since it doesn't have
> datafiles and all? Any v$ view perhaps?
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of lyallbarbour@xxxxxxxxxxxxxxx
> Sent: Tuesday, October 26, 2010 2:41 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Re: version including the PSU patch level
>
> Check dba_registry_history
>
>
>
>
> -----Original Message-----
> From: Terrian, Thomas J Mr CTR DLA J6DIB <Tom.Terrian.ctr@xxxxxxx>
> To: oracle-l@xxxxxxxxxxxxx
> Sent: Tue, Oct 26, 2010 2:18 pm
> Subject: version including the PSU patch level
>
>
> Does anyone know how to determine the patch level of a database
> including
>
>
> the PSU level. v$version shows 10.2.0.4.0 but I know we applied the PSU
>
>
> 10.2.0.4.4....
>
>
>
>
>
> (I would rather not run opatch lsinventory and then look up the patch
>
>
> number)
>
>
>
>
>
> Thanks,
>
>
> Tom
>
>
>
>
>
>
> Please visit our website at
> http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html
> for important disclosures and information about our e-mail
> policies. For your protection, please do not transmit orders
> or instructions by e-mail or include account numbers, Social
> Security numbers, credit card numbers, passwords, or other
> personal information.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
