Follow the steps to manually upgrade the version 11.4 MDM
database on Oracle to the version 11.5 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.3 to version 11.4 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
- Navigate to the folder MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/Oracle/Standard/ddl and
run the
create_ix_ora.sql SQL upgrade script.
- 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.5.0/Level-I/Oracle/Standard/ddl/data_req_CODE_LANG/data
- MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/Oracle/Standard/ddl/data_CODE_LANG/data-industry
- MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/Oracle/Standard/ddl/data_opt_CODE_LANG/data
- 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.5.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>
- The insert.sql script inserts new
data.
- The update.sql script updates existing
table data.
- 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.
- To load the English industry data, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.5.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>
- The insert.sql script inserts new
data.
- The update.sql script updates existing
table data.
- The delete.sql script deletes obsolete
table data.
- If you are loading data for a language other than English,
run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/Oracle/Standard/ddl/data_<CODE_LANG>/data-industry 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.
- If you are loading code table data for a language other
than English, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.5.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.
- Repeat the previous two steps for each non-English language
that is installed.
- Navigate to the MDM_INSTALL_HOME/database/Upgrade/11.5.0/Level-I/Oracle/Standard/ddl/ directory.
- Edit the script ImpReqDataCfgMgr_ora.script and
replace all placeholder values with the actual values for your environment.
- Run the script ImpReqDataCfgMgr_ora.script.
- 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.4 deployment values.