Test Oracle connection fails - For Configuration (Data Source Connections)

[JosephStreet]

Hi, I'm currently configuring a new intallation of Cognos on WinSrv2008. Within Cognos Administration I've clicked on Configuration, to configure a data source. (Oracle 11g data source).

I've click Test the connection.

There are two dispatcher available for this installation.  I've selected both dispatcher URL and click Test. (also added the User ID and password for my oracle source).

The connection string,

^User ID:^?Password:;LOCAL;OR;ORACLE@%s@test/%s@COLSEQ=IBM_JD_CNX_STR:^User ID:^?Password:;LOCAL;JD-OR;URL=jdbc:oracle:oci:@test;DRIVER_NAME=oracle.jdbc.driver.OracleDriver

Test is valid name in my TNSNames.ora

This fails and has the following error message

Oracle / Compatible  Failed  QE-DEF-0285 The logon failed.
Oracle (JDBC) / Dynamic  Failed   XQE-GEN-0002 An unexpected exception occurred: ocijdbc11 (Not found in java.library.path)

[Rahul Ganguli]

Hi,

Can you please try to put the complete tns entry in connection string, this might be because TNSNames.ora is not recognized by cognos. This way your first error will be gone.
For second error you have to copy the ojdbc6.jar file from oracle to Cognos bin/bin64 directory.

Regards,
Rahul