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

cognos 10.2.2 datasource connection Error with oracle 11g

Started by bhupalalerts@gmail.com, 02 Feb 2017 05:44:30 AM

Previous topic - Next topic

bhupalalerts@gmail.com


Hi All,

I have installed Oracle 11g and Cognos 10.2.2 in my machine and imported gosales samples into Cognos.
In Cognos configuration, content store test connection was successful with oracle DB and was able to start cognos configuration successfully.
But in Cognos administration, Datasource connection to connect gosalesdw schema, is failing error message with OCI (Oracle Connection String) and successful with JDBC connection String.TNS.ORA also  verified. [/img][/img][/img][/img][/img][/img][/img][/img][/img][/img]

Because of OCI connection failure I am getting below error when running reports.

"QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: great_outdoors_warehouse UDA-SQL-0031 Unable to access the "great_outdoors_warehouse" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.UDA-SQL-0532 Data Source is not accessible: "XE".ORA-12154: TNS:could not resolve the connect identifier specified "

I can able to connect directly  from  oracle with the same user id/PWD.  And I checked the drivers also in ODBC its fine. Do  I need to  add any special  setup in Cognos  to work ?

bensah

Please check the oracle client version. It should be 32 bit. Add the ojdbc5.jar and ojdbc6.jar to c10_location\webapps\p2pd\Web-Inf\lib directory.

Thanks,
Benu

MFGF

Quote from: bhupalalerts@gmail.com on 02 Feb 2017 05:44:30 AM
Hi All,

I have installed Oracle 11g and Cognos 10.2.2 in my machine and imported gosales samples into Cognos.
In Cognos configuration, content store test connection was successful with oracle DB and was able to start cognos configuration successfully.
But in Cognos administration, Datasource connection to connect gosalesdw schema, is failing error message with OCI (Oracle Connection String) and successful with JDBC connection String.TNS.ORA also  verified. [/img][/img][/img][/img][/img][/img][/img][/img][/img][/img]

Because of OCI connection failure I am getting below error when running reports.

"QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: great_outdoors_warehouse UDA-SQL-0031 Unable to access the "great_outdoors_warehouse" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.UDA-SQL-0532 Data Source is not accessible: "XE".ORA-12154: TNS:could not resolve the connect identifier specified "

I can able to connect directly  from  oracle with the same user id/PWD.  And I checked the drivers also in ODBC its fine. Do  I need to  add any special  setup in Cognos  to work ?

Hi,

The key clue in this error message is the part that says:

ORA-12154: TNS:could not resolve the connect identifier specified

This is Oracle telling you what it doesn't understand when Cognos is trying to connect.

Take a look at the following Oracle doc, with good suggestions on how to resolve this specific message:

http://docs.oracle.com/cd/B19306_01/server.102/b14219/net12150.htm

Cheers!

MF.
Meep!