Re: tnsnames.ora file REQUIRING ip instead of name

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 19 Aug 2002 23:10:43 +0200
Message-ID: <3kn2mu4shuihhpt23ks402ej8a2j47bsbe@4ax.com>

On 19 Aug 2002 13:17:40 -0700, deja-user_at_bitrealm.com (Brent Olson) wrote:

>Just upgraded Win2k to SP3 and my .asp files can't seem to connect to
>the Solaris db any longer. I can tnsping no problem, but my .asps
>don't connect. If I change the tnsnames.ora file, then everything is
>good.
>
>This behaviour changed as soon as I installed Service Pack 3 on the
>Win2k Server (oracle client).
>
>Here's what use to work prior to SP3....
>
>PRODUCT_TNS.testco.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = dbserver)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = product)
> )
> )
>
>Here's what I have to use now:
>
>PRODUCT_TNS.testco.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.100)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = product)
> )
> )
>
>More info available upon request.

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 Received on Mon Aug 19 2002 - 16:10:43 CDT