Re: Oracle Name server

"Brian Peasland" <oracle_dba_at_qwest.net> wrote in message news:3BA5F735.A56F8836_at_qwest.net...
> > If you have set up an Oracle Names server you want the order to be :
first
> > the Names Server then tnsnames.
>
> I disagree with this order. At my installation, our order is
> (TNSNAMES,ONAMES). This way, the client can customize their TNS
> configuration on their client side TNSNAMES.ORA file. Any entries found
> here will override what is stored in Oracle Names. This is mostly
> important to our development staff. This way, they can use a TNS entry
> to point to a development instance (as configured in their TNSNAMES
> file) while everyone else (using NAMES) points to the production
> instance. Without this ordering, the clients can not override
> definitions in Names. This may be desirable in some installations
> though.
>
> Thanks,
> Brian

I have had to manage situations where no 2 tnsnames.ora (developers ones of course) were the same, and where I was more or less forced to edit them all individually. I don't see why you advocate developers having their own tnsnames.ora. This is simply promoting nightmares. Period.

Regards,
Sybrand Bakker, Senior Oracle DBA Received on Mon Sep 17 2001 - 12:00:04 CDT