Re: tnsping80

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Mon, 28 Jun 1999 09:34:49 +0200
Message-ID: <7l78gc$nvq$1@news3.saix.net>

lauracampos_at_yahoo.com wrote in message <7l0rks$ft8$1_at_nnrp1.deja.com>...
>I am running Windows NT 4.0 and Oracle Enterprise Edition 8.0.5.0.0. I
>am having a problem when I try to tnsping80 an ip address. I have the
>default domain world in the sqlnet.ora file. On the server, I am trying
>to perform a tnsping80 to 127.0.0.1 (Local Loop Back) but, I get a
>"TNS-03505:Failed to resolve name" error. It works when I do a tnsping80
>on tcp-loopback.world but, not when I do a tnsping80 on 127.0.0.1.

Not sure if I understand you correctly. You say that this works:

C:\> TNSPING80 tcp-loopback

But then you say that tnsping on loopback does not work.. If you are trying the following does not work..

C:\> TNSPING80 127.0.0.1 ..then of course it will not. 127.0.0.1 is a TCP/IP address and not a Oracle TNS database alias name. TNSPING sole purpose in life is to check the parameter you specify, make sure that it has been defined in TNSNAMES.ORA and then to connect to the listener on the server to which that TNS name refers too and see if the listener is working.

To check an IP address, you use the PING command and not the TNSPING, i.e.

C:\> PING 127.0.0.1 regards,
Billy Received on Mon Jun 28 1999 - 02:34:49 CDT