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 a prompt value in report studio and variables ?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What is the information present in the cognos configuration file?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
What is difference between content store and content manager?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What do you mean by drill across?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
Can you define cognos impromptu?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
Can you define bitmap index?
How to a create header dynamically in a crosstab report in cognos 8.1?
Why is auto-regression used in forecasting used on cognos platform?
How do we convert from Numeric to be Words?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.