Results 1 to 3 of 3


  1. #1
    Join Date
    Mar 2003

    Unanswered: TNSPING vs PING


    I am about to take Oracle Net8 Admin test but am confused about one thing. I was wondering if there a way I could clear the confusion and cement the difference in my mind between PING and TNSPING. I am having a hard time telling the difference. Can anyone tell me how I can separate the two and be able to answer questions on that difference?

    Thanks in advance.


  2. #2
    Join Date
    Nov 2002
    Desk, slightly south of keyboard
    TNS is Oracle specific. Ping is not.

    All machines on an IP network have an address. When you PING an address ( you're seeing if something (anything) is on the other end. When you ping a named machine (ie, etc) you are seeing if a: that name resolves to an IP address (via DNS) and b: if the resolved address exists and c: if the machine at that address has been allowed to reply to a ping.

    TNS is essentially the way Oracle a: names an instance and b: resolves the name to an IP or named machined as above. On your machine there should be a file called TNSNAMES.ORA which tells Oracle "when I talk about connecting to an instance named FRED - you can find it on this IP address or named machine".

    Ie, if you cannot PING a MACHINE (ip or named) you definately cannot TNSPING an instance which resides on the same machine with the same method of resolution (ip or name).

    If you can PING a machine (ip or named), it doesn't necessarily mean you can TNSPING the machine because the TNS entries of what machine it is on aren't necessarily configured.

    I'm not sure that makes any sense at all :-)


  3. #3
    Join Date
    Apr 2002
    California, USA


    Ping - send a TCP/IP request package to remote client, wait for a response. IP Address/Host can communicate with you.

    Tnsping - send a TNS alias (Oracle reads the tnsnames.ora file, resolves the TNS Alias to IP Address, gets the Port, Protocol and SID, sends a TNS package and waits for response).

    Hope that helps,

    clio_usa - OCP - DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts