Preparing an Oracle database for the Context Menu Service and Data Integration Service

Follow these steps to manually configure an Oracle database for the Context Menu Service (CMS) and Data Integration Service (DIS).

You must install the Oracle database software on the database server, and the sqlplus command must be available.

Note: When creating the Oracle database, select the Unicode character set (AL32UTF8) in the Database Character Set field. Otherwise, data that is in languages other than English might not display correctly. If you see the Oracle message OALL8 is in inconsistent state, TADDM cannot access some of the national language-specific text in your database. Re-create your database with the correct character set.

You can optionally specify that the CMS and DIS configuration automatically complete during the TADDM installation process. Follow these steps if you did not use this option and have to manually configure the database after installation.

To prepare an Oracle database for CMS and DIS:

From the product DVD, copy the support/cmsdis/cmsdis.zip file to the system where the Oracle database is installed.
Use one of the following procedures to run the make_oracle_cms_dis script on the system where the Oracle database is installed:
- For Linux® and UNIX systems:
  1. Log in as the Oracle user, or the user that was used to install the Oracle database (typically oracle).
  2. Extract the contents of the cmsdis.zip file.
  3. Go to the cmsdis directory.
  4. At a command prompt, run the following command:
```
make_oracle_cms_dis.sh -d sid cmsdis_usr cmsdis_pwd
```
    where:
    
    sid
    
    The Oracle system ID.
    
    cmsdis_usr
    
    The Oracle user ID. This user ID must be different from the Oracle user ID used for TADDM.
    
    cmsdis_pwd
    
    The password for the Oracle user ID.
- For Windows systems:
  1. Extract the contents of the cmsdis.zip file.
  2. Go to the cmsdis directory.
  3. At a command prompt, run the following command:
```
make_oracle_cms_dis.bat -d sid cmsdis_usr cmsdis_pwd
```
    where:
    
    sid
    
    The Oracle system ID.
    
    cmsdis_usr
    
    The Oracle user ID. This user ID must be different from the Oracle user ID used for TADDM.
    
    cmsdis_pwd
    
    The password for the Oracle user ID.
Check the standard output for any errors resulting from the make_oracle_cms_dis script.
Set the following configuration parameters in the $COLLATION_HOME/etc/collation.properties file:
```
com.ibm.cdb.DisCmsIntegration.enabled=true
com.ibm.cdb.DisCmsIntegration.dbUser=oracle_cmsdis_user
com.ibm.cdb.DisCmsIntegration.dbPassword=oracle_cmsdis_password
com.ibm.cdb.DisCmsIntegration.dbUrl=
  jdbc:oracle:thin:@oracle_hostname:oracle_port:oracle_sid
com.ibm.cdb.DisCmsIntegration.dbDriver=oracle.jdbc.driver.OracleDriver
```
where:

oracle_cmsdis_user

The Oracle user ID for CMS and DIS.

oracle_cmsdis_password

The password for the Oracle user ID.

oracle_hostname

The host name of the Oracle server.

oracle_port

The Oracle port on the server.

oracle_sid

The Oracle system ID.