Re: Centralized names resolution

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

Other related posts: