Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Mulitple oracle home and tnsnames.ora directories

Re: Mulitple oracle home and tnsnames.ora directories

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Wed, 01 Oct 2003 00:17:39 +0200
Message-ID: <540knvopl7ilg9omrnjeko39q9jmj8lq1b@4ax.com>


On 30 Sep 2003 14:43:49 -0700, lupis_at_postmaster.co.uk (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.

Just choose anyone of them and have the registry variable HKLM\software\oracle\tns_admin point to the directory the file is located. This is document in the O/S specific 'Getting Started' doco. For Unixes you need to set the env var TNS_ADMIN

--
Sybrand Bakker, Senior Oracle DBA
Received on Tue Sep 30 2003 - 17:17:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US