Content Manager Connection Problem in Oracle (Error CM-CFG-5036)

Starting the IBM® Cognos® Service does not create the tables in an Oracle Content Manager.

One of the following error messages is generated:

CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.

CM-CFG-5036 Content Manager failed to connect to the content store.

CM-SYS-5007 Content Manager failed to start. Review the Content Manager log files and then contact your system administrator or customer support.

When you create a new database in Oracle, the SID name that is created has no underscore in it. You must use this SID with no underscore as the Service Name in IBM Cognos Configuration.

Procedure

  1. Ensure that you can contact the Oracle instance through tnsping <SID> where the <SID> does not contain an underscore.
  2. Configure the Oracle Content Manager connection in IBM Cognos Configuration so that the Service Name is the same as the <SID> in step 1.