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

Home -> Community -> Usenet -> c.d.o.server -> Re: TNSNAMES.ORA not in ORACLE_HOME

Re: TNSNAMES.ORA not in ORACLE_HOME

From: Rich Woods <rawoods_at_concentric.net>
Date: 1997/06/19
Message-ID: <33A9CB6F.561B@concentric.net>#1/1

Tony van der Prijt wrote:
>
> Hi there,
>
> I wonder if someone knows the answer to the following question:
>
> I'm working in an environment where almost everything is stored on an
> fileserver. Even the oracle-client software. Since I'm developing a new
> database, I need different entries in the TNSNAMES.ORA file than the one
> stored on the fileserver. However, the network management department won't
> allow me to edit the TNSNAMES.ORA file (rightfully so), but I do want to
> use the software from the fileserver, since that most closely resembles the
> situation in which my end-users will work. The only file that needs to be
> different is the TNSNAMES.ORA-file. Is there a possibility under Windows
> 3.1 to have this file stored in a different directory than the
> ORACLE_HOME\NETWORK\ADMIN?
>
> Any help will be much appreciated,
> Tony van der Prijt.

Yes, you can specify an alternate location with the TNS_ADMIN environment variable.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Received on Thu Jun 19 1997 - 00:00:00 CDT

Original text of this message

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