Testing the connection to the OpenPages database from the Oracle database client

Test whether the SQL*Net connect string can connect to the IBM OpenPages® with Watson™ database on the Oracle database server from the Oracle database client.

Procedure

  1. Copy the file <ORACLE_HOME>/network/admin/tnsnames.ora from the Oracle database server operating system to the <ORACLE_HOME>/network/admin Oracle database client directory on the application server or reporting server.

    Ensure that the OpenPages installation user has read, write and execute permissions on the tnsnames.ora file in the Oracle database client operating system.

  2. Log on to the application server or reporting server as an OpenPages installation user.
  3. Edit the file <ORACLE_HOME>/network/admin/tnsnames.ora, and update the Host value to the host name or IP address of the Oracle database server.
  4. To test the connection to the OpenPages database on the database server, type the following command: 
    sqlplus <username>/\"<password>\"@<service_name>

    For example, sqlplus system/\"password\"@op

    The system connects you to an Oracle database instance.

  5. To exit SQL*Plus, type exit.