Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!u72g2000cwu.googlegroups.com!not-for-mail From: "Luch" Newsgroups: comp.databases.oracle.misc Subject: Re: oracle instant client - tns_admin question Date: 3 Mar 2006 11:40:46 -0800 Organization: http://groups.google.com Lines: 40 Message-ID: <1141414846.344431.43480@u72g2000cwu.googlegroups.com> References: <1141390750.654276.7770@j33g2000cwa.googlegroups.com> <1141391374.170690.50960@j33g2000cwa.googlegroups.com> <1141402671.659170.272300@z34g2000cwc.googlegroups.com> <1141403819.918351@proxy.dienste.wien.at> NNTP-Posting-Host: 65.218.135.210 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1141414851 32312 127.0.0.1 (3 Mar 2006 19:40:51 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 3 Mar 2006 19:40:51 +0000 (UTC) User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: u72g2000cwu.googlegroups.com; posting-host=65.218.135.210; posting-account=xwzu9Q0AAAAjiRddJupkwELkZlphbZGQ Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:125667 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 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