Testing an Oracle Database Connection to InfoAccess

After installing the Oracle client, you will want to test your connection to ensure the software is installed correctly. This document details how to test your Oracle database connection through the Windows command prompt for both 32- and 64-bit Oracle installations.

Prepare for testing

Before you test the connection to InfoAccess, ensure you have the Oracle client installed and your TNSnames.ora file in the correct location with an entry for InfoAccess. Ensure you know your Oracle client paths if you have both 32- and 64-bit versions installed. Note that the paths can be different on different machines. You can find your Oracle client path by searching for tnsping in Windows Explorer. See Downloading and Installing Oracle 12c Client and Adding, Edting, or Replacing Your TNSnames.ora File for InfoAccess for more information.

Open the command prompt by pressing the Windows key (between Left Ctrl and Alt with the Windows logo) on your keyboard and typing "cmd".

CMD.png

Press return or click on Command Prompt, which will open a command prompt window.

Testing instructions: variations

There are three sets of instructions, depending on your Oracle driver installation(s).
  • You have a 32-bit or a 64-bit version of the Oracle driver installed.
  • You have a 32-bit and a 64-bit version of the Oracle driver installed, and you want to test the 32-bit connection.
  • You have a 32-bit and a 64-bit version of the Oracle driver installed, and you want to test the 64-bit connection.

Testing instructions: only one Oracle driver version (64-bit or 32-bit) installed

In this case, testing is simple. Type tnsping infoaccess in command prompt and you receive the results:

tnsping1version.png

As you can see by the screenshot above, OK means the test completed successfully.

Testing instructions: 32-bit Oracle driver connection

In command prompt, you must change the directory where the tnsping command runs to where the 32-bit Oracle driver version is. In command prompt, first type cd C:\, which will allow you to change the directory to the 32-bit Oracle path. You'll know this is successful when command prompt shows C:\ before the cursor.

tnsping32bit1.png

After this, navigate to your bin folder in your 32-bit Oracle driver folders. Type the following in command prompt, assuming your 32-bit Oracle driver home directory is C:\Oracle32.
cd Oracle32\product\12.2.0\client_1\bin
After this step, the command prompt should look like this:

tnsping32bit2.png

Type tnsping infoaccess. Command prompt should generate some results similar to the screenshot below.

tnsping32bit3.png

You can tell the command successfully used the 32-bit driver by the text TNS Ping Utility for 32-bit Windows: in command prompt. As you can see by the screenshot above, OK means the test completed successfully.

Testing instructions: 64-bit Oracle driver connection

In command prompt, you must change the directory where the tnsping command runs to where the 64-bit Oracle driver version is. In command prompt, first type cd C:\, which will allow you to change the directory to the 64-bit Oracle path. You'll know this is successful when command prompt shows C:\ before the cursor.

tnsping32bit1.png

After this, navigate to your bin folder in your 64-bit Oracle driver folders. Type the following in command prompt, assuming your 64-bit Oracle driver home directory is C:\Oracle64.
cd Oracle64\product\12.2.0\client_1\bin
After this step, the command prompt should look like this:

tnsping64bit1.png

Type tnsping infoaccess. Command prompt should generate some results similar to the screenshot below.

tnsping64bit2.png

You can tell the command successfully used the 64-bit driver by the text TNS Ping Utility for 64-bit Windows: in command prompt. As you can see by the screenshot above, OK means the test completed successfully.

Troubleshooting errors

Your testing may be unsuccessful and generate an error message. If this happens, please reach out to your IT staff for assistance, and be sure to include the error message.




Keywords:Oracle InfoAccess tns TNSnames TNSnames.ora ping tnsping connection connect test testing database driver cd home directory   Doc ID:91673
Owner:Steven T.Group:Office of Data Management & Analytics Services KB
Created:2019-05-09 14:06 CDTUpdated:2020-06-20 04:02 CDT
Sites:Office of Data Management & Analytics Services KB
Feedback:  0   0