Or use the env var TNS_ADMIN to point to the directory where the files
are located (not sure if it works with all Oracle tools on Winblows -
I've heard from some people it doesn't).
Brian Peasland wrote:
> 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.
>
>
--
Ron Reidy
Oracle DBA
Received on Tue Sep 30 2003 - 20:03:24 CDT