Re: Home selector for Oracle 10g on Windows

Sarah means the Oracle Home Selector that came with earlier releases on Windows. oraenv and dbhome don't exist on the windows platform.

There is a graphical tool available in 10g - its just very badly hidden. If you fire up the 10g installer and click on installed products you'll get the Oracle inventory screen up. This has an environment tab, you can set the oracle home from there.

However all that is really needed is to set the PATH environment variable so that the oracle executable directories are listed in the correct order (and maybe the ORACLE_SID environment variable if you don't wish to use the listener). Since I find the inventory program fantastically slow at doing this I tend to do what Ron suggested and create a script to set the path.

On 8/18/05, Henry Poras <henry_at_itasoftware.com> wrote:
> Sarah,
>
> Do you mean oraenv or dbhome? They still exist.
>
> Henry
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Sarah Satterthwaite
> Sent: Thursday, August 18, 2005 2:30 PM
> To: oracle-l_at_freelists.org
> Subject: Home selector for Oracle 10g on Windows
>
>
> Folks,
>
> In Oracle 8 there is a little tool that comes with the installation for
> changing the Oracle Home that works with Oracle 8 and 9, but not 10. It
> changes the path variable so all the right Oracle code is picked up. Is
> there an equivalent tool for Oracle 10? If not, do you have any suggestions
> on what works well for switching between them?
>
> Thanks,
>
> Sarah
>
>
> _______________________
>
> Sarah Satterthwaite
> Database Administrator
> Fiserv CSW, Inc
> 125 Cambridge Park Drive
> Cambridge, MA 02140
>
> Email: sarah_at_cswv.com
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l