Re: Running multiple Oracle homes on Windows

From: Paul Drake <bdbafh_at_gmail.com>
Date: Wed, 18 Apr 2012 14:27:56 -0400
Message-ID: <CAPptggXiDWzeq=PQ9RwcL2804og1E=C-Piz+7c5pYv=ys4jLEA_at_mail.gmail.com>

Peter,
This would be more straightforward if you recover the 11.1.0.7 clone out of the 11.1.0.7 home.
Then I'd run the pre-upgrade script and modify the database accordingly. Then I'd remove the 11.1.0.7 service and create a new service in the 11.2.0.3 home, then upgrade.

hth.

Paul

On Wed, Apr 18, 2012 at 2:11 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.completestreets.org/faq.html
http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf


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

Received on Wed Apr 18 2012 - 13:27:56 CDT