Creating the Cognos Content Store on Oracle

The content store is a database that Content Manager uses to store global configuration data, global settings such as the language and currency formats shown in the user interface, connections to data sources, and product-specific content.

Creating the Content Store includes creating a tablespace and the schema.

See the following sections in the IBM Cognos Business Intelligence Installation and Configuration Guide for information about creating the Cognos Content Store database.

Guidelines for creating the Content Store
Suggested settings for creating the Content Store in Oracle

The high-level process for creating the Cognos Content Store is as follows.

Create a tablespace.
Create the schema.

Example

The following commands show an example of creating the Cognos Content Store.

[testa@oc644 shared]$ sqlplus emptoris_admin@ora11g 
SQL*Plus: Release 11.2.0.1.0 Production on Fri May 8 09:37:45 2015 
Copyright (c) 1982, 2009, Oracle.  All rights reserved. 
Enter password: 
Connected to: 
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options 

SQL> create tablespace ccs_tsp datafile '/opt/app/oracle/oradata/ora11g/ccs_tsp_01.dbf' size 100m autoextend on maxsize 5g ;


SQL> create user cogstore identified by test1 default tablespace ccs_tsp         
    temporary tablespace temp profile default account unlock; 

User created. 

SQL> grant create view, create session, create procedure, create table, create trigger, create sequence to cogstore; 

Grant succeeded. 

SQL> alter user ecm_reporting quota unlimited on ccs_tsp; 

User altered.