7 Installing Oracle Thesaurus Management System (Optional)

Oracle Thesaurus Management System (TMS) can be integrated with Oracle Health Sciences Data Management Workbench for use in coding clinical patient data to standard dictionary terms.

7.1 Install Oracle Thesaurus Management System

Follow instructions in the most recent version of the Release 5.0.1 Oracle Thesaurus Management System Installation Guide. The installation guide is available at http://docs.oracle.com/cd/E37006_01/index.htm.

7.2 Edit setDomainEnv.sh

As directed in Section 3.8, "Edit setDomainEnv.sh" add the parameter -DhandleDiscEvent set to True on one and only one application server.

This is required to support multiple middle tiers pointing to the same database. Only the server with this parameter set to True will be able to send data from TMS to InForm.

7.3 Run Script dmetmsseeddata.sql

Run dmetmsseeddata.sql to populate TMS-related seed data required for Oracle DMW.

1. Make sure that no LSH session is up and running.

2. Log in to SQL*Plus as tms. (You created a password for this account when you ran the Installer for the TMS database.)

3. Go to $CDR_TOP/patch/115/sql.

4. Run dmetmsseeddata.sql.