I can't speak for Charles, but sometimes this is a sensible idea in the event of wishing to roll back an upgrade, or more generally when you have multiple database applications on the same server, then the slowest/most difficult to update doesn't hold everyone back. . On Wed, Aug 26, 2009 at 5:40 AM, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote: > We do not have separate homes. > I install 10.2.0.3 in oracle/product/10.2.0 and I upgrade this home and the > database when I move to 10.2.0.4. > Patch level also goes into this home. > > Why do you use 3 homes? > > Adar Yechiel > Rechovot, Israel > > > > Taylor, Chris David wrote: > > Ultimately I knew it wasn't like this but I was hoping it was. > > How do you guys setup your Oracle homes for different versions? I had > originally wanted to do something like \oracle\product\10.2.0.4.24\db_1 for > upgraded homes, but decided against it. > > So now I have > \oracle\product\10.2.0\db_1 (10.2.0.2) > \oracle\product\10.2.0\db_2 (10.2.0.4 Patch 7) > \oracle\product\10.2.0\db_3 (10.2.0.4 Patch 24) > > > -- Niall Litchfield Oracle DBA http://www.orawin.info