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
What is meant by drill down?
What are all the components of Report Studio?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
How is possible this scenario using in type-in prompt.?
what is a prompt value in report studio and variables ?
What is the use of report studio?
How create measures and dimensions?
what is power prompt in cognos ep7series?what is the use of this?
----------------Diff b/w Dimensional modeling and Relational modeling?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What is a Query Subject?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
How to publish a package by running Java Script?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?