Validate the database connection
To validate the database connection from the 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.