Content Manager can not setup

[Eag. E]

Hi

I just switched to Oracle (as content store), and I got the following error message when testing my content manger

Code Select Expand

[ ERROR ] Content Manager failed to connect to the content store. The connection string is "jdbc:oracle:thin:@10.0.2.251:1521:ORCL". The error encountered is: "Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
"

My Oracle server is at 10.0.2.251, I think the configuration should be fine (see attached screenshot)

Thanks so much for any kinds of suggestion

E

[MFGF]

Hi

I just switched to Oracle (as content store), and I got the following error message when testing my content manger

Code Select Expand

[ ERROR ] Content Manager failed to connect to the content store. The connection string is "jdbc:oracle:thin:@10.0.2.251:1521:ORCL". The error encountered is: "Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
"

My Oracle server is at 10.0.2.251, I think the configuration should be fine (see attached screenshot)

Thanks so much for any kinds of suggestion

E

Hi,

ORA-12505 errors mean either your instance isn't known by the listener or you're connecting with the service name not the SID.

Take a look at the post below for some good debugging tips:

http://www.dba-oracle.com/sf_ora_12505_tns_listener_does_not_currently_know_of_sid_given_in_connect_descriptor.htm

What version of Cognos 10 are you using? Cognos 10.2.2 no longer supports Oracle 10g as a content store - Oracle 11g and 12c are supported for this release. You'd need to be on an older version of Cognos BI than 10.2.2 for Oracle 10 to be a supported content store.

Cheers!

MF.

[smiley]

To test the connection on SID name, the command is "tnsping ORCL"

[Eag. E]

To test the connection on SID name, the command is "tnsping ORCL"

This test success

Code Select Expand


C:\Users\Administrator>tnsping ORCL

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 07-APR-2
016 08:04:33

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

Used parameter files:
C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 10.0.2.251)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (0 msec)

[MFGF]

What version of Cognos BI are you using? One of your other posts suggests it might be 10.2.2? If so, Oracle 10 isn't supported as a content store for that release - you need a newer version of Oracle.

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

MF.

[Eag. E]

What version of Cognos BI are you using? One of your other posts suggests it might be 10.2.2? If so, Oracle 10 isn't supported as a content store for that release - you need a newer version of Oracle.

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

MF.

Hi MF.

Cognos 10.2.2 + Oracle 11gR2
It should be supported .

Thanks

[prikala]

What is the SID of your database?
SID is not necessarily same as SERVICE_NAME and I think simple Oracle configuration in Cognos Configuration uses SID.

edit: Actually the error string in your first post says connection is tried with SID. Your tnsping test uses ORCL as SERVICE_NAME.

[Eag. E]

What is the SID of your database?
SID is not necessarily same as SERVICE_NAME and I think simple Oracle configuration in Cognos Configuration uses SID.

Hi,

It is "ORCL" as my SID in server. For easy to remember.

Thanks

E

[johnck77]

What OS is this on? If its Linux you need to copy the ojdbc5.jar, for 11g different oracle versions need different files copied, from the oracle install, its in the oracleintsall/client/instantclient directory, to the cognosinstall/webapps/p2pd/WEB-INF/lib directory.

Sorry if you've already done this and/or its not relevant, but I've missed it before and was pulling my hair out trying to work out what was going on. I cant remember if you need to do something similar on windows, but wouldn't surprise me.

[Eag. E]

What OS is this on? If its Linux you need to copy the ojdbc5.jar, for 11g different oracle versions need different files copied, from the oracle install, its in the oracleintsall/client/instantclient directory, to the cognosinstall/webapps/p2pd/WEB-INF/lib directory.

Sorry if you've already done this and/or its not relevant, but I've missed it before and was pulling my hair out trying to work out what was going on. I cant remember if you need to do something similar on windows, but wouldn't surprise me.

Thanks lib has been added before the issue.

[Eag. E]

Issue solved.
This is a pure Oracle server/client issue, DBA helps.

Thanks for all your replies