IBM Support

** ERROR: java.sql.SQLException: I/O exception: The Network Adapter could not establish the connection in Database Conversion Tool when using Oracle

Technote (troubleshooting)


Problem(Abstract)

Customer is configuring a Oracle database connection on the Controller Application server, and while the verify database connection states that Connection Succeeded, when trying to run the Database Convertion Utility they get an error when trying to connect.

Symptom

** ERROR: java.sql.SQLException: I/O exception: The Network Adapter could not establish the connection


Cause

Missing TNS_ADMIN System Environment Variable

Resolving the problem

Add a new System Variable TNS_ADMIN that is pointing to the directory of the tnsnames.ora file

Document information

More support for: Cognos Controller
Controller

Software version: 10.1.1, 10.2.0, 10.2.1

Operating system(s): Windows

Reference #: 1882992

Modified date: 16 April 2015