Re: tnsnames.ora & aqlnet.ora

From: Gerry Sinkiewicz <sinkiege_at_snet.net>
Date: Fri, 07 May 1999 20:29:59 -0400
Message-ID: <37338587.6F5665F@snet.net>

uri bargil wrote:
>
> Hello
> I have Oracle DB 8.0.5 , OracleApplicationServer 4.0.7 on Sun Solaris
> 2.6.
> I try to fix my tnsnames.ora and found out that there are 6 versions
>
> 1) Where should I place the tnsnames.ora and the sqlnet.ora ?
>

text snipped here due to ISP included text restrictions.

Sqlnet.ora and tnsnames.ora are client related, used by the DB server only if it is acting as a client either for itself to some other server.

The key is generally in the value of $TNS_ADMIN. It is the directory that clients look in first (except maybe for /var/opt/oracle) to find those two client files.

The same maybe true of lsnrctl and listener.ora ( this is where /var/opt/oracle might win).

--
Gerry Sinkiewicz
sinkiege_at_snet.net Received on Fri May 07 1999 - 19:29:59 CDT