RE: Thoughts on patch install wording

From: Patterson, Joel <Joel.Patterson_at_crowley.com>
Date: Fri, 24 Aug 2012 10:42:50 -0400
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA1C753DE3AB_at_JAXMSG01.crowley.com>



Ah yes the fresh install scenario into new home with full software idea.... brings with a short discussion and discovery of how you wish to deal with your possibly new OFA.

I wrestled with this awhile and decide to use a 5 digit home .../product/11.2.0.3.3/dbhome. BTW Notice that I do not use dbhome_1, dbhome_2 as I had no reasons yet. Here is a scenario that helped resolve why.

For instance to go from 11.2.0.1.0 to 11.2.0.3.3 you have to go to 11.2.0.3.0 first. (this means installing 112010 software in /product/11.2.0.3.1 and /product/11.2.0.3.3 and applying 112033 to /product/11.2.0.3.3

This allows you to 'actually upgrade 'one' database at a time (assuming multiple 112010 databases) A database could go to 11.2.0.3.0, and then to 11.2.0.3.3.

Otherwise after the first database goes to 11.2.0.3.3 -- your stuck, because the second database has to go to 11.2.0.3.0 first... so it has to have a place to go....

So in order to have the flexibility to do all of them or one of them from now on... I chose a different home for every version.

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale Sent: Thursday, August 23, 2012 11:08 PM To: Jed_Walker_at_cable.comcast.com
Cc: ORACLE-L
Subject: Re: Thoughts on patch install wording

"upgraded to 11.2.0.1" implies that the RDBMS HOME has been upgraded from 10.x or 9.1

An RDBMS Home is never "upgraded to 11.2.0.x". 11.2.0.x is always a fresh install as an ORACLE_HOME. (although you can do a fresh install of 11.2.0.1 and then upgrade that HOME to 11.2.0.3, the recommendation is that even 11.2.0.3 would be a fresh install).

It is the database that get's upgraded, not the RDBMS HOME.

Very badly worded instructions.

Hemant

On Fri, Aug 24, 2012 at 1:39 AM, Walker, Jed S <Jed_Walker_at_cable.comcast.com
> wrote:

> This will probably be an SR to be sure about it, but I'm wondering if
> anyone has seen this and knows already.
> I have an 11.2.0.3.0 RAC built from scratch as 11.2.0.3.0. I have a
> patch to install (patch 13440962) and the patch says:
>
> # Note: The RDBMS portion can only be applied to an RDBMS home that
> # has been upgraded to *11.2.0.1.0*.
>
> This would lead me to believe I do not want to do the RDBMS portion in
> my case, because I was never at 11.2.0.1.0.
> I'm assuming that means I can't and shouldn't apply it to mine, but
> the wording certainly could be clearer.
> It might also mean, that in my case, if I try to apply it it will just
> fail and say you don't need it, that would be fine.
>
> Has anyone applied this patch and know exactly what they mean?
>
> Thanks,
>
> Jed
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 

Hemant K Chitale
http://hemantoracledba.blogspot.com


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


--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 24 2012 - 09:42:50 CDT

Original text of this message