tnsnames.ora file REQUIRING ip instead of name

From: Brent Olson <deja-user_at_bitrealm.com>
Date: 19 Aug 2002 13:17:40 -0700
Message-ID: <45100c75.0208191217.551c4668@posting.google.com>

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. Received on Mon Aug 19 2002 - 15:17:40 CDT