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



Oracle LazyDBA home page