3 Replies Latest reply: Nov 23, 2012 6:58 AM by Saubhik RSS

    tnsping ping

    902332
      Hi all,

      When we do tnsping ping for service name some time we could see result

      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sgc-ora-fra1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = STEMEUROSTEMCELL.COM)))
      OK (5510 msec)

      or

      OK (10 msec)

      or

      OK (0 msec)


      what could be the reason that shows result like this. Does it effect anything on the database. Please give your valuable answers.

      thank you.
        • 1. Re: tnsping ping
          Niket Kumar
          its time in millisecond between sending reqest for database existance authentication and receive authntication msg from database to the tnsping terminal.

          if time taken in more, it might be due to network slowness.

          less time is always good.
          • 2. Re: tnsping ping
            Saubhik
            http://docs.oracle.com/cd/B19306_01/network.102/b14212/connect.htm#sthref1535
            • 3. Re: tnsping ping
              Aman....
              899329 wrote:
              Hi all,

              When we do tnsping ping for service name some time we could see result

              Used TNSNAMES adapter to resolve the alias
              Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sgc-ora-fra1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = STEMEUROSTEMCELL.COM)))
              OK (5510 msec)

              or

              OK (10 msec)

              or

              OK (0 msec)


              what could be the reason that shows result like this. Does it effect anything on the database. Please give your valuable answers.
              When you do a ping from the o/s , does it have any effect on your machine? TNSPING does nothing but pings to the listener which sends a reply back . The time reported is in milliseconds and that's what is shown over here. There is no effect of this on the database and TBH there isn't much use of this okay message as well as there is no attempt done to actually connect you to the requested service. Thus if there are any issues related to getting connected , you would only come to know about them once you would actually give a connection request.

              HTH
              Aman....