Re: tnsnames.ora & aqlnet.ora

The canonical location for this is either $ORACLE_HOME/network/admin or /etc (probably /var/opt/oracle on Solaris)
the environment variable TNS_ADMIN determines which to use, if it's not in that directory /etc and $ORACLE_HOME/network/admin are searched. Obviously, the .ora in the samples directory are samples and don't do any harm. They are not being used anyway.
The directories you are specifiying do point to further problems. Normally ORACLE_HOME should equal (example only) /home/oracle/product/<version> where version in your case is 8.0.5. You seem to have OFA and non-OFA installations on your system. The correct ORACLE_HOME is in /etc/oratab in your case /var/opt/oracle/oratab.

Hth,

Sybrand Bakker, Oracle DBA

uri bargil wrote in message <3732CEBC.45793DA2_at_trans-planet.com>...
>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
>of it on my machine :
>1)ORACLE_HOME/network/admin/samples/tnsnames.ora
>2)ORACLE_HOME/network/admin/tnsnames.ora
>3)ORACLE_HOME/../8.0.5/network/admin/samples/tnsnames.ora
>4)ORACLE_HOME/../8.0.5/network/admin/tnsnames.ora
>5)ORAWEB_HOME/../../8.0.5/network/admin/samples/tnsnames.ora
>6)ORAWEB_HOME/../../8.0.5/network/admin/tnsnames.ora
>
>The same with sqlnet.ora I got 5 versions :
>1)ORACLE_HOME/network/admin/samples/sqlnet.ora
>2)ORACLE_HOME/../8.0.5/network/admin/samples/sqlnet.ora
>3)ORACLE_HOME/../8.0.5/network/admin/sqlnet.ora - empty version
>4)ORAWEB_HOME/../../network/admin/samples/sqlnet.ora
>5)ORAWEB_HOME/../../network/admin/sqlnet.ora -empty version
>The versions are not all the same.
>My questions:
>1) Where should I place the tnsnames.ora and the sqlnet.ora ?
>2)can I have more than one version , since I have DB and OAS ?
>3) Do you have an example for sqlnet for DB/OAS.
>Thank you very much
>uri
>
>
>
>
>
Received on Fri May 07 1999 - 11:15:45 CDT