tnsnames.ora & aqlnet.ora

tnsnames.ora & aqlnet.ora

Post by uri bargi » Sat, 08 May 1999 04:00:00



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

 
 
 

tnsnames.ora & aqlnet.ora

Post by Sybrand Bakke » Sat, 08 May 1999 04:00:00


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


>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


 
 
 

tnsnames.ora & aqlnet.ora

Post by Gerry Sinkiewic » Sat, 08 May 1999 04:00:00



> 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