Very Computer

Hello all,
        I am using Oracle 7.3 on Solaris 2.5 with SQL*NET 2.0

        I have a question about the SQL*NET configuration files. Where Oracle
searches the SQL*NET configuration files such as TNSNAMES.ORA and
LISTENER.ORA? I heard that these files default in /var/opt/oracle
directory. TNS_ADMIN variable is used to specify the directory other
than the /var/opt/oracle directory. However, when I type "echo
$TNS_ADMIN", undefined variable message was shown. When I type "lsnrctl
status", the parameter files are in $ORACLE_HOME/network/admin. How can
Oracle knows these files are in the $ORACLE_HOME/network/admin directoy?

Thanks,
Jimmy

Oracle looks in $ORACLE_HOME\network\admin for sqlnet.oraand
tnsnsmes.ora.
TNS_ADMIN is set in the sqlnet.ora file and is an Oracle var not a OS
var.
$ORACLE_HOME defaults to diff. paths depending on the OS
Hope this helps
JD

--
JD White
Database Administration

Office: 919.388.6254
Fax:    919.388.6578
Pager:  800.614.7512

1700 Perimeter Park Drive
MD-A218
Morrisville, NC 27560

j.white.vcf < 1K Download