Listener

TNSPING – 8 Aspects You Should Know

tnsping

tnsping is a utility provided by Oracle to test the listener is available or not from clients. If there’s any problem in the path to the destination, it will fail with different aspects. Here I list several possible error types below for your reference.

  1. “tnsping is not recognized as an internal or external command” or “tnsping command not found”
  2. tnsping message 3511 not found
  3. TNS-03505: Failed to resolve name
  4. TNS-12545: Connect failed because target host or object does not exist
  5. TNS-12535: TNS:operation timed out
  6. TNS-12541: TNS:no listener
  7. TNS-12547: TNS:lost contact
  8. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Leave a Reply

Your email address will not be published. Required fields are marked *