RE: Running multiple Oracle homes on Windows

From: Uzzell, Stephan <SUzzell_at_MICROS.COM>
Date: Wed, 18 Apr 2012 18:18:05 +0000
Message-ID: <DF78EADE484D37419A53F5C898629DB703FFA44C_at_USMAIL2K1001.us.micros.int>

If you SET ORACLE_HOME=<new 11.2.0.3 home> and then you run oradim from %ORACLE_HOME%\bin, that will control which home the instance runs from...

Stephan Uzzell

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter (ESS) Sent: Wednesday, 18 April, 2012 14:12
To: oracle-l_at_freelists.org
Subject: Running multiple Oracle homes on Windows

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:18:05 CDT