Thursday, April 18, 2013

How do you ensure the listener for a service on Oracle Network is up?

Use "tnsping" utility available in the "HOME/bin" directory of ORACLE to test if a remote listener is up (checks if the socket is reachable). This utility only ensures the availability of a listener; but not about the databases behind the listener.

No comments :