COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: renarios on 25 May 2010 03:45:28 AM

Title: Migrating Cognos repository from Oracle 9 to 10
Post by: renarios on 25 May 2010 03:45:28 AM
Hi all,

I'm planning to migrate the repository with the mstore and cstore from Oracle 9i to Oracle 10g. I can't find any information on that subject.
Can I just create an AL32UTF8 database to store both schema's?
Do I have to run certain post-migration sql scripts?

Any help would be appreciated.

Cheers,
Renarios
Title: Re: Migrating Cognos repository from Oracle 9 to 10
Post by: kmuller on 26 May 2010 02:44:16 PM
How do you plan on migrating it?  A db migration?  If so, shut down cognos and have your dba's migrate your db instance over and then point cognos to the new instance.