IBM Support

During InfoSphere MDM installation with Oracle 12cR2, the database connection test fails

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:

    1. 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).
    2. Select Oracle as the database type and leave the Table Spaces drop down empty.
    3. 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
    4. 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"}}]

Document Information

Modified date:
27 April 2022

UID

swg22011105