How to test connectivity between a server and Oracle database?

If you have a new Windows server and preparing it to host web applications, one of the first configurations you should make is to open firewall ports between your web server and database server.

In order to make sure required ports are opened, use tnsping and ODBC testing tools. These utilities can quickly tell you if the database connectivity is available.

TNSPING Utility

1. Open a Command Prompy (Start > Run > cmd)
2. Type tnsping <servicename>
3. If the result is OK, database connection is successful
   

ODBC Test Utility

1. Open ODBC Administrator (Start > Search > ODBC)
2. Click “Add”. Enter a service name and user ID
3. Click “Test Connection”
4. Enter your password when prompted. Click “OK”
5. You should recieve “Connection successful” message
   

Note: Linux users can also use TRCROUTE utility. For more information, please refer to the link below.

References:

• Oracle Help Center – Testing Connections