Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using Multiple Oracle Clients

Re: Using Multiple Oracle Clients

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 20 Jan 2006 21:12:12 +0100
Message-ID: <90h2t1p3q4cqqr7lfggqbqr3rk78h711oa@4ax.com>


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
Received on Fri Jan 20 2006 - 14:12:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US