RE: TNS_ADMIN
- From: Michael Milligan <Michael.Milligan@xxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 Mar 2004 16:27:13 -0600
The environmental variable TNS_ADMIN takes precedence over the setting in
the oracle_home registry area. You can set this in the registry itself as
HKEY_CURRENT_USER\Environment\TNS_ADMIN set to something like
c:\oracle\ora92\network\admin.
-----Original Message-----
From: Jacques Kilchoer [mailto:Jacques.Kilchoer@xxxxxxxxx]
Sent: Friday, March 05, 2004 3:17 PM
To: oracle-l@xxxxxxxxxxxxx
Cc: n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx
Subject: RE: TNS_ADMIN
What I do is (belt and suspenders approach)
a) Set the system environment variable TNS_ADMIN
b) In each %ORACLE_HOME%/netxxx/admin directory, have a
{config_file_name}.ora file that only includes the one line "ifile =
c:\my_directory\{config_file_name}.ora". I've never had a problem doing it
this way.
> -----Original Message-----
> Niall Litchfield
>
> The separate directory thing does make sense. I have had
> nothing but grief with system environment variables.
>
> > -----Original Message-----
> > From: JohnF@xxxxxxxx
> >
> > I was just reading a metalink article yesterday that suggests
> > that you forget
> > trying to set TNS_ADMIN in the registry, and set it as an
> > environment variable
> > instead. In my Win2000 system, that means go to control
> > panel, system, choose
> > the Advanced tab, press the environment variables button.
> > The article also
> > recommends that you create a directory outside of any of your
> > Oracle_Homes and
> > put the network configuration files there, with the
> > appropriate setting of
> > TNS_ADMIN. That way, if you reinstall, upgrade, delete, or
> > otherwise hose an
> > Oracle Home, your network settings will be unharmed.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
