Question: how to tnsping in oracle database?
Answer: 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.