Re: Connection problem through sqlplus

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Tue, 15 Aug 2006 18:23:32 GMT
Message-ID: <J41xrH.Cp5@igsrsparc2.er.usgs.gov>

HansF wrote:
> 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.
>

Another thing that I have done is to put the tnsnames.ora config file in a central location and then create a softlink from the various $ORACLE_HOME/network/admin directories pointing to that centrally maintained file.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Tue Aug 15 2006 - 13:23:32 CDT