Re: tnsnames.ora file REQUIRING ip instead of name

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<3kn2mu4shuihhpt23ks402ej8a2j47bsbe_at_4ax.com>...
>
> What is the result of
> ping dbserver
>
> Your problem looks like a DNS issue to me.
> Evidently installing Mickeysoft sorrow pack 3 screwed up your TCP/IP
> stack.
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

c:\ ping dbserver
Pinging dbserver.testco.com [172.16.2.100] with 32 bytes of data:  

Reply from 172.16.2.100: bytes=32 time<10ms TTL=255
Reply from 172.16.2.100: bytes=32 time<10ms TTL=255
Reply from 172.16.2.100: bytes=32 time<10ms TTL=255
Reply from 172.16.2.100: bytes=32 time<10ms TTL=255
 

Ping statistics for 172.16.2.100:

    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds:

    Minimum = 0ms, Maximum = 0ms, Average = 0ms

c:\ tnsping dbserver
TNS Ping Utility for 32-bit Windows: Version 8.1.6.0.0 - Production on 20-AUG-20
02 08:00:19  

(c) Copyright 1997 Oracle Corporation. All rights reserved.  

Attempting to contact
(ADDRESS=(PROTOCOL=TCP)(HOST=dbserver)(PORT=1521)) OK (60 msec)

Guaranteed that DNS (both forward and reverse) are setup correctly. The second I change tnsnames.ora, my .asp can't connect to the db any longer. When I change it back to the ip, it immediately starts working again. No need to restart IIS or anything. I even rebooted with tnsnames.ora saved using the name of the server. No dice. Received on Tue Aug 20 2002 - 10:05:33 CDT