Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_gmail.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 08 2006 - 17:48:24 CST
![]() |
![]() |