If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

will cognos 8.4 support oracle 11g R2

Started by hrk551, 21 Jun 2011 01:39:43 PM

Previous topic - Next topic

hrk551

We have recently installed Oracle 11g R2 on a RAC and I am trying to point our Dev to it. But I am not successful in doing this. I was geeting an error Tns: no listener. But when I try same credentials from a SQL developer I am good.

Thank you

cognostechie

Do you have tnsnames.ora in the proper place? SQL Developer probably does not need that..

hrk551

Yes, I have placed TNS in Tnsnames.ora. Our developmet environment works good when pointed to oracle 11.01.07. But hwne I point this to our new environment 11g r2 then we have this TNS issue.

bdbits

Oracle 11g R2 is officially supported.
https://www-304.ibm.com/support/docview.wss?uid=swg27017522&wv=1#db_reporting

Since it is supported, you could always open a ticket with IBM.

hrk551

Thank you dbbits for your link, but ours is 8.4 fix2, the link that you have provided is for 8.4.1.

bdbits

Then I believe 11gR2 is not supported. It was not even supported under 8.4.1 until fp2. You can check with IBM, but it is not listed on the 8.4 page.

https://www-304.ibm.com/support/docview.wss?uid=swg27014110#db_reporting

satish_psk

hrk551,

We had the same issue connecting to Content store when we upgraded.

We resolved by changing the Content store connection info in cognos configuration,

in Oracle Advance and in Database string, make your tnsentry in one liner like below;

copy and paste your tns entry - it worked like  a charm

(DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = xyz-rac-dwh01-vip)(PORT = 1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = xyz-rac-dwh02-vip)(PORT = 1521))(LOAD_BALANCE = yes))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = dwh1)))

megatrack67

WE are using oracle 11Gr2 with cognos 32 and 64 bit and we have no issue at all

One thing

On 32 bit we are using the ojdbc5.dll but on the 64 bit we had to use the ojdbc14.dll in order to get connection

Regards

PC



Paddy_K

We are on Cognos BI 8.4.1 FP2 32 Bit with ojdbc5.jar.
Metric Server 8.4.1 FP2 was 32 bit and didn't want two environments to maintain.

Our Content Store in clustered environment - Oracle 11gR2 RAC - configured without error, like indicated by few others here.

Key to remember: replicate the appropriate TNSNAMES.ORA entry "(DESCRIPTION =()...)))))", in ONE LINE w/o any carraige returns, in value field of porperty "Database Specifier" under "Oracle Database(Advanced)".