Manually upgrading the MDM database on Oracle from 11.5 to 11.6

Follow the steps to manually upgrade the version 11.5 MDM database on Oracle to the version 11.6 MDM database. For information about upgrading the database for previous releases, see the links at the end of this topic.

Before you begin

If applicable, upgrade your MDM database from version 11.4 to version 11.5 before beginning this procedure.

Read the content of the link at the end of this topic about manual installation of the database.

For Oracle, the use of table spaces for data, indexes and LOBs, such as CLOBs or XML, to improve database performance is supported. Look for the following placeholders in the scripts: <TABLE_SPACE>, <INDEX_SPACE>, and <LONG_SPACE>.

Procedure

  1. Navigate to the folder MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/Oracle/Standard/ddl and run the following upgrade scripts, in order:
    1. create_tables_ora.sql
    2. create_hist_tables_ora.sql
    3. alter_table_ora.sql
    4. create_ix_ora.sql
  2. Depending on whether your implementation uses simple or compound triggers, run one of the following scripts to create the triggers:
    • create_triggers_simple_ora.sql
    • create_triggers_compound_ora.sql
  3. Depending on whether your implementation uses simple or compound triggers, run one of the following scripts:
    • create_delete_triggers_simple.sql
    • create_delete_triggers_compound.sql
  4. Replace the placeholder <SCHEMA> in the scripts in the following folders with a schema name or owner. Ensure that the name or owner is in uppercase. CODE_LANG in the folder name is the language that is currently installed.
    Note: If any of the directories are empty, no data was generated and you do not need to run the scripts.
    • MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/Oracle/Standard/ddl/data_req_CODE_LANG/data
    • MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/Oracle/Standard/ddl/data_CODE_LANG/data-industry
    • MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/Oracle/Standard/ddl/data_opt_CODE_LANG/data
  5. To load the common data, to load the English code table data, and to configure the table in the language that you selected, run the following script in the MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/Oracle/Standard/ddl/data_req_CODE_LANG/data directory from the command line. Use the command: sqlplus <SCHEMA>/<SCHEMAPASSWORD>@<DBNAME> @<script_name> >> <log_file_name>
    1. The insert.sql script inserts new data.
    2. The update.sql script updates existing table data.
    3. The delete.sql script deletes obsolete table data.
    If you are loading English data only, set CODE_LANG to en. Otherwise, set CODE_LANG to the language code of the language you are loading.
  6. To load the English industry data, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/Oracle/Standard/ddl/data_en/data-industry directory from the command line. Use the command: sqlplus <SCHEMA>/<SCHEMAPASSWORD>@<DBNAME> @<scriptname> >> <log_file_name>
    1. The insert.sql script inserts new data.
    2. The update.sql script updates existing table data.
    3. The delete.sql script deletes obsolete table data.
  7. If you are loading data for a language other than English, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/Oracle/Standard/ddl/data_<CODE_LANG>/data-industry directory from the command line: sqlplus <SCHEMA>/<SCHEMAPASSWORD>@<DBNAME> @<scriptname> >> <log_file_name>
    1. The insert.sql script inserts new data.
    2. The update.sql script updates existing table data.
    3. The delete.sql script deletes obsolete table data.
  8. If you are loading code table data for a language other than English, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/Oracle/Standard/ddl/data_opt_CODE_LANG/data directory from the command line: sqlplus <SCHEMA>/<SCHEMAPASSWORD>@<DBNAME> @<scriptname> >> <log_file_name>
    • The insert.sql script inserts new data.
    • The update.sql script updates existing table data.
    • The delete.sql script deletes obsolete table data.
  9. Repeat the previous two steps for each non-English language that is installed.
  10. Navigate to the MDM_INSTALL_HOME/database/Upgrade/11.6.0/Level-I/Oracle/Standard/ddl/ directory.
  11. Edit the script ImpReqDataCfgMgr_ora.script and replace all placeholder values with the actual values for your environment.
  12. Run the script ImpReqDataCfgMgr_ora.script.
  13. Run the following command: sqlplus <SCHEMA>/<SCHEMAPASSWORD>@<DBNAME> @QryUpdCfgMgrData_ora.sql >> <log_file_name>
    The QryUpdCfgMgrData_ora.sql script populates the Configuration Manager values based on previous InfoSphere® MDM version 11.5 deployment values.