Re: Running multiple Oracle homes on Windows

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 18 Apr 2012 19:19:08 +0100
Message-ID: <CABe10sYn8RPdJ9KdXMkb33nL1pvOHrBF18MOEX6D+zsd2ATkfQ_at_mail.gmail.com>

Set the PATH variable and ORACLE_SID The Oracle executables will pick up the env vars from the registry, so you just need them to appear first in the path. Don't set any other env vars.
On Apr 18, 2012 7:16 PM, "Schauss, Peter (ESS)" <peter.schauss_at_ngc.com> wrote:
> This is for Windows 2003 sp2 in case that matters.
>
> I need to upgrade some existing instances from 11.1.0.7 to 11.2.0.3. I
> only have one sever to work with so my high level plan is as follows:
>
> 1. Install the 11.2.0.3 software.
>
> 2. Clone one of the existing 11.1.0.7 instances for testing by editing
> the output of "backup control file to trace" and using ordim to create a
> new Windows service.
>
> 3. Upgrade the test instance.
>
> 4. After appropriate testing, upgrade the production instances.
>
> This plan depends on my being able to control which ORACLE_HOME each
> instance uses. On my UNIX-based servers, /etc/oratab provides this
> function. How do I do this on Windows?
>
> Thanks,
> Peter Schauss
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Wed Apr 18 2012 - 13:19:08 CDT