In Unix, you can use . oraenv to change OH easily, too.

Leonardo M
SP - Brazil.


> Just install ORACLE under a new directory. We do this all the time. We
> have 1 OH for each instance including ASM. If we need to upgrade 1
> instance, we create a new OH apply the patch, change OH and bingo. The
> backout process if the patch fails is easier than doing a file restore of
> the OH.
>
> Yves Leonard,
> Chef de Projet - DBA / Project Leader - ABD,
> DDS / SDD,
> Centre de Technologie d'Oracle / Oracle Technology Center,
> RH Coats, 13-I
> Téléphone / phone : 613-951-3233,
> couriel / email : yves.[Email address protected]
>
>
> -----Original Message-----
> From: pauline [mailto:oracledba-ezmlmshield-x28603318.[Email address
> protected]
> Sent: April 30, 2008 1:56 AM
> To: LazyDBA Discussion
> Subject: more than one ORACLE_HOMES
>
> Hi All,
>
> I want to create different databases of different versions, 10.2.0.2 and
> 10.2.0.3. Do I have to have two different ORACLE_HOMES? I have created the
> second ORACLE_HOME and I have to run root.sh again. My question is: will
> this not over-write the previous ORACLE_HOME??
>
> Guidelines on creating a second ORACLE_HOME, if possible, will be highly
> appreciated.
>
> Regards,
>
> Pauline
>
>
>
> If you are not the intended addressee, please inform us immediately that
> you have received this e-mail in error, and delete it. We thank you for
> your cooperation.
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>



Oracle LazyDBA home page