Trouble connecting to the content store(11.0.4,oracle11g)

[DAHA]

Hi friends, I have installed cognos 11.0.4 datatier, application, optional gateway on a single server. I used Oracle 11g database for content store. I am able to test the content store connection in the Cognos Configuration. But when I want to start service, these error logs pop up:

CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.  CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. Cause: CM-CFG-5137 Content Manager was unable to complete the initialization of the content store. For more information, review the log file. Before you restart Content Manager, you may need to recreate the content store database or clean it using dbClean_*.sql

I had researched online and found these links:
http://www-01.ibm.com/support/docview.wss?uid=swg21342265
http://www-01.ibm.com/support/docview.wss?uid=swg21340046

I asked the DBAs to follow the links to reconfigure the content store. But the same errors still exist after the changes. Any ideas, what might gone wrong?

Cheers
DAHA

[prikala]

I have been in a situation where the dba did not check what he had done. He thought he gave the correct permissions but he did not.

This is easy to check if you are comfortable with oracle: Try to create some tables, triggers etc yourself, see if anything fails.

[Penny]

Hello

We are looking at installing Cognos 11 very soon and our current content store (we are running Cognos 10.2.2 on Windows Server 2012 with a separate gateway and SSO is enabled)  is also an Oracle 11g database.  I believe that we are using the native Oracle client from our existing Cognos servers to talk to Oracle, but I understand from the IBM website that:

Cognos 11 supports Oracle 11g or 12c for a Content Store but only via JDBC with the Unicode character set.

I am a little confused by this and wondered if anyone could help me understand the issues better.   I am trying to determine if we can move to Cognos 11 or not and admit that some of this is new for me.

Thanks in advance for any advice that you might be able to provide.

[MFGF]

Hello

We are looking at installing Cognos 11 very soon and our current content store (we are running Cognos 10.2.2 on Windows Server 2012 with a separate gateway and SSO is enabled)  is also an Oracle 11g database.  I believe that we are using the native Oracle client from our existing Cognos servers to talk to Oracle, but I understand from the IBM website that:

Cognos 11 supports Oracle 11g or 12c for a Content Store but only via JDBC with the Unicode character set.

I am a little confused by this and wondered if anyone could help me understand the issues better.   I am trying to determine if we can move to Cognos 11 or not and admit that some of this is new for me.

Thanks in advance for any advice that you might be able to provide.

Hi,

Wherever Cognos 8/10/11 etc uses a database as a content store, it sets up its own connection under the covers via JDBC. This is separate and apart from using the same (or a different) database as a reporting data source, where connectivity for reporting can be via native client, jdbc, odbc etc. As long as you have a supported database version for use as a content store, you should be fine. In your case, Oracle 11g fits the bill nicely :)

Cheers!

MF.

[Penny]

Thank you MFGF.  That is helpful.