Using Multiple Oracle Clients

From: Johne_uk <edgarj_at_tiscali.co.uk>
Date: 20 Jan 2006 09:25:47 -0800
Message-ID: <1137777947.148021.37030@g44g2000cwa.googlegroups.com>

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 Received on Fri Jan 20 2006 - 11:25:47 CST