tnsname.ora file - location

Shell Programming and Scripting
1

Hi,

Could you please tell me at which location is the file located on unix server

Thanks.

2

If you are running Oracle on a Linux machine then run the following as root to find it:
# updatedb
# locate tnsname.ora

3

$ORACLE_HOME/admin/network/tnsnames.ora is the normal place for tnsnames.ora in unix implmentations of Oracle.

4

It's actually .../network/admin/...

$ 
$ echo $ORACLE_HOME
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
$ find $ORACLE_HOME -name tnsnames.ora
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/samples/tnsnames.ora
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/tnsnames.ora
$

tyler_durden