Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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"Received on Tue Sep 30 2003 - 17:13:42 CDT