You could consider just skipping tnsnames.ora and OID. With 10g you get easy connect. e.g. sqlplus scott/tiger@//someserver:1529/orcl or if using the default 1521 port: sqlplus scott/tiger@//someserver/orcl Here's an article on it: http://blogs.ittoolbox.com/oracle/guide/archives/007295.asp?rss=1 If it will work with your apps, it would save you some trouble. Jared On 2/8/06, Michael Ray <topshot.rhit@xxxxxxxxx> wrote: > > I suggested to my client we switch to a centralized naming solution when > we do the upgrade to 10g since we have to touch all the current clients > anyway. However, I see Oracle no longer supports Names Servers so it appears > the 2 options now are a single tnsnames.ora file or Oracle Internet > Directory (OID). > > The first option is by far simpler, but is there a way to have redundancy > if the network path to the file happens to be down? In other words, can you > point the clients to 2 identical tnsnames files on the network? If not, I > suppose we could put the file on the Oracle server itself and deal with a > Windows share or something like that. > > Is there any benefit to using OID instead? Note this isn't for some > enterprise-wide solution. While they do have plants all over the world, it's > very rare that they share database info. I'm only dealing with one plant > though it would be nice if are solution could be easily used by others. It > seems like a real pain to setup OID since you have to dig it out of > Application Server now. Why did they do that? > > > Shalom, > Michael Ray > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist