This chapter includes:
Check Oracle Thesaurus Management System Summary of Patches Available (Article ID 132626.1) on My Oracle Support for information about any patch sets and patches available for Release 5.2.4. If any, download and apply them now. See the patch release notes (readme) for details about the patch and installation instructions.
Confirm that you can start TMS from this Forms Server before you set up each TMS client.
To test the deployment:
Open a browser.
Connect to the Oracle Health Sciences URL to start TMS.
The URL has the following syntax:
https://computer_name.domain/opa52/launch.htm
Click the Launch hyperlink, which initiates the download of the Java Virtual Machine (JVM).
When you run the TMS Installer, it sets up a connection, or data source, for TMS Browser from the WebLogic Server to the database that you specify in the Installer screens.
Confirm that the data source exists in the WebLogic Server Administration Console and then enter its JNDI name in the REPORT_CONFIG local reference codelist.
To check this:
Log in to the WebLogic Server Administration Console at:
http://host:7101/console
Navigate to Services under Domain Structure, then Data Sources.
Confirm that a data source with JNDI name: jdbc/tms exists.
Update local reference codelist REPORT_CONFIG with the data source JNDI name:
Log in to TMS.
https://computer_name.host/opa52/launch.htm
Navigate to Definition, then Local Reference Codelists.
Query for the REPORT_CONFIG codelist:
Press F7.
Enter REPORT_CONFIG in the Name field.
Press F8. The system displays the short value JDBC_DATA_SRC.
Enter the JNDI name value jdbc/tms as the long value.
Save.
When you run the TMS Installer, it sets up a data source connection for TMS Lite 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 a TMS Lite Browser data source for each additional database. The same data source can be used to run TMS reports.
Complete instructions are in the Oracle Thesaurus Management System User's Guide chapter on Administration.
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.
Note:
If you have already installed Oracle Clinical on the same machine, you do not need to do this again and can skip to the next section.To download the latest version of the JRE and then position the software so your users can install it directly from the Downloads page:
If you have not already done so, download the software following instructions in Section 1.6.5, "Download the Java Runtime Environment."
Copy the downloaded file from the staging area to OPA_HOME\html.
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.
You need to construct a link for users to access the TMS Lite 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.
In order to control the file size limitation for a template file in the TMS Lite Browser- Report tab, modify the following parameters in web.xml: UPLOAD_MAX_MEMORY, UPLOAD_MAX_DISK_SPACE, UPLOAD_TEMP_DIR, and UPLOAD_MAX_FILE_SIZE.
Note:
These parameters are commented and default values are set for reference. They can be uncommented and set new value(s) which will require repack of .ear and deployment to take into effect.To modify the parameters in web.xml from tmslite.ear:
Create a backup of tmslite.ear located under OPA_HOME\tms\tmslite.ear.
Open tmslite.ear in 7zip.
Edit OPA_HOME\tms\tmslite.ear\TMSWebUIApp.war\WEB-INF\web.xml in 7Zip.
In web.xml, uncomment the section containing parameters: UPLOAD_MAX_MEMORY, UPLOAD_MAX_DISK_SPACE, and UPLOAD_TEMP_DIR and update values for these parameters according to your requirements to control the file size upload.
Save the changes.
In the OPADomain console, redeploy tmslite.ear.
In order to modify the supported template file types in the TMS Lite Browser-Report tab, add fu_content_type and fu_ext properties to the tmsconfig.properties file.
Note:
Each supported type is separated by commas. The tmsConfig.propertes file is located in the OPA_HOME\config folder and by default, fu_content_type and fu_ext properties may not be present.Default supported content types are application/msword, application/vnd.openxmlformats-officedocument.wordprocessingml.document, application/vnd.openxmlformats-officedocument.wordprocessingml.template, application/vnd.ms-excel, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.openxmlformats-officedocument.spreadsheetml.template, application/rtf, text/richtext, text/plain.
Default supported file extensions are .doc, .dot, .docx, .dotx, .xls, .xlt, .xlsx, .xltx, .rtf.
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, SNOMED, and WHODrug Formats B2, B3, and C3
Article ID: 258975.1
Note:
If you are upgrading an existing TMS installation, you do not need to redefine and reload the dictionaries you are already using.This section includes:
If the client computer has a personal firewall:
Disable the firewall or configure it for the TMS Lite Browser to function correctly.
See your firewall documentation or ask your system administrator for assistance.
On an iPad, which is supported for the TMS Lite 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
This section describes how to download and install the following applications:
Java Runtime Environment (JRE)
Adobe Reader
Java Virtual Machine
Instructions for setting up downloads from the Oracle Thesaurus Management System Launch page are included in Section 7.4, "Making the Java Runtime Environment Available for Download".
TMS and the TMS Lite Browser require the Java Runtime Environment (JRE) version 8 (1.8.0.251 or above).
If you have older versions of JRE and do not need them, uninstall these versions before installing the new version. By uninstalling old versions, you avoid receiving the following message when starting an Oracle Health Sciences application:
The Application requires an earlier version of JRE. Do you want to continue?
To download and install the JRE onto a client:
Open a browser and enter the URL to open the Launch page for TMS. For example:
https://server.domain:port/opa52/launch.htm
Click Install JRE Plug-in on the Launch page.
Follow the on-screen instructions to download and install the JRE.
During the installation, you must accept all prompts to accept signed jar files.
The system downloads the JRE from your Forms Server. When you set up the Forms Server, you installed the latest version of the JRE. See Section 7.4, "Making the Java Runtime Environment Available for Download" for more information.
TMS and the TMS Lite Browser support Adobe Reader 7.x or later, English versions. However, this requirement may change during the life of this document. Check My Oracle Support for the latest requirements.
To download the free Adobe Reader:
Go to the Adobe Corporation Web site:
Follow the on-screen instructions to download the latest version of the Adobe Reader.
To download the Java Virtual Machine (JVM) onto each client computer:
Open a browser.
Connect to the Oracle Health Sciences URL.
The URL includes the path variable you specified in Section 7.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.
TMS To log in to Forms-based Oracle Thesaurus Management System, use the following URL:
https://computer_name.domain/opa52/launch.htm
TMS Browser To log in to the TMS Browser, use the following URL:
https://computer_name.domain/tmsadf/faces/Login
Note:
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.