Mulitple oracle home and tnsnames.ora directories

From: Nicholas Lupis <lupis_at_postmaster.co.uk>
Date: 30 Sep 2003 14:43:49 -0700
Message-ID: <57c51a5b.0309301343.32bdc347@posting.google.com>

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. Received on Tue Sep 30 2003 - 16:43:49 CDT