Re: SQL*Net v2: tnsnames.ora location under Unix

john.loring_at_cplc.com wrote:
>> keith_at_keithd.demon.co.uk (Keith Davies) writes:
>> I have searched through my manuals, but it's still a mystery. Where should
>> the TNSNAMES.ORA file be put on a Unix machine?
>>
>> Thanks in advance,
>>
>> Keith Davies
>>
>>
>>
>>
>>>>>
>Try /etc.
>

Your sqlnet config files (tnsnames.ora, listener.ora, etc.) can reside in $ORACLE_HOME/network/admin, /etc (or /var/opt/oracle on solaris) or anywhere you want if you assign $TNS_ADMIN to the directory.

For example, if you want to put the files in /home/oracle, just set TNS_ADMIN=/home/oracle

Hope this helps.
Mike Morgan

mike.morgan_at_teldta.com Received on Tue May 14 1996 - 00:00:00 CEST