Re: OID vs Oracle Names Server vs TNSNAMES.ORA vs MAD

On 21/09/05, Goulet, Dick <DGoulet_at_vicr.com> wrote:
> Tried that, it failed because people were copying the file locally,
> futzing with it so that database names were as they desired & then
> complaining when the system replaced their definition of TNS_ADMIN.

There's a good chance we'd run ito something similar. Whilst some users will run just that one app, others will run two or more apps that have to access their own backend Oracle databases. Unfortunately, this being a city council, if those apps 'belong' to different departments the chance of getting the application support teams to co-operate on a single TNSNAMES.ORA file other than on the local machine are zero. Possibly less than zero.

An advantage of ONames, if I'm understanding it correctly, is that you can set the clients (in sqlnet.ora) to try the ONames server and then fail over to a local TNSNAMES.ORA file if that doesn't resolve the name.

Stephen

--
It's better to ask a silly question than to make a silly assumption.
--
http://www.freelists.org/webpage/oracle-l