Re: Tnsnames.ora - Strange Connectivity problem

Looks like you might have multiple copies of tnsnames.ora, and you're not using the one you think you are...

You're trying to connect FROM you linux box TO a db on some other box, right? Check for multiple copies of tnsnames.ora on the box you are connecting FROM. Also check for a value for a variable called TNS_ADMIN in the environment from which you are running sqlplus.

Also, instead of actually trying to connect, let's simplify and just 'tnsping oranc1'. This will test your tnsnames file and routing, but not try to actually connect. In fact, you can successfully tnsping for a non-existent database, as long as you have the correct entries in your tnsnames.ora (client side) and listener.ora (server side). Received on Wed May 03 2006 - 12:07:01 CDT