Explain about TNSPING

You can also use tnsping utility on command prompt to check Oracle Net connectivity. Follow these steps to check the connection to particular SID.

Open Command prompt.

Write tnsping < SID for the database connectivity you want to check >

If you get the message “Used TNSNAMES adapter to resolve the alias” then tnsping utility is able to resolve the service name.

If you get “TNS-03505: Failed to resolve name” message then tnsping utility is not able to resolve the service name and you need to check the SQLNET.ora and TNSNAMES.ora files on your machine.

Questions by admin

Showing Answers 1 - 3 of 3 Answers

kmkumar24

  • Mar 29th, 2007
 

The TNSPING which helps to findout whether we have the connectivity to the particular database. It can be accessed from the dos prompt with either database name or with IP address.

If it ping with that database then it will reply. otherwise we have to add the tnsnames.ora and the listerner configuration.

  Was this answer useful?  Yes

Chiranjeevi Manne

  • Mar 30th, 2007
 

TNSPING is an Oracle network utility which checks for connectivity of a remote database.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions