TNSPING is not recognised as an internal or external command

TNSPING is a utility in the oracle used to test if a SQL*Net connect string can connect to a remote listener (check if the socket is reachable).

Issue:- When we run the command from command prompt error comes “ ’tnsping’ is not recognised as an internal or external command, operable program or batch file’” as below screenshot.

Resolution:- Follow the following steps :

1. Ensure oracle client is installed on your system
2. Right click on My computer icon
3. Click on properties
4. Click on Advanced System Settings
5. Click on Environment Variables
6. In the system variables list box select the line with “path” written under Variable
7. Click on edit
8. In the variable value text box append at the beginning the path of the oracle client installation folder upto bin location e.g. D:\app\Administrator\product\11.1.0\client\BIN; (put semicolon at the end)
9. Now click OK and restart your machine
10. Now the problem should be resolved