Upgrading Database

About Upgrading Database

The Upgrading Your Database to 9.1.9 Level allows you to upgrade your database server to the current level.

To execute this option, these conditions must be met:

  • On UNIX, you must belong to the dba group.

  • On Windows, you must belong to the ORA_DBA group.

Before upgrading, make sure that the %EDS_HOME% parameter does not contain any spaces. If there are any spaces, you cannot proceed with the upgrade and the error message EDM-1020: Invalid directory. Spaces are not allowed appears.

This task explains how to upgrade the database:
  1. In the Available Database Profiles list of the EDM database selection window, select the database.

    The selected database is highlighted.

  2. Click Select.

  3. In the navigation pad, select Upgrade > Upgrade Explore Database.

    You are prompted to enter the password.

  4. Enter the password, and then click OK. The Upgrade Database window along with the ORACLE_SID appears.

    The Database Name and the current Explore Database Server appears.

    You are not prompted to enter the password if you are upgrading in the same session. You are prompted to enter the password only if you have closed the session, and logged on later. The Database Name and the current CES Database Server level appears.

  5. Click Upgrade to start the database server upgrade.

    You are prompted to confirm the upgrade.

  6. Click Yes to confirm the update.

    Once the upgrade process starts, you cannot cancel or downgrade to an earlier version.

    Before the upgrade process starts, it is recommended to back up your database to avoid any data corruption. Also, make sure that sufficient space is available in the CISDB_SPACE and CISINDEX_SPACE. If you do not have sufficient space in these tablespaces, these error messages are displayed:

    • ORA-01653: unable to extend table %s.%s by %s in tablespace %s

    • ORA-01654: unable to extend index %s.%s by %s in tablespace %s

    You can increase the size of the existing data file or files:

    • SQL> ALTER DATABASE DATAFILE '<data_file_name>' RESIZE <new_size> M/K;

    You can add one or more data files to the tablespace:

    • SQL> ALTER TABLESPACE <TABLESPACE_NAME> NOLOGGING ADD DATAFILE <data_file_name> SIZE <SIZE> M/K

      Where,

      <data_file_name> must be indicated with full path.

    The Progress window appears.

    The upgrade process starts and a series of steps are displayed. When all the steps are completed successfully, a summary of errors appears in the Error Summary tab. The error messages that can be ignored are:

  • ORA-00001: unique constraint violated

  • ORA-00904: "S_USR_PASSWORD_REMINDER": invalid identifier

  • ORA-00904: "S_USR_E_MAIL": invalid identifier

  • ORA-00904: "S_USR_SYS_FLAGS": invalid identifier

The error messages can be ignored in these situations:

  • re-create view for S_GPH_CLASS, column name is S_GPH_BLB_PTR

  • update S_GPO_CLASS, column name is S_GPO_READ_REVOKE

  • drop column S_SCH_MULTI_BYTE, S_RPF_MUTLTI_BYTE, S_EFF_MULTI_BYTE

    • ORA-00955: name is already used by an existing object

    • ORA-00904: invalid column name

    • ORA-01430: column being added already exists in table

    • ORA-01432: public synonym to be dropped does not exist

    • ORA-01451: column to be modified to NULL cannot be modified to NULL

    • ORA-01408: such column list already indexed

    • ORA-00942: table or view does not exist (This error can be ignored only when you try to drop a table or a view.)

    • ORA-01418: specified index does not exist

    • ORA-02289: sequence does not exist (This error can be ignored only when you try to drop a sequence.)

After the database is upgraded, a confirmation message appears.

  1. Click OK to exit.