To set oracle Database at Content managet:

1> start Cognos confg. at content manager

2> In the explorer window, under data Access, content 
Manager Delete Content manager to select right clk.

3> Right clk content manager, and then clk New resource 
Oracle Database.

4> In the Name box, type name for Resource.

5> At type box, type name for resource.

6> In properties window, provide value depend on Database 
type.
Put appropriate value for Database Server and portno, 
service Name Properties.

7> If you want to change the Logon credential specify a 
user ID and PW, clk the value box next to the user ID &PW 
property then clk the Edit Button.

8> From the file menu, clk save.

The logon crtedentials are immediatly Encrypted, Content 
Manager Now able to create the required table in the 
content Store with Oracle Database.

Regards,
Vidya
SSE, SCSL.

 Thanks for your help Vidya. 
You have given the details for Cognos Configuration area
only. Can you help me how to create a new database in
oracle? (For example i want to create database name CM).
Also how to give access permission(User-ID and Password) for
that database in oracle. In SQL SERVER 2000, we can create
new database directly(Just Right clicking New database) also
we can give login details in Security area of SQL Server
Enterprise Manager. Like that Can we create in
Oracle Enterprise Manager? The same User ID & Password we have to
give in Cognos Configuration.  Pls help me. 

Hi Valraj

I written there steps to Configure Cognos8 with Oracle 
Database. After read ur's view I come to know that you do 
not have single Day exp. in Cognos so you asking ambiguous 
things.

My answer was to help Real time working Associate who have 
any trouble to configure cognos, Not for any false or fake 
candidate to Qualifying Any Interview.

Create any Database on Oracle is not responsibility of a 
Cognos Reporting team. Oracle Functional or DBA Associate 
will responsible for Database creation in Oracle. 
Securities can be Define at Cognos framework manager for 
Cognos Reporting.

Being a OCA Certified associate I can tell you few steps 
for create Database at Oracle it may help you beco’z I come 
to know that u r a beginner in IT industry:
 Steps are:

1> Create initialization file spfle &pfile 
( '/ora/xyz/int.ora; )

2> Create a database creation script (@crdb.sql)

3> Connect to the instance

4> Decide &set ORACLE_SID

4> Create db Authentication   db_name= ...

5> connect to the instance

6> Create a server parameter file

7> start the Instance

8> Issue the create Database

9> create Additional tablespaces

10> Run script to build Data Dictionary view

11> Run script to install any additional reqiered

For Create a password u may write script as:
Create user username identified by passward default 
tablespace data quata unlimited on data;

on unix env. you may write as:
$ orapwd file= $ORACLE_HOME/dbs/orapwxyz
 password = oracle

regards,
Vidya
SSE, SCSL