Home » Oracle » How to test connectivity between a server and Oracle database?

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:

Ned Sahin

Blogger for 20 years. Former Microsoft Engineer. Author of six books. I love creating helpful content and sharing with the world. Reach me out for any questions or feedback.

1 thought on “How to test connectivity between a server and Oracle database?”

Leave a Comment