CSE Installation and Configuration › Prerequisites for CSE Configuration › Configuring Databases › Considerations for Moving an Oracle CSE to a New Database Instance

Considerations for Moving an Oracle CSE to a New Database Instance

When you have an Oracle CSE on Windows or UNIX, to move that CSE to a new Oracle instance, consider the following cautions.

You populate the new encyclopedia by using the Oracle tools to export the old database and then import into the new database, or you use the CSE tools for copying models.

If you choose to use the Oracle export and import tools, create the new database using the same character set the old database used. If the character set values differ, the import step attempts to do code page translation from the old character set to the new character set. Some model properties store non-character data that is designated as character properties. CSE also supports models in several code pages in the same encyclopedia. It is impossible for Oracle to do the correct code page translation for all models in the encyclopedia. Some models may be corrupted if you change the database character set between the export and import steps.

Choosing to use the CSE tools to copy models avoids these problems. If changing standards at your site require changing the character set for the new Oracle database instance, use the CSE tools for copying models to populate the new encyclopedia. You could keep the two encyclopedias separate and could use download with upload to copy the models. Using advanced configuration features, you can link the two encyclopedias and can use the cross-encyclopedia functions to copy the models.

In both these cases, you are creating a new encyclopedia and must assign a new encyclopedia ID to it to keep both encyclopedias running simultaneously, such as while you are doing the upgrade project. When using the CSE copy model tools, assign the new encyclopedia ID while configuring the CSE, before copying models. When using export and import, assign the new encyclopedia ID before changing to the models in the new encyclopedia. Use the Support Client to change the ID in the encyclopedia database and the Coordination Client to change the ID in the encyclopedia registry tables.