Re: Mulitple oracle home and tnsnames.ora directories

Put your TNSNAMES file into one folder. It can even be in one of the ORACLE_HOME/network/admin directories. Then create a link in the other ORACLE_HOME/network/admin folders to this one. If you are on Windows, make a "shortcut" and rename the shortcut to TNSNAMES.ORA. If you are on Unix, make a symbolic link.

HTH,
Brian

Nicholas Lupis wrote:
>
> Hello
>
> I have been installing a number of oracle products such as 9i,
> Warehouse Builder, Discoverer and also Designer.
>
> Because these installations don't allow the same Oracle Home directory
> multiple directories have been setup, one for the database, one for
> Warehouse Builder and another for Discoverer each with there own
> tnsnames.ora file and also multiple installtions of SQLPlus and other
> configuration tools.
>
> As you can imagine this is a bit of nightmare as at the end of the day
> a typical database should be accessed by all these applications
> therefore each tnsnames.ora file needs to have all the right access
> information.
>
> Is there anyone out there that has organised all these into some
> sensible structure, where by all tools can access the same
> tnsnames.ora and structure all the application in a resonable manner?
> Is so, how??? and is there anything documentation or tools availible
> for these problems.
>
> Regards
>
> Nick.

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

Brian Peasland
dba_at_remove_spam.peasland.com

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


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