Changing character set in oracle for cognos installation

[adityaupadhyay]

Hi,

I am trying to install Cognos  8.4 with oracle 10g express edition. When I am trying to test the content store , following error is comng:

[ ERROR ] Content Manager cannot start because the database character set for the content store is not supported. Before you restart Content Manager, you may need to recreate the content store database or clean it using dbClean_*.sql.

I am trying to change the character set. But oracle is not allowing me to do that. Following error is coming:

error ORA-12712: new character set must be a superset of old character set

Please help me in completing the installation. The default character set in oracle 10g express edition is

[MFGF]

Sounds like you will need to drop the original content store database and create a new one using a supported character set.

Regards,

MF.

[chunduri]

the default character set in oracle is ALTF-32 or 16 but cognos only supports unicode(UTF-8).

so u need to change the character set to UTF-8