Re: tnsnames redirection

From: Allan Taunt <allant_at_gis.co.nz>
Date: 1997/08/19
Message-ID: <01bcac81$66f2fb50$010aa8c4@capricorn>#1/1

It should also be noted that the TNS_ADMIN variable can be a UNC path (eg. \\Server\Share) on both Win95 and WinNT.

Allan.

---

Global Information Solutions.
Christchurch
New Zealand.  

Robert W. Swisshelm <swisshelm_at_lilly.com> wrote in article <33F46D1C.6998_at_lilly.com>...
> Nils H Thomsen wrote:
> >
> > [This followup was posted to comp.databases.oracle and a copy was sent
 to
> > the cited author.]
> >
> > In article <33F33FD8.4989_at_webmart.net>, Banicki_at_webmart.net says...
> > > RDBMS Version (if applicable): 7.3.3.?.?
> > > Error Number (if applicable): N/A
> > > Product and Version: SQL*Net V2
> > > Operating System: Intel Windows NT
> > >
> > >
> > > Configuring SQL*Net 2.3.3 client for WIN95 to be ran off
> > > the server. Just installed the first client and every thing works
> > > fine.
> > >
> > > I saw in one of my oracle classes that the tnsname.ora file was
 actually
> > > pointing to another drive and path, but i don't remember the syntax.
> > > is it possible to enter a drive and path into your tnsnames file
> > > to redirect the client to a common tnsnames(i.e. the one generated by
> > > NET*Manager)? Believe it or not, I think this would simplfy the
> > > client install.
> > >
> > > Terry Banicki, Illinois Power, Decatur, Il.
> > >
> >
>
> Under Windows 95, TNS_ADMIN is a registry variable. You can run REGEDIT
> to update the value, or create a registry file that will update the
> registry when the user double-clicks on it. This is useful if you have
> used the policy editor to prevent your users from running regedit.
>
> Here is an example. Place these lines in a file called tnsadmin.reg
>
> REGEDIT4
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
> "TNS_ADMIN"="X:\\ORACLE\\NETWORK\\ADMIN"
>
>
> When the user double clicks on tnsadmin.reg, TNS_ADMIN is updated to
> point to x:\oracle\network\admin.
>
>
>
> --
> Bob Swisshelm
> Eli Lilly and Company
> swisshelm_at_lilly.com
>
Received on Tue Aug 19 1997 - 00:00:00 CDT