Create the Content Store Database

The Content Store is a database used by Flexera Analytics to store information about reporting models, folders, reports, and saved results.

On Linux, only an Oracle content store is supported.

Create an Oracle Content Store (12c Release 1)

To create an Oracle Content Store:

1.

Download the Oracle database client software (12c Release 1, 64-bit) from the Oracle website to the same machine as Cognos is installed.

2.

Create a database (on your nominated data center server) with the following settings:

•

Database character set: AL32UTF8

•

National character set: AL16UTF16

Note:Flexera Analytics will not work if the Oracle database is not created with these settings.

3.

Create a user account that will be used to access the database and use an appropriate user name. (For example, csuser.) Ensure that the account has permission to do the following:

•

Connect to the database.

•

Create, alter, and drop tables, triggers, views, procedures, and sequence.

•

Insert, update, and delete data in the database tables.

4.

Create a tablespace where the Content Store schema will be created. The tablespace should be at least 150 MB in size. For example, in SQL*Plus, the command would be:

create tablespace CONTENTSTORE datafile 'path/contentstore.dbf' size 150M autoextend on;

5.

Run netca and create a local net service name which connects to the service of the Oracle server.

6.

From the command line, enter the following commands:

•

Set LD_LIBRARY_PATH = cognos_installed_location/bin:$ORACLE_HOME/lib

•

Set TNS_ADMIN=$ORACLE_HOME/network/bin.