Re: tnsnames - alias ends in a period

I've had this happen ( just this week in fact ) when the net8 assistant first creates a tnsnames.ora file. I simply went in and physically removed the period. All subsequent entries do not seem to get the period at the end. Also, make sure that your default domain is set correctly in the sql*net.ora file. Otherwise, the entry won't be found in the tnsnames.ora file unless you use the fully qualified service name.

HTH

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR, Dayton, OH

Opinions are my own and do not reflect those
of my employer or clients
<hanton32_at_hotmail.com> wrote in message news:973fou$li4$1_at_news.netmar.com...


> I cannot tnsping the server.

>

> I have tried re-creating the tnsnames.ora using the Net 8 Configuration

> Assistant but still can't tnsping the Oracle server.

>

> I suspect there is something wrong with the way the alias is created...I

 think


> it gets pulled in from my domain...the alias created is named

> 'alias.tbd.name.'    ???\

>

> tbd - to be determined ??

>

>

> hani

>

> In article <3A94C572.1DCEB6FC_at_exesolutions.com>, Daniel A. Morgan

> <dmorgan_at_exesolutions.com> writes:

> >The chances of a valid alias containing a period are, in my opinion,

 remote.


> >

> >You can ping the server ... but can you use TNSPING to ping the Oracle

 instance?


> >

> >If so you should be fine. But if not I would use the Net8 Assistant to

 recreate the


> >TNSNAMES.ORA file.

> >

> >Daniel A. Morgan

> >

> >

> >

> >hanton32_at_hotmail.com wrote:

> >

> >> I am running Win 95 oracle 8.16 client and connecting to NT Oracle 8.16

> >> Server

> >> I used the Net8 Configuration Assisstant to create tnsnames.ora. I am

 unable


> >> to connect..I get the '...could not resolve service name' error

 message.


> >>

> >> I noticed that the alias in tnsnames.ora file has a period at the end

> >> (alias.name.) see below

> >>

> >> I was told that the alias is from my Domain and that my pc's domain may

 not
 be


> >> set up correctly ?

> >>

> >> note: I am able to ping the server

> >>

> >> eg.

> >> alias.tbd.name.=

> >> (DESCRIPTION =

> >> (ADDRESS_LIST =

> >> (ADDRESS = (PROTOCOL = TCP)(HOST = 11.11.11.11)(PORT = 1521))

> >> )

> >> (CONNECT_DATA =

> >> (SERVICE_NAME = db.pc.c.com)

> >> )

> >> )

> >>

> >> any help appreciated

> >>

> >> thanks

> >> hani anton

> >>

> >>  -----  Posted via NewsOne.Net: Free (anonymous) Usenet News via the

 Web
 -----


> >>   http://newsone.net/ -- Free reading and anonymous posting to 60,000+

 groups


> >>    NewsOne.Net prohibits users from posting spam.  If this or other

 posts


> >> made through NewsOne.Net violate posting guidelines, email

 abuse_at_newsone.net


> >

>

>

>  -----  Posted via NewsOne.Net: Free (anonymous) Usenet News via the

 eb  -----


>   http://newsone.net/ -- Free reading and anonymous posting to 60,000+

 groups


>    NewsOne.Net prohibits users from posting spam.  If this or other posts

> made through NewsOne.Net violate posting guidelines, email

abuse_at_newsone.net