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)
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