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

Jaycognos
Profile Answers by Jaycognos Questions by Jaycognos
Dec 5th, 2007
4
8947

Questions by Jaycognos answers by Jaycognos

Cognos

Answer

Showing Answers 1 - 4 of 4 Answers

rtimothy
Profile Answers by rtimothy

Dec 7th, 2007

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

Jaycognos
Profile Answers by Jaycognos Questions by Jaycognos

Dec 14th, 2007

thanks rtimothy its working.

sreedil
Profile Answers by sreedil

Nov 12th, 2008

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.

phamminhtruong
Profile Answers by phamminhtruong

Jan 13th, 2009

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