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
Do you have tnsnames.ora in the proper place? SQL Developer probably does not need that..
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.
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.
Thank you dbbits for your link, but ours is 8.4 fix2, the link that you have provided is for 8.4.1.
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
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)))
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
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)".