Results 1 to 3 of 3

Thread: TNSPING vs PING

  1. #1
    Join Date
    Mar 2003
    Posts
    45

    Unanswered: TNSPING vs PING

    Hi,

    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.

    Alex

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

    All machines on an IP network have an address. When you PING an address (192.168.0.1) you're seeing if something (anything) is on the other end. When you ping a named machine (ie www.oracle.com, www.demon.net 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 :-)

    HTH
    Bill

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    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
  •