Troubleshooting
Problem
When installing InfoSphere MDM with an Oracle 12cR2 database, the database connection test fails on the Database Configuration panel in IBM Installation Manager.
Cause
The Java version used by Installation Manager is lower (1.7 ) than the version used in Oracle 12cR2, resulting in a compatibility issue that causes the connection test failure.
Environment
Oracle 12c R2
Diagnosing The Problem
The connection test from the Database Configuration panel will work if ojdbc6.jar is placed in the <ORACLE_HOME>/jdbc folder, but not when only ojdbc8.jar is present.
Resolving The Problem
Complete the following steps to resolve this issue:
- During installation, select the Skip Test Connection option in the Database Configuration panel of the Installation Manager (after entering all of the required database values).
- Select Oracle as the database type and leave the Table Spaces drop down empty.
- Once the extraction phase of the installation is completed by IBM Installation Manager, edit the mdm_install.properties file to update the table space names as follows:
a. Go to <MDM_INSTALL_HOME>/properties and edit the mdm_install.properties file.
b. Update the table space names as follows:
user.table.space.index=IDXSPACE
user.table.space.eme.2=EMESPACE2
user.table.space.eme.1=EMESPACE1
user.table.space.8k=TBS8K
user.table.space.4k=TBS8K
user.table.space.16k=TBS8K
user.table.space.long=LOBSPACE - Proceed with the configuration phase of the installation by running the Configure_MasterDataManagement madconfig target. For details, refer to the InfoSphere MDM installation documentation.
[{"Product":{"code":"SSWSR9","label":"IBM InfoSphere Master Data Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.6;11.6.0.1;11.6.0.2;11.6.0.3;11.6.0.4","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
27 April 2022
UID
swg22011105