Validate the database connection

To validate the database connection from the Oracle InForm Application Server, the Cognos Report Server, and the Cognos Content Manager Server

• Type the following command at the Windows command prompt:

  
  sqlplus pfdbadmin_userID@tnsnames_alias

  When prompted, enter the pfdbadmin password.

  The default user name for the pfdbadmin database account is pfdbadmin.

If the test is successful, a SQL prompt appears, showing that you have logged on to the database server as the pfdbadmin user. An unsuccessful test generates an ORA- error. Consult your database administrator for help in troubleshooting errors.

Note:

Problems with connections can sometimes be attributed to the database server that contains a single Ethernet card with two nodes. Disabling one of the ports from the card usually solves the problem. Consult your system administrator for help in resolving errors.