TNS Resolution 2006-01-24 - By Thomas Day
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@(protected) - works
connect user/pwd@(protected) - works
and in fact, if the TNSNAMES entry is <name1>,<name1.world>
then connect user/pwd@(protected) 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
@(protected)
@(protected)
@(protected)
@(protected)
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@(protected)> wrote:
> This works too, logging in with @(protected) or @(protected)
> db1,db2.world =
>
> am I not getting it?
>
> -- --Original Message-- --
> From: Thomas Day [mailto:tomday2@(protected)]
> 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@(protected)> 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@(protected)
> [mailto:oracle-l-bounce@(protected)]
> > 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
|
|
