Re: OID vs Oracle Names Server vs TNSNAMES.ORA vs MAD
- From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Sep 2005 18:05:43 -0400
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@xxxxxxxxxxxx
On 9/21/05, stephen booth <stephenbooth.uk@xxxxxxxxx> wrote:
>
> On 21/09/05, Goulet, Dick <DGoulet@xxxxxxxx> 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.
> --
> //www.freelists.org/webpage/oracle-l
>
Other related posts:
