Re: Running multiple Oracle homes on Windows

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Wed, 18 Apr 2012 12:43:26 -0700 (PDT)
Message-ID: <1334778206.36039.YahooMailNeo_at_web160902.mail.bf1.yahoo.com>

Oracle used to install the Oracle Home Selector, a utility that woujld do some 'magic' in the registry to make the desired Oracle home location the current home.  I'm not sure if it is still installed or not; the Oracle home info is in the registry (HKEY_LOCAL_MACHINE/Software/Oracle) so you could also manually edit this information if need be.

David Fitzjarrell

---

From: "Schauss, Peter (ESS)" <peter.schauss_at_ngc.com> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Wednesday, April 18, 2012 12:11 PM 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 - 14:43:26 CDT