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.
>
>
Not a nightmare if you read the documentation. There is an environment
variable TNS_ADMIN that can be
used to point to a single copy of tnsnames.ora for all Oracle Homes.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Sep 30 2003 - 17:29:50 CDT
