Upgrade a database ‌

This section describes how to migrate to a later version of Oracle Enterprise. Some migration scenarios might require additional steps. For details, see the Support knowledge base or contact the support team.

Important: OpenText makes no warranty of any kind in regard to the contents of this chapter, including but not limited to implied warranties of merchantable quality or fitness for any particular purpose. OpenTextshall not be liable for errors contained in it or for incidental or consequential damages in connection with the furnishing, performance, or use of this appendix or associated software. The information in this chapter is subject to change without notice.

Typical upgrade scenario‌

  • You have an existing CM production server running against a local Oracle Enterprise instance.

  • The latest version of the Oracle Enterprise demands more system resources and you have decided that you cannot upgrade the Oracle version on the existing server.

  • You install the Oracle Enterprise on a more powerful system.

  • You migrate your existing production server and Oracle production databases to the new system and upgrade Dimensions CM.

Upgrade path‌

  1. Stop the Dimensions CM listener.

  2. On the new system, create an Oracle instance. See Create a fresh Oracle instance.

  3. On this system, install the Dimensions CM server with an Oracle Enterprise.

  4. On this system, drop the pcms_sys database and the demonstration database.

  5. On the original Dimensions CM server, export your existing Oracle pcms_sys and all the Dimensions databases.

  6. On the new system, import the database export file.

  7. Manually upgrade the imported databases to use the new Dimensions CM schema:

    1. Log in to the Dimensions CM dmdba utility as the Oracle Administration user (typically system):

      dmdba system/<system_password>@<connect_string>

      For example:

      dmdba system/manager@dim14

    2. At the SYSTEM> prompt, enter the following dmdba command:

      upgrade all /force

    3. At the SYSTEM> prompt, enter the following dmdba command:

      exit