Try connecting through sqlplus as this is the logical next step after
tnsping. It might also give you a helpful error message.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Brent Olson" <deja-user_at_bitrealm.com> wrote in message
news:45100c75.0208200705.10e88324_at_posting.google.com...
> 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 Wed Aug 21 2002 - 06:04:41 CDT
