Skip Headers
Oracle® Thesaurus Management System Installation Guide
Release 5.1

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Feedback page
Contact Us

Go to previous page
PDF · Mobi · ePub

8 Post-Installation Steps for the New Installation or Upgrade

This chapter includes:

8.1 Patch TMS

Check Oracle Thesaurus Management System Patches (Article ID 132626.1) on My Oracle Support for information about any patch sets and patches that have been released since Release 5.1. See "Finding Information on My Oracle Support".

8.2 Test the TMS Forms Server

Confirm that you can start TMS from this Forms Server before you set up each TMS client.

To test the deployment:

  1. Open a browser.

  2. Connect to the Oracle Health Sciences URL to start TMS.

    The URL has the following syntax:


  3. Click the Launch hyperlink, which initiates the download of the Java Virtual Machine (JVM).

8.3 Configure WebLogic Server Data Sources

When you run the TMS Installer, it sets up a connection, or data source, for OPA and another for the TMS Browser from the WebLogic Server to the database that you specify in the Installer screens.

Confirm that the OPA data source exists in the WebLogic Server Administration Console and then enter its JNDI name in the REPORT_CONFIG local reference codelist.

8.3.1 Confirm the OPA Data Source Value in WebLogic Server Admin Console

To check this:

  1. Log in to the WebLogic Server Administration Console at:

  2. Navigate to Services under Domain Structure, then Data Sources.

  3. Confirm that a data source with JNDI name: jdbc/opadatabase_nameDS exists.

8.3.2 Set REPORT_CONFIG Reference Codelist Value

Update local reference codelist REPORT_CONFIG with the data source JNDI name:

  1. Log in to TMS.
  2. Navigate to Definition, then Local Reference Codelists.

  3. Query for the REPORT_CONFIG codelist:

    1. Press F7.

    2. Enter REPORT_CONFIG in the Name field.

    3. Press F8. The system displays the short value JDBC_DATA_SRC.

  4. Enter the JNDI name value jdbc/opadatabase_nameDS as the long value.

  5. Save.

8.3.3 Add Data Source (Required Only If Using Multiple Databases)

When you run the TMS Installer, it sets up a data source connection for OPA and the TMS HTML Browser from the WebLogic Server to the database you specify in the Installer screens.

If you plan to use more than one database, you must create an OPA and a TMS Browser data source for each additional database. The OPA data source is used to run TMS reports.

Complete instructions are in the Oracle Thesaurus Management System User's Guide chapter on Administration.

8.4 Making the Java Runtime Environment Available for Download

Oracle Thesaurus Management System requires that the Java Runtime Environment (JRE) exists on the user's computer.

The TMS Launch page is configured to prompt users to install JRE if it does not exist on their computer. To make this work, you need to download JRE into the OPA_HOME\html directory and rename it.


If you have already installed Oracle Clinical on the same machine, you do not need to do this again.

To download the latest version of the JRE and then position the software so your users can install it directly from the Downloads page:

  1. If you have not already done so, download the software following instructions in Section 1.4.5, "Downloading the Java Runtime Environment."

  2. Copy the downloaded file from the staging area to OPA_HOME\html.

  3. Rename the file sunjpi.exe.

If your users need to have both JRE 6 and 7 installed to support different versions of Oracle Thesaurus Management System, check My Oracle Support article 1570682.1 for guidance; see "Finding Information on My Oracle Support".

8.5 Create a Link to TMS HTML Browser

You need to construct a link for users to access the TMS HTML Browser. You can add it to the TMS launch page or to your own users' home page. You can add links for more than one database if needed, and you can enable automatic login.

For instructions, see the administration chapter of the Oracle Thesaurus Management System User's Guide.

8.6 Define and Load Dictionaries

See the Oracle Thesaurus Management System User's Guide for information about defining TMS dictionaries in the user interface and loading dictionary data.

For sample load scripts, download the following document from My Oracle Support:

Title: Sample Maintenance Scripts for MedDRA, MedDRA Primary Path, MedDRA SMQ, WHO-Drug Formats B, B2, and C, and SNOMED

Article ID: 258975.1


If you are upgrading an existing TMS installation, you do not need to redefine and reload the dictionaries you are already using.

8.7 Setting Up Client Computers

This section includes:

8.7.1 Configuring Personal Firewall

If the client computer has a personal firewall, you must either disable it or configure it for the TMS Browser to function correctly. See your firewall documentation or ask your system administrator for assistance.

8.7.2 Using Safari on an iPad

On an iPad, which is supported for the TMS Browser, some functionality available on a personal computer using a mouse is not available, including:

  • Right-click and double-click options.

  • Selecting multiple records using Ctrl+click

8.7.3 Setting Internet Options for Microsoft Internet Explorer

Users who use the TMS Browser or TMS reports should change their Internet Explorer settings as follows. Setting Document Mode to Quirks (the Default Setting)

Internet Explorer 8 and above include a set of tools that enable Web site developers to prototype and test Web sites they develop, including the Document Mode setting.

A user can change the Document Mode setting such that RDC Onsite does not work properly. It is not anticipated that RDC Onsite users will change the Document Mode setting, as it is targeted at Web developers.

Ensure that the Document Mode is set to Quirks Mode (Page Default):

  1. Launch Internet Explorer.

  2. Open the Tools menu, and then select Developer Tools.

  3. Set the Document Mode to Quirks Mode (Page Default). Disabling Cookies

Before a user runs TMS reports, he or she must disable cookies on their computer:

  1. In the IE Tools menu, go to Internet Options.

  2. Click the Privacy tab, then Settings.

  3. Move the slider to the top to block all cookies.

  4. Click OK, then OK again. Allowing More Connections

By default, Internet Explorer allows only two connections at a time to the same server. However, TMS Browser users may want to have more. If so, they can follow instructions from Microsoft at The problem description is about being unable to download only two files at a time, but the fixes described work for this issue as well. Turning Off Compatibility View

The TMS Browser does not support the Compatibility View available on Internet Explorer 8 and above. If the setting is enabled in in the browser, when a user tries to access the TMS Browser, he or she sees the following message: "The current compatibility setting is not supported." There are several places to turn off Compatibility View:

  • In the IE Tools menu, toggle between turning Compatibility View on an off by clicking Compatibility View.

  • The above setting is overridden by those found in the Tools menu under Compatibility View Settings. Uncheck both: Display intranet sites in Compatibility View and Display all websites in Compatibility View

  • The Compatibility View icon:

    Icon is a torn piece of paper.

    appears in the address bar when it is turned on for the current website. Click the icon to turn it off. Set Up for Proxy Usage on Fully Qualified Application Tier Names

You must configure your client proxy settings if one of the following conditions is true for your installation:

  • You connect to the application tier with its fully qualified name

  • You use proxies.

To configure your client proxy settings:

  1. Start Internet Explorer.

  2. Open the Tools menu, and then select Internet Options.

  3. Click the Connections tab.

  4. Click LAN settings to open the Local Area Network (LAN) Settings dialog box.

  5. Select Use a proxy server for your LAN, and then click Advanced.

  6. Define the Exceptions at the bottom of the panel.

    In the Do not use proxy server for addresses beginning with field, use the following format to enter the fully qualified name of each application server:


    For example, if the server name is sys63 and the domain name is, then you enter:

    If you are connecting to more than one application server, enter the fully qualified name of each server. Use the semicolon (;) to separate your entries.

8.7.4 Download the Java Virtual Machine to Client Computers

To download the Java Virtual Machine (JVM) onto each client computer:

  1. Open a browser.

  2. Connect to the Oracle Health Sciences URL.

    The URL includes the path variable you specified in Section 8.2, "Test the TMS Forms Server."

    The first time you open TMS, the system prompts you to download JVM. This download is required. It is also available from a link on the Launch page.

8.7.5 Logging In

TMS To log in to Forms-based Oracle Thesaurus Management System, use the following URL:


TMS Browser To log in to the TMS Browser, use the following URL:



See the chapter on administration in the Oracle Thesaurus Management System User's Guide for information about customizing the URL to support automatic login and multiple databases.