Can anyone explain the procedure for configuring cognos8
with oracle as Content Manager/Content Store? I know the
configuration of cognos8 with SQL SERVER (Like how to create
CM database in oracle and applying securities to access that
Database from cognos8 (Cognos Configuration)

Answer Posted / vidya

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

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define catalog in cognos and write its various types?

619


What is cognos reporting tool?

613


what is the difference between list report and crosstab report?

712


what are the names of the reports that you prepared?

624


Which studio is used to create reports?

607






How to join multiple db in catalog?

570


How to create a cube in Transformer? What is the process? Please mention process thank u

1334


difference between impromptu and cognos8

1973


Can you define a catalog and types of catalogs in cognos?

572


How to generate cubes in cognos?

567


What is an olap designer?

530


What are the main services provided by application tier?

565


Name the types of report?

555


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

1977


Can you define cognos impromptu?

626