Upgrading an existing InfoSphere RDM version 10.1, 11.0, 11.3, 11.4, or 11.5 database on Oracle

Follow the steps to upgrade your InfoSphere® RDM database on Oracle to version 11.6.

1. Navigate to the RDM_INSTALL_HOME/database/RDMDBScripts/Upgrade directory in your version 11.6 installation.
2. Select the folder of the version that you want to upgrade to. For example, if you are running version 10.1, select the 11.0 folder because you must upgrade to version 11.0 (and then from version 11.0.0 to version 11.3, and then 11.3 to 11.4, and then 11.4 to 11.5) before you can upgrade from version 11.5 to version 11.6.
3. Navigate to the INSTALL_HOME/database/RDMDBScripts/Upgrade/UpgradeVersion/Level-1/myDBMS/Standard/ddl directory
4. If you are running on UNIX, run the dos2unix command on all the scripts in the directory to ensure that the files are in UNIX format.
5. Connect to the RDM database that you want to upgrade using the same credentials and schema name that the RDM instance is using.
6. Roll back triggers and metadata for the RDM version you are running on.
   Refer to the ReadMe file README.txt for details.
   1. As necessary, in your SQL files, replace the SCHEMA placeholders or the oracleadmin schema with the schema name that is used in the database that you are upgrading.
   2. Run the scripts in the order that they are listed, where Version is the version whose triggers you are rolling back (such as 10.01 or 11.0) and log_file_name is the name of your log file.

      1. sqlplus userid/password@host @Rollback_RDM_TRIGGERS_ORACLE.sql -l log_file_name

      2. sqlplus userid/password@host @Rollback_RDM_MetaData_ORACLE.sql -l log_file_name

      3. sqlplus userid/password@host @Rollback_RDM_CODETABLEVALUE_ORACLE.sql -l log_file_name

7. Migrate your databases. Run these scripts in the order that they are listed, where VXX_TO_VXX is one of these migration sequences: V11.5.0_TO_V11.6.0_, V11.4.0_TO_V11.5.0_, V11.3.0_TO_V11.4.0_, V11.0.0_TO_V11.3.0_, V10.1.0_TO_V11.0.0_, or V10.0.0_TO_V10.1.0; and log_file_name is the name of your log file.
   Note: These scripts contain version-specific files. Files that are not required for a specific version do not display in the script for that version.
   1. sqlplus userid/password@host @VXX_TO_VXX_RELEASE_MIGRATION_Create_RDM_Tables_ORACLE.sql -l log_file_name
   2. sqlplus userid/password@host @VXX_TO_VXX_RELEASE_MIGRATION_Create_RDM_FK_Constraints_ORACLE.sql -l log_file_name
   3. sqlplus userid/password@host @VXX_TO_VXX_RELEASE_MIGRATION_DDL_ORACLE.sql -l log_file_name
   4. sqlplus userid/password@host @VXX_TO_VXX_RELEASE_MIGRATION_DML_ORACLE.sql -l log_file_name
   5. sqlplus userid/password@host @VXX_TO_VXX_RELEASE_MIGRATION_Create_RDM_Index_ORACLE.sql -l log_file_name
8. Navigate to the RDM_INSTALL_HOME/database/RDMDBScripts/Oracle directory in your version 11.6 installation.
   This directory contains the metadata for non-English languages.
9. Repopulate the triggers and metadata. Run these scripts in the order that they are listed:

   1. sqlplus userid/password@<db_name> RDM_TRIGGERS_ORACLE.sql > <log_file_name>
      

   2. sqlplus userid/password@<db_name> RDM_METADATA_ORACLE.sql > <log_file_name>
      

   Note: To load English error messages, run the script RDM_ERRORS_100_ORACLE.sql:

   sqlplus userid/password@<db_name> RDM_ERRORS_100_ORACLE.SQL > <log_file_name>
   

   If you do not wish to load any additional languages, skip the remaining steps.
10. For each additional language that you want to support, open the corresponding folder, such as the de folder.
    The folder contains files with these names:

    • RDM_CODETABLES.sql
    • RDM_ErrorMessages.sql
11. Run these commands in the order that they are listed:

    1. sqlplus userid/password@<db_name> RDM_CODETABLES.SQL > <log_file_name>
       

    2. sqlplus userid/password@<db_name> RDM_ErrorMessages.sql > <log_file_name>
       

12. Repeat Steps 10 and 11 for every language that you want to support.