What is tnsping in Oracle?

Tnsping. From Oracle FAQ. Jump to: navigation. , search. TNSPING is a utility in the ORACLE HOME /bin directory used to test if a SQL*Net connect string can connect to a remote listener (check if the socket is reachable). Note: This utility only tests if the listener is available.

What is tntnsping used for?

TNSPING is a utility in the ORACLE HOME/bin directory used to test if a SQL*Net connect string can connect to a remote listener (check if the socket is reachable). Note: This utility only tests if the listener is available. It cannot tell if the databases behind the listener is up or not. Examples.

What does a successful tnsping test indicate?

Feb 21 ’15 at 4:52 2 @jmsmcfrlnd, a successful tnsping indicates only that the listener is running. A successful jdbc connection test using username, password and service name indicates that the Oracle instance offering the service is accessible and accepts connections – i.e. pretty much all you need to know when testing a connection to a database.

Does tnsping report the current state of the database?

However, tnsping will only report if the listener process is up and provides no indication of the state of the database. The?net service name? must exist in the tnsnames.ora file. This file is used by clients and database servers to identify server destinations. It stores the service names and database addresses.

Tnsping is an Oracle popular utility and used to check if a SQL*Net connection string can connect to listener and check if it is reachable. You can check and test if the listener is available and up or not using this utility. Tnsping Command in Oracle Tnsping utility is in the ORACLE HOME/bin directory

Which is an example of output when using tnsping?

Example 15-3 is an example of output when using TNSPING to check a name that is valid, but that resolves to an address where no listener is located (for example, the listener may not be started). TNS Ping Utility for Linux: Version 11.1.0.0.2 on 15-FEB-2009 14:52:28 Copyright (c) 1997, 2009 Oracle Corporation.

What is the difference between tnsping and trcroute?

TRCROUTE is different from TNSPING in that it travels as a special type of connect packet, and is routed as such. As it travels toward its destination, the TRCROUTE connect packet collects the TNS addresses of every node it travels through.