From: "Lashbrook" Subject: Re: TNSNAMES.ORA placment ?? Date: 1997/08/08 Message-ID: <01bca3b7$65f61520$468ddccf@pebbles>#1/1 References: <19970807035101.XAA23857@ladder02.news.aol.com> Organization: Netcom X-NETCOM-Date: Thu Aug 07 9:56:25 PM PDT 1997 Newsgroups: comp.databases.oracle.server I remember reading that on UNIX systems, the default location is /etc, but on PCs (clients) it is $ORACLE_HOME/network/admin. Will try to find that documentation to verify. You can always change as BRAJB described below. BRAJB wrote in article <19970807035101.XAA23857@ladder02.news.aol.com>... > The normal location is in $ORACLE_HOME/network/admin but you can put it > anywhere you like with the TNS_ADMIN pointing to it. It is my > understanding the search scenario goes first to /etc. If it is not there, > it searches the $ORACLE_HOME/network/admin. If not there it searches the > value of the TNS_ADMIN directory. The variable must be placed in each > users .profile or .cshrc file. I would venture a guess that it could be > placed in the /etc/profile (system wide) and would be applicable to every > user that logs in (if you want this). >