IBM Support

How to migrate a Cognos ContentStore Database to Oracle

How To


Summary

The attached document describes the steps how to setup an Oracle c12 Database and how to connect/migrate an existing Tivoli Common Reporting Cognos ContentStore using a DB2 database to a new Oracle database.

Objective

The Oracle c12 R2 release is not supported by Cognos v10.2.2 and has only been tested in the described scenario.
This is what we tested so we know it works using Oracle c12 R1.

Environment

Tivoli Common Reporting v3.1.3 (using Cognos v10.2.2 FP4 + future Fixpacks and using Oracle 12.1.0.1.0 Standard Edition One and future fix packs)

Steps

Please follow the steps described in the following document:

Document Location

Worldwide

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSCTR4J","label":"Tivoli Common Reporting TCR"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
27 April 2020

UID

ibm16191067