ORA Datasource Failures (new install)

[jmon]

I have a new 10.1 build on Win 2008 server (64 bit). My Content Store is up on a local MSSQL 2008 database, but I have not yet installed Framework Manager.

My local Oracle 10.2 (32 bit) client can connect to my ORA DM & ODS DBs using SQLPlus.

I can use the Cognos Admin tool to set up the datasources, but each test fails with:

QE-DEF-0285 The logon failed.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in testDataSourceConnection.

I don't have any User / System / File DSNs defined as ODBC datasources on this server- my take is they are not needed for the Oracle client. My 10.1 datasource configuration items compare favorably with my working 8.4.1 install.

The IBM instr_cr_winux.pdf suggests on page 170 copying some Oracle jars into c10_location/webapps/p2pd/WEB-INF/lib. I tried (10.2's ojdbc14.jar) and (11.2's ojdbc5.jar) but couldn't wiggle the error.

Can anyone please provide a push in the right direction? Thanks.

[jmon]

I built out a completely new second instance, this time using an Oracle 11.2 (32 bit) client. That one comes with an ojdbc5.jar. My connection problem went away.

My conclusion is the Ora 10.2 client won't work with Cognos 10.1 (64 bit). Maybe I'll try upgrading my Ora client on the problem instance to more certain. Thanks.

[jayanthhyd]

you using oracle client?? first check the ping.. in cmd prompt type tnsping dest ip

[jmon]

Yes jayanthhyd- my installation is using an Oracle client.

As reported, my Ora 10.2 runtime client (32 bit) could connect to the various back end DBs when launched from the Cognos 10 Win2008 server. However, testing those datasources from within the IBM Cognos Administration tool all failed.

I replaced the Ora 10.2 client with an 11.2 runtime (32 bit) client on my problem server, and the issue went away.

My conclusion is one must use the Ora 11.2 (32 bit) client with Cognos 10.1 on Win 2008 (64 bit).

[Suraj]

My understanding is Oracle 64-bit client does not work with Cognos unless you have Oracle content store.
All other data sources must use 32-bit Oracle client.