Question: how to do tnsping command?
Answer: Open a Command Prompt (click Start, click Run, type cmd, and then click OK). 2. Type tnsping <service name> (for Oracle 7.3 or Oracle 8i and later) or tnsping80 <service name> (for Oracle 8.0), and then press enter. The TNS Ping Utility will result in an "OK" or a "Connect failed" message.