Very Computer

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

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

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