Re: Connection problem through sqlplus

On Tue, 15 Aug 2006 17:01:38 +0000, Terry Dykstra wrote:

>
> You can set TNS_ADMIN environment variable. Point it to the directory of
> your tnsnames.ora file. This way you can use one tnsnames.ora file even
> when using multiple oracle_homes.

And even better - you can put the TNSNAMES.ORA file (and the listener.ora, sqlnet.ora) into a central directory (such as $ORACLE_BASE/network) that can be backed up when other interesting things, like the [s]pfile are backed up.

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.