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

All,  

We do the same thing. We elected to use Ldap because ONames was going away. Works just fine. Putting new entries in the Ldap tree is a pain, but once you figure out how to do it, it's fine.  

For database to database connections, we use Tnsnames only. And App Server to database connections, again, Tnsnames only. These change so infrequently that they are not a problem to maintain.  

Tom  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paul Baumgartel Sent: Wednesday, September 21, 2005 6:06 PM To: oracle-l
Subject: Re: OID vs Oracle Names Server vs TNSNAMES.ORA vs MAD  

Stephen,

You can set a list of name resolution methods with or without Onames. True, the SQLNET.ORA parameter is NAMES.DIRECTORY_PATH, but its use not linked to Names. We use
NAMES.DIRECTORY_PATH= (LDAP,TNSNAMES)
and it works just peachy (peachily?).

-- 
Paul Baumgartel
paul.baumgartel_at_aya.yale.edu



On 9/21/05, stephen booth <stephenbooth.uk_at_gmail.com> wrote:

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

 


--
http://www.freelists.org/webpage/oracle-l