Migration of CMS between MySQL and Oracle 10
I wonder if anyone can help with the problem I am experiencing.
I installed BO XI 3.1 SP2 onto a Windows 2003 server (no clustering - only one machine) using the default MySQL database for the CMS and Audit databases.
I now want to change the CMS database to be Oracle. I migrated the DB using SQL Developer which complained of two indexes SI_CUID and SI_GUID not being able to be created uniquely. The solution presented was to remove the unique statement from the script which I did and then ran the script successfully.
I'm now having difficulty in changing the configuration of the SIA properties.
There is a fix 'ADAPT01299996' in Service pack 3 which deals with the following:
"When Installing or re-initializing on a Unix or Linux system, the installation will sometimes fail because the Central Management
Server (CMS) displays an error message about duplicate Global Unique Identifiers (GUID), and then it terminates unexpectedly" Whilst the fix refers to Linux and Unix operating systems there are windows components on this fix?
I'm wondering if applying SP3 will resolve the issue?
Appreciate any comments?