Re: Using Multiple Oracle Clients

On 20 Jan 2006 09:25:47 -0800, "Johne_uk" <edgarj_at_tiscali.co.uk> wrote:

>Hi,
>
>I'm looking for a few pointers. Basically we have a requirement to have
>2 Oracle clients running on a Win XP workstation. At the moment I'm not
>sure what versions both clients are but one is for Oracle ADI and the
>other is for a legacy application.
>
>Both apps can only work with their own client. However, because that
>the environmental variables in windows etc. are only pointing towards a
>single Oracle Home then only one program can be run at a time. Each
>client also has its own tnsnames.ora.
>
>I've been told that the users would be willing to run a batch file to
>switch between apps.
>
>Does anybody have any ideas how I can switch Oracle Homes via a batch
>file or, better still, when the apps run.
>
>Thanks in anticipation.
>John

Oracle comes with a tool called 'Oracle Home Selector'

--
Sybrand Bakker, Senior Oracle DBA