Re: oracle instant client - tns_admin question

Luch wrote:
> What I was thinking of doing is... We already make a folder called
> "Trax" with our own app's files. So for example, we have a trax\exe
> folder with our executables and a \trax\bmp with our bmp files.
>
> I was thinking of doing a \trax\Oracle_client that would contain the
> instant client, and then drop the tnsnames/sqlnet files in there as
> well (copying it from the client's own shared folder, which we would
> tell them to drop it in). But my idea would be to have it in a way that
> only my Trax app would use that instant client, because I don't want to
> risk messing with another Oracle client app that they already may have.
>
>
>
> Laurenz Albe wrote:
> > Luch <DarthLuch_at_gmail.com> wrote:
> > > Another question... Would like some advise on what the "best practice"
> > > is in this case. We are an Indpndt sftwre Development company with a
> > > client-server(oracle) software.
> > >
> > > Should we indeed set that key when our softare is installed? Does it
> > > potentially interfere with other oracle client apps that they may
> > > already have on their machine?
> >
> > Setting TNS_ADMIN will interfere with any Oracle Client on the same machine.
> >
> > You cannot have two versions of Oracle Client on a Windows PC unless you
> > are willing to change PATH and other environment variables all the time.
> >
> > The 'best practice' is to make sure that there is only one Oracle Client
> > on the machine.
> >
> > Also, the major version of the client should be greater or equal to the
> > major version of the server software, elso you can easily get
> > compatibility problems.
> >
> > Why do you think that you need more than one client?
> >
> > Yours,
> > Laurenz Albe

Please do not top post. Most people in these Ng's will ignore your post.

One way to work around multiple oracle homes (which normally end users shouldn't have on their machines) is to launch your application from a batch file in which you can setup your environment just for that session e.g.

set tns_admin=
set path=c:\oracle_instant_client;%path% yourapp.exe "any" "arguments" "here" Received on Fri Mar 03 2006 - 18:13:54 CST