on the Tru64 unix box we are using it is found at : /usr/app/oracle/product/7.3.4/network/admin/tnsnames.ora
hope this helps cheers Edd >>> "Sridhar Saragu" <[EMAIL PROTECTED]> 09/18/02 14:21 PM >>> Hi, Can somebody tell me where the Perl exactly look for tnsnames.ora while connecting to Oracle ? (like home, oracle_home, tns_admin etc ...). I want to know the order in which it looks & the directories ? Thanks & Regards Sridhar