Cognos - how to configure content store in Cognos?

GeekInterview.com > Interview Questions > Data Warehousing > Cognos

Go To First | Previous Question | Next Question

Cognos | Question 123 of 180

how to configure content store in Cognos?

my OS is windows XP Prof , back-end oracle 9i , i tried to install cognos repertnet8.2 , but couldn't able to start the service..content store is not configured correctly. what are the steps to configure it and how to create a new database for content store?

thanks

Total Answers and Comments: 4

Last Update: January 14, 2009 Asked by: Jaycognos

Sponsored Links

Best Rated Answer

—

Submitted by: rtimothy

Go to Cognos Configuration

look for Content Manager

Delete the default COntent Store For SQL Server

Right Click Content manager and create a new content store

Give data base name as Oracle

Give the user id ,Password you created in oracle with DBA rights

Give SID of oracle database you gave when installing it.

save changes to project

Test settigs and start services

Above answer was rated as good by the following members:
ASHOK1324

December 07, 2007 02:37:22

rtimothy

Member Since: December 2007 Contribution: 1

RE: how to configure content store in Cognos?

Go to Cognos Configuration

look for Content Manager

Delete the default COntent Store For SQL Server

Right Click Content manager and create a new content store

Give data base name as Oracle

Give the user id Password you created in oracle with DBA rights

Give SID of oracle database you gave when installing it.

save changes to project

Test settigs and start services

Is this answer useful? Yes | No

1 0

Overall Rating: +1

December 14, 2007 02:56:08

Jaycognos

Member Since: November 2007 Contribution: 17

RE: how to configure content store in Cognos?

thanks rtimothy its working.

Is this answer useful? Yes | No

November 12, 2008 08:15:27

sreedil

Member Since: June 2008 Contribution: 2

RE: how to configure content store in Cognos?

Go to Cognos Configuration

look for Content Manager

Delete the default COntent Store For SQL Server

Right Click Content manager and create a new content store

Give data base name as Oracle

Give the user id Password you created in oracle with DBA rights

Give SID of oracle database you gave when installing it.

save changes to project

Test settigs and start services

all of these ok. but when I go to test settings then I got a error i.e.
"Content Manager failed to start because it could not load driver "oracle.jdbc.driver.oracleDriver" "...........

please tell me the solution.
thanks.

Is this answer useful? Yes | No

January 13, 2009 21:57:14

phamminhtruong

Member Since: January 2009 Contribution: 1

RE: how to configure content store in Cognos?

Hi sreedil

I am also newbie of Cognos. Your problem is caused of Oracle JDBC driver loading. So you copy classes12.jar (> 10g) or classess12.zip (< 9i) in Oracle folder ($ORACLE_HOME/jdbc/lib) to cognos_home/c8/webapps/p2pd/WEB-INF/lib directory. You close Cognos Configuration and open it to start service.
Hope it useful

Pham Min Truong Vietnamese

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank