This content has been marked as final. Show 3 replies
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.
899329 wrote: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.
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)
OK (10 msec)
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.