COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: velraj.sudhir@gmail.com on 28 Oct 2010 04:48:30 AM

Title: Problem with connecting to Content store
Post by: velraj.sudhir@gmail.com on 28 Oct 2010 04:48:30 AM
Hi all,

I am new to this group and this is my first post.
Currently i am facing some issues with installing Cognos 8.3
I have installed cognos server,framework mgr,apache web server,oraclexeuniv.exe(oracle 10g express edition).
I am able to start all the services (cognos,oracle and apache web server).
I am also able to publish a package from FM.

When i tried to connect my content store , it connected. But for the second time it showed the following error.

Content Manager is unable to initialize the content store by using the initialization file "C:\Program Files\cognos\c8\configuration\schemas\content\oracle\dbInitTest_oracle.sql".

I chked the net for a soln.
Some said , could be a privilege problem . I provided dba rights for the user i created in oracle.
other said  it is  "no quota has been allocated for this user."
I attempted to grant unlimited quota on all permenant tablespaces for the user i created.Even that didnt work.

Could anyone let me know , what the exact solution is?
Should i need to install another version of oracle?


Thanks in advance.  :)

Regards,
sudhir
Title: Re: Problem with connecting to Content store
Post by: rocket on 28 Oct 2010 03:31:39 PM
Test
Title: Re: Problem with connecting to Content store
Post by: velraj.sudhir@gmail.com on 29 Oct 2010 10:40:55 AM
Guyz , pls . I need a solution soon.
Title: Re: Problem with connecting to Content store
Post by: velraj.sudhir@gmail.com on 30 Oct 2010 06:16:43 AM
Hi all,

The issue is resolved.
I gave the folowing sql cmd.

ALTER DATABASE DATAFILE 'C:\oraclexe\oradata\XE\SYSTEM.DBF' AUTOEXTEND ON NEXT 1M  MAXSIZE UNLIMITED;

Thanks for the views. :)

Regards,
sudhir