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

Home -> Community -> Usenet -> c.d.o.misc -> Re: tnsnames redirection

Re: tnsnames redirection

From: Robert W. Swisshelm <swisshelm_at_lilly.com>
Date: 1997/08/15
Message-ID: <33F46D1C.6998@lilly.com>#1/1

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 Fri Aug 15 1997 - 00:00:00 CDT

Original text of this message

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