Upgrading Cognos 8.4.1 to 10.1.1 issue to connect Oracle database in admin

[TEVAMANA]

Hello,

I am very confused.

I have upgraded an env from 8.4.1 to 10.1.1. W2008R2 64 bit Cognos 10.1.1 64 bit

Everything is fine... but I can't connect to Oracle database 11g that is on the same server using OCI.  It works fine with JDBC.

So I realised that only 64 bit driver has been installed, so I installed 32 bit driver and copy ojdbc5.jar to WEB-INF/P2PD/lib.

The error message changed but still get the issue, see error message below.

Question: what is the first library to define in PATH: 64 or 32 ? because it seems that my issue is linked to this...

Help would be appreciated.

Many thanks in advance

QE-DEF-0285 Echec de la connexion.
QE-DEF-0323 L'objet DSN(ODBC)/ServiceName n'est pas valide. Soit le DSN est manquant, soit l'hôte n'est pas accessible.
RQP-DEF-0068 Impossible d'établir la connexion à au moins une base de données pendant une connexion à 1 bases de données dans '
    testDataSourceConnection
'.
UDA-SQL-0031 Impossible d'accéder à la passerelle 'testDataSourceConnection'. Vérifiez que les paramètres de connexion à la base de données sont correctement configurées. Par exemple, assurez-vous que la connexion à la source de données contient les informations de code d'accès, tel que le mot de passe, pour se connecter à la base de données.
UDA-SQL-0532 La source de données n'est pas accessible : "xxxxxxxx".
ORA-12154: TNS : l'identificateur de connexion indiqué n'a pas pu être résolu

[MFGF]

This looks very much to me like you have an issue with your TNSNAMES.ORA file. The big giveaway is the error coming back from Oracle:
ORA-12154: TNS:could not resolve the connect identifier specified (or l'identificateur de connexion indiqué n'a pas pu être résolu in French)

Take a close look at the file and see if there are any errors in it.

Regards,

MF.

[TEVAMANA]

Thanks a lot for your answer !!!

I did not find yet a solution to this problem... because if I use tnsping command, it works fine so I have to conclude that my tnsnames.ora is fine !!!

Could you confirm that it is possible to connect a dispatcher configured in 32 bit (OS=WS2008R2) to a Oracle DB 64 bit (Oracle 11g 64 bit) with a 32 bit driver ?

Still working to find a solution to connect to Oracle database.

Regards

[MFGF]

Hi,

Yes - it is possible to connect to Oracle 64 bit as long as you are using the Oracle 32-bit client libraries. Even in a 64 bit install of Cognos 10, CQM (compatible query mode) is still 32 bit and needs the 32 bit Oracle libraries. Are you sure the 32 bit libraries come first in the PATH?

Cheers!

MF.

[TEVAMANA]

Hi,

The first library in the path is the 64 bit library: if I use TNSPING:

TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 27-NOV.
-2012 10:10:35

So that would be my issue - I know it is linked to 32 and 64 bit library - but when the 32 bit is defined in first, I got a error message when I tried to use tnsping: that would mean that the 32 library has not been installed ?

Thanks a lot for your answer

Regards

[MFGF]

Hi,

You might try uninstalling the 64-bit Oracle client libraries and running with just the 32-bit to see if that fixes your issue. Also, there is a useful document on the IBM support site which might help in troubleshooting:

http://www-01.ibm.com/support/docview.wss?uid=swg21341734

Cheers!

MF.

[TEVAMANA]

Hello MFGF,

Well, I can't uninstall 64-bit Oracle client librairies because it came with the 64-bit Oracle database installed on the same server as Cognos.

Futhermore, after changing the PATH variable to get in first the 32-bit library, here's the result of the tnsping (it was fine with 64-bit tnsping):

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 27-NOV.
-2012 13:22:00

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage
3512 not found; No message file for product=NETWORK, facility=TNSMessage 3513 n
ot found; No message file for product=NETWORK, facility=TNSMessage 3509 not foun
d; No message file for product=NETWORK, facility=TNS

Well this is normal as there are no ADMIN folder in the 32-bit Oracle client librairies but in db_home (64-bit Oracle):

I suspect that my issue from the beginning comes from the fact that DB Oracle installation has been done without 32 bit librairies.  So to solve this issue, we have to uninstall 32-bit Oracle client librairies and review the installation of the 64-bit Oracle 11g to add 32-bit librairies.

What do you think about ?

Many thanks for your help, I really appreciate

[TEVAMANA]

I forgot to say that I copied ADMIN folder to get tnsnames.ora, listener.ora and sql.ora which did not change the error message.

[TEVAMANA]

Everything is fine.

So we have done a full installation of the 32 bit client, and now we can connect to the Oracle database.

Many thanks

[MFGF]

Great news! Glad everything now works! :)

[TEVAMANA]

Thanks a lot MGMF

The customer reviewed its Oracle installation and reinstalled 32 bit Oracle client library.
Everything is working fine now !!!
So if you have a Oracle connection issue:

1) try to run a dos command: tnsping <database name>
2) if the command failed:

1) Check the global variables of PATH, for Cognos the first library has to be the 32 bit !
2) Check the driver you copied in WEB-INF\lib has to be a 32 bit oracle client !
3) Check your tnsnames.ora

Regards

[Markus]

Hi,

this is only necessary, if running the 32 Bit Reporting-Engine. Otherwise there is no need for 32 Bit Libs!

Kind regards

Markus

[MFGF]

Hi,

this is only necessary, if running the 32 Bit Reporting-Engine. Otherwise there is no need for 32 Bit Libs!

Kind regards

Markus

...which is true, but you need to be aware of the implications of doing this. It disables all CQM functionality, and limits you to only those data sources currently supported by DQM.

MF.