How to Download and Install TNSPING Utility for 32-bit Windows 10
TNSPING is a command-line tool that allows you to test the connectivity and response time of an Oracle database server. It is useful for troubleshooting network issues, verifying the configuration of your TNSNAMES.ORA file, and checking the availability of your database service.
TNSPING is not included in the Oracle Instant Client package, which is a lightweight and easy-to-install version of the Oracle client software. If you want to use TNSPING on your 32-bit Windows 10 machine, you have two options:
Download and install the Oracle Database Client, which includes TNSPING and other Oracle utilities. You can find the download link and installation instructions here. Note that this option requires more disk space and may require administrator privileges.
Copy the TNSPING executable and related files from another Oracle server or client installation of the same version. You can find the steps to do this here. Note that this option may not work if the source and target machines have different architectures or operating systems.
After you have installed or copied TNSPING, you need to set some environment variables and configure your TNSNAMES.ORA file with an entry for your database service. You can find more details on how to do this here.
Once you have completed these steps, you can open a command prompt and run TNSPING with the following syntax:
where is the name of your database service as defined in your TNSNAMES.ORA file, and is the number of times to ping the server (default is 1).
TNSPING will display the response time in milliseconds for each ping, as well as the average response time and success rate at the end. If there is any error or timeout, it will also display a message indicating the possible cause.
TNSPING is a handy tool for verifying and troubleshooting your Oracle database connection. However, it does not guarantee that you can connect to the database with your username and password, or that the database is functioning properly. For that, you need to use SQL*Plus or another Oracle client application.
Examples of Using TNSPING
In this section, we will show some examples of using TNSPING with different scenarios and parameters. We assume that you have already installed or copied TNSPING and configured your TNSNAMES.ORA file.
Example 1: Ping a Database Service Once
This is the simplest way to use TNSPING. You just need to specify the net service name of your database service and press Enter. For example, if you want to ping the INFOACCESS database service, you can run the following command:
The first line shows the location of the SQLNET.ORA file, which contains some global settings for Oracle network communication. The second line shows that TNSPING used the TNSNAMES adapter to resolve the net service name to a connection string. The third line shows the connection string, which consists of several parameters such as protocol, host, port, and service name. The last line shows the result of the ping, which is OK in this case, and the response time in milliseconds.
Example 2: Ping a Database Service Multiple Times
If you want to ping a database service more than once, you can specify the number of times as the second parameter. For example, if you want to ping the INFOACCESS database service 5 times, you can run the following command:
Attempting to contact cn=INFOACCESS,cn=OracleContext,o=wisc.edu
TNS-03505: Failed to resolve name
The first five lines are similar to Example 1, except that TNSPING repeats them five times with different timestamps. The sixth line shows a summary of the ping results, which includes the version and aa16f39245