RE: TNS Resolution

Thank you as well! 

I was configuring client tnsnames at the moment and we are changing domain
names - your suggestion came just in time!
It works well so the users/clients can connect with either the old domain,
new domain, or no domain in the connect string.

Kristin

 -----Original Message-----
From:   Thomas Day [mailto:tomday2@xxxxxxxxx] 
Sent:   Tuesday, January 24, 2006 10:28 AM
To:     Dulay, Kristin
Cc:     oracle-l@xxxxxxxxxxxxx
Subject:        Re: TNS Resolution

Yup.  I needed one more test.  With names.default_domain not set in
sqlnet.ora, as Kristin points out, the TNSNAMES entry with
<name1>,<name2.world> works just fine.

connect user/pwd@name1 - works
connect user/pwd@xxxxxxxxxxx - works

and in fact, if the TNSNAMES entry is <name1>,<name1.world>

then connect user/pwd@name1 works regardless of whether the
names.default_domain is present in sqlnet.ora (however, if it is
present it should be set to 'world').

Also, I have used two entries in my tnsnames to point to the same
database so that users could have their preferred alias.  That's not
necessary.

<name1>,<name1.world>,<name2>,<name2.world> in TNSNAMES allows you to
connect using

@name1
@name2
@name1.world
@name2.world

Is there no end to this maddness?

But thanks, Kristin, for testing further.  It's something that I'll
use in the future.

On 1/24/06, Dulay, Kristin <Kristin_Dulay@xxxxxxxxx> wrote:
> This works too, logging in with @db1 or @db2.world...
> db1,db2.world =
>
> am I not getting it?
>
>  -----Original Message-----
> From:   Thomas Day [mailto:tomday2@xxxxxxxxx]
> Sent:   Tuesday, January 24, 2006 9:18 AM
> To:     Dulay, Kristin
> Subject:        Re: TNS Resolution
>
> I tested it that way too and it appeared to work which is why my
> initial post was as it is.  However, if the name before the comma is
> different than the name behind the comma you will see that everything
> up to the comma is ignored.
>
> On 1/24/06, Dulay, Kristin <Kristin_Dulay@xxxxxxxxx> wrote:
> > Actually, I tested that, and it does work.  With names.default_domain
not
> > set in sqlnet.ora.
> >
> > In tnsnames:
> >
> > db1, db1.world =
> >  ......
> >
> >
> >  -----Original Message-----
> > From:   oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> > On Behalf Of Thomas Day
> > Sent:   Monday, January 23, 2006 9:08 AM
> > To:     Oracle Mailing List
> > Subject:        Re: TNS Resolution
> >
> > Nope.  I take it all back.
> >
> > Everything up to and including the comma is treated as a comment.
> >
> > Test twice, open mouth once.
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
--
http://www.freelists.org/webpage/oracle-l


Other related posts: