Hi
I just switched to Oracle (as content store), and I got the following error message when testing my content manger
[ 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
Quote from: Eag. E on 06 Apr 2016 08:08:38 AM
Hi
I just switched to Oracle (as content store), and I got the following error message when testing my content manger
[ 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.
To test the connection on SID name, the command is "tnsping ORCL"
Quote from: smiley on 07 Apr 2016 02:58:06 AM
To test the connection on SID name, the command is "tnsping ORCL"
This test success
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)
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.
Quote from: MFGF on 07 Apr 2016 03:09:15 AM
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
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.
Quote from: prikala on 07 Apr 2016 03:24:53 AM
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
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.
Quote from: johnck77 on 07 Apr 2016 12:15:42 PM
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.
Issue solved.
This is a pure Oracle server/client issue, DBA helps.
Thanks for all your replies