Oracle® Thesaurus Management System Installation Guide Release 5.0.1 E37007-02 |
|
|
PDF · Mobi · ePub |
This chapter includes the following topics:
The Oracle Thesaurus Management System (TMS) product is now part of the Oracle Health Sciences Global Business Unit (HSGBU). TMS was formerly part of the Oracle Life Sciences Applications (OLSA) and the Oracle Pharmaceutical Applications (OPA) organizations. During the installation you will see references to OLSA and OPA in the software (such as in directory names, file names, and screen text) that have not been changed.
Be aware of these additional resources.
Visit the My Oracle Support website for the most up-to-date installation information, including alerts, release notes, bulletins, White Papers, and patches; see "Finding Information and Patches on My Oracle Support".
The My Oracle Support website includes these important installation topics:
Oracle Thesaurus Management System 5.0.1 Release Notes (Article ID 1590927.1)
OLSA Known Installation and Configuration Issues (Article ID 1572864.1)
Oracle Clinical, Oracle Clinical Remote Data Capture, and Oracle Thesaurus Management System Security Configuration Guide available with the user documentation.
Oracle Life Sciences Applications Supported Technology Stacks (Article ID 180430.1)
Creating Scripts to Automatically Start the Admin and Managed Servers for RDC Onsite andTMS (Article ID 1587068.1)
Oracle Thesaurus Management System Patches (Article ID 132626.1)
TMS Product Product Information Center page (Article ID 1343408.1): Check here for new notes and White Papers, including the performance White Paper and the Installation Verification Test, which are not available at the time of publication of this document.
The most current TMS user documentation is located on oracle.com at:
http://www.oracle.com/technetwork/documentation/hsgbu-clinical-407519.html
TMS user documentation includes:
Oracle Thesaurus Management System Installation Guide
Oracle Thesaurus Management System User's Guide
Oracle Clinical, Oracle Clinical Remote Data Capture, and Oracle Thesaurus Management System Security Configuration Guide
All the above guides have been updated for Release 5.0.1.
In addition, Oracle Thesaurus Management System customers can request a copy of the Oracle Thesaurus Management System Technical Reference Manual from Oracle Support. The Release 5.0 version of this document also applies to Release 5.0.1.
The architecture for TMS consists of three tiers: the database tier, the application tier, and the client tier.
Figure 1-1 illustrates the architecture and technology stack for TMS.
Figure 1-1 TMS Architecture and Technology Stack
The database tier in a TMS environment includes the Oracle Database 11.2.0.4 software and the TMS database(s). In past releases, the database tier was called the back end.
The application tier includes:
TMS Forms Server — The Forms Server performs all forms processing, communicates the display changes to the client, and calls forms to query, update, select, and delete data from the database.
TMS Server Code— The Server Code consists of scripts used to create TMS databases.
TMS Reports Server — The Reports Server runs most batch reports, schedules all jobs, and creates PDF output for reports. Most TMS reports interface with the TMS Reports Server.
TMS Browser — The TMS Browser runs in a browser and does not required a plug-in. It allows users to browse dictionary terms and, if fully integrated with a clinical data system like Oracle Clinical, source terms and associated external system information.
The client tier communicate users' keystrokes and mouse movements to the application tier. It requires a browser and Browser Native Oracle JVM.
Figure 1-2 shows how the Oracle Thesaurus Management System components and technology stack are related and provides an example of how the product can be installed. The left side of the Application Tier—APPHOST1—is a standard installation, while the whole—with APPHOST2—shows a multi-node middle tier installation using Oracle Clusterware.
In the client tier, end users' browsers communicate via HTTPS with the Oracle HTTP Server (OHS), which is located inside a firewall. When users log in, OHS detects the product they logged in to and consults formsweb.cfg to connect them to the appropriate application tier service.
The application tier comprises Oracle Application Server and Oracle WebLogic Server. The integrated tier has two domains:
FRDomain includes the Oracle Forms runtime service and Forms Server, and the Oracle Reports Server and engine, which run Oracle Clinical forms and reports and the RDC Administration application. It also includes the WebLogic Server Admin Server and Oracle Enterprise Manager.
The Oracle Application Server domain must be named FRDomain and must use port number 7001.
OPADomain includes the WebLogic Server Administration Console, WebLogic Server Java, and OpaServer1, which are required to run the TMS HTML Browser and TMS reports. It also contains the database connections. Note that when you install the Oracle Enterprise Manager in the FRDomain, it serves for monitoring the OPADomain as well.
The TMS Installer automatically creates the OPADomain. OPADomain must use port number 7101.
You can distribute the application tier over multiple nodes in a network using Oracle Clusterware. The Admin Server is required only on the primary node.
The WebLogic Server Node Manager exists outside the domains on the host. The Oracle Thesaurus Management System Installer automatically stops the Node Manager before each Java deployment and starts the Node Manager afterward so you do not need to do that.
The database tier includes Oracle Database with Oracle Thesaurus Management System. The diagram shows a distributed installation integrated with Oracle Clinical using Oracle Real Application Clusters (RAC); this is one example of how it can be installed.
The following tables list technology stack requirements for the database tier, the application tier, and the client tier:
Table 1-1, "Oracle Thesaurus Management System Database Tier"
Table 1-2, "Oracle Thesaurus Management System Application Tier Technology Stack"
Table 1-3, "Oracle Thesaurus Management System Client Tier Technology Stack"
The sections following the tables provide additional information about requirements.
For updates to the technology stack, see Oracle Life Sciences Applications Supported Technology Stacks (Article ID 180430.1) on My Oracle Support; see Section *, "Finding Information on My Oracle Support".
Table 1-1 Oracle Thesaurus Management System Database Tier
Component | Supported Version |
---|---|
Operating System |
Oracle Linux 6.2 with Unbreakable Enterprise Kernel (UEK) 6.32 ; (US English) Oracle Solaris SPARC 10 and 11; 64-bit architecture (US English) Windows Server 2008 Release 2, Service Pack 1; 64-bit architecture (US English) |
Oracle Database |
11g Release 2 (11.2.0.4) Enterprise Edition 64-bit |
Compiler |
For Oracle Linux x86-64: GNU GCC-4.4.6 For Oracle Solaris SPARC 10 and 11: CC-5.11 |
Table 1-2 Oracle Thesaurus Management System Application Tier Technology Stack
Component | Supported Version |
---|---|
Operating System |
Microsoft Windows Server 2008; Release 2; Service Pack 1; 64-bit architecture |
Oracle Application Server |
Oracle Application Server 11g Release 2 (11.1.2.1) |
Oracle WebLogic Server |
Oracle WebLogic Server 11g R1 (10.3.6) |
Oracle ADF |
Oracle Applicaton Developer's Framework 11g R2 (11.1.2.4) |
Table 1-3 Oracle Thesaurus Management System Client Tier Technology Stack
Component | Supported Version |
---|---|
Operating Systems |
Microsoft Windows XP; Service Pack 1, 2, or 3; 32-bit architecture (US English) Microsoft Windows Vista; Service Pack 1; 32-bit architecture (US English) Microsoft Windows 7; Service Pack 1; 32-bit or 64-bit architecture (US English) Microsoft Windows Server 2008; Release 2; Service Pack 1; 64-bit architecture (US English) |
Mobile Operating Systems |
iOS 5, 6, and 7—iPad and iMac 10.7.5—for the TMS Browser only |
Supported Browsers |
Microsoft Internet Explorer versions depend on the operating system:
Safari 6.0.2 on iOS 5, 6, and 7 for TMS Browser only |
Adobe Reader |
Releases 8x, 9.x, 10.x (US English) Required for viewing reports |
Oracle Java Runtime Environment (JRE) |
Java SE 7 Update 45 (Standard Edition, Version 1.7.0.45) |
This section describes the hardware and software requirements for the TMS database tier.
For information about the guidelines and requirements for character sets, see Section 1.7, "Choosing a Character Set."
You must obtain the latest Critical Patch Update (CPU) approved by Oracle Health Sciences from My Oracle Support and install it on each database and application tier server computer; see Section 1.8, "Applying Oracle Critical Patch Updates".
See Table 1-1, "Oracle Thesaurus Management System Database Tier" for basic information.
To verify that your system fits the requirements listed in Table 1-1, "Oracle Thesaurus Management System Database Tier" do the following in UNIX or Windows:
To verify the operating system details, enter the following command:
UNIX To verify UNIX operating system details, enter the following command:
uname -a
In addition, to verify the update version for Linux, enter the following command:
cat /etc/issue
Windows To verify Windows operating system details, navigate to the Control Panel, then System and Security, then System.
For database tier system requirements, see the Oracle Database 11g Release 2 (11.2) Installation Guide for your respective operating system.
See Table 1-2, "Oracle Thesaurus Management System Application Tier Technology Stack" for basic information.
The application tier includes the Forms Server and Reports Server components as well as WebLogic Server.
For information about the guidelines and requirements for character sets, see Section 1.7, "Choosing a Character Set"
You must obtain the latest Critical Patch Update (CPU) approved by Oracle Health Sciences from My Oracle Support and install it on each database and application tier server computer; see Section 1.8, "Applying Oracle Critical Patch Updates".
For installing and integrating Oracle Thesaurus Management System (TMS) with Oracle Clinical, you can install TMS and Oracle Clinical on the same application tier or on different application tiers. To integrate Oracle Clinical and TMS, both products must be installed on the same database.
Oracle recommends installing Oracle Clinical before TMS.
If you install both products on the same application server, do not install the TMS Reports Server.
In addition to the software noted in Table 1-3, "Oracle Thesaurus Management System Client Tier Technology Stack", a client requires an intranet or internet connection. In addition, see Section 8.8, "Setting Up Client Computers."
You must download software from the Oracle Clinical 5.0.1 and Oracle Thesaurus Management System 5.0.1 media pack and from My Oracle Support. You must download third-party software from third-party websites.
Oracle recommends creating one staging area on the database server and another on the application server. In each staging area, create one directory for each media pack disk, patch, or other software unit that needs to be downloaded to that server, as shown in Table 1-4, "Software to Download to Database Server Staging Area" and Table 1-5, "Software to Download to Application Server Staging Area".
Give each directory a logical name such as the media pack disk or patch name (not part or patch number) to make instructions later in this guide easier to follow.
Table 1-4, "Software to Download to Database Server Staging Area" shows which software to download to the database server staging area.
Table 1-4 Software to Download to Database Server Staging Area
Disk or Patch Name | Source | ID Number |
---|---|---|
Oracle Thesaurus Management System 5.0.1.0.0 Documentation |
Media pack |
V42143-01 |
Oracle Thesaurus Management System 5.0.1.0.0 |
Media pack |
V41360-01 |
Oracle Database 11.2.0.4—Patch 13390677 contains the entire Oracle Database 11.2.0.4, including Examples, packaged in the following .zip files:
|
My Oracle Support |
Patch 13390677 |
Table 1-5, "Software to Download to Application Server Staging Area" shows which software to download to the application server staging area.
Table 1-5 Software to Download to Application Server Staging Area
Disk or Patch Name | Source | ID Number |
---|---|---|
Oracle Thesaurus Management System 5.0.1.0.0 Documentation |
Media pack |
V42143-01 |
Oracle Thesaurus Management System 5.0.1.0.0 |
Media pack |
V41360-01 |
Oracle WebLogic Server 11gR1 (10.3.6) Generic and Coherence |
Media pack |
V29856-01 |
Oracle Application Development Runtime 11g Patch Set 5 (11.1.1.6) (also known as Application Developer's Framework or ADF) |
Media pack |
V29673-01 |
JDeveloper patch for ADF 11.1.2.4 |
My Oracle Support |
16546129 |
WebCenter Composer patch for ADF 11.1.2.4 |
My Oracle Support |
16546157 |
Oracle Forms and Reports 11gR2 (11.1.2.1.0) for Microsoft Windows x64 (64-bit) |
Media pack |
V35703-01 |
Oracle Java Development Kit 1.6.0_65, also known as JDK 6 Update 65; see Section 1.4.4, "Downloading Oracle Java Development Kit." |
My Oracle Support |
Patch 16457117 |
Java Runtime Environment (JRE) 1.7.0.45; see Section 1.4.5, "Downloading the Java Runtime Environment." |
www.oracle.com |
|
Adobe Reader |
Note:
To receive a physical media pack with all the required DVDs, contact Oracle Support. To expedite your request you can either call Oracle Support directly or open a Service Request (SR) selecting problem category: Version Update Request.To download the software:
Go to http://edelivery.oracle.com
and log on.
From the Select a Product Pack drop-down list, select Health Sciences.
From the Platform drop-down list, select the appropriate operating system.
Click Go.
Select Oracle Clinical 5.0.1 and Oracle Thesaurus Management System 5.0.1 Media Pack for Your_Operating_System and click Continue.
Download each disk into the appropriate directory in the appropriate staging area as shown in Table 1-4, "Software to Download to Database Server Staging Area". Each download consists of a single file named part_number.zip.
Extract each part_number.zip file into a meaningfully named directory.
For the Oracle Thesaurus Management System software, extract application_server.zip.
To download a patch from My Oracle Support:
Go to My Oracle Support at https://support.oracle.com
and sign in.
Click the Patches & Updates tab, then enter the patch number in the Patch Name or Number is field and click Search.
Click the link for your operating system and download the patch file to the appropriate directory in the staging area.
Extract the .zip file.
To download and install JDK 1.6.0_65:
Go to My Oracle Support at https://support.oracle.com
and sign in.
In the Search Knowledge Base field in the upper right, enter: 1439822.1
A page appears with a list of documents.
Click the link All Java SE Downloads on MOS [Article ID 1439822.1].
Scroll down to the list of JDK versions to Oracle JDK 6 Update 65 (Patch ID 17046855).
Note:
Check My Oracle Support article 180430.1 to see if a more recent versions are supported; see "Finding Information on My Oracle Support".Click the patch number link.
Select Microsoft Windows x64 (64-bit) and click ReadMe to read the release notes and Download to download the patch.
Installation instructions are in Section 4.3, "Installing Oracle Java Development Kit."
TMS requires that Java Standard Edition (SE) Runtime Environment (JRE) 1.7.0.45—also known as JRE 7 Update 45—exists on the user's computer.
The 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; see Section 8.4, "Making the Java Runtime Environment Available for Download."
To download the latest version of the JRE and then position the software so your users can install it directly from the Downloads page:
On the application server, go to the following Oracle Web site:
http://www.oracle.com/technetwork/java/javase/downloads/index.html
Click the Download button for JRE.
Select the Windows x86 Offline version.
Note:
This is the version for 32-bit browsers (not operating systems). The default browser for Windows machines is 32-bit, but Windows machines also come with a 64-bit version. If you want to support the 64-bit version, you must either customize your Launch page to point to sunjpi64.exe or instruct users with 64-bit browsers to download the 64-bit version of JRE from the link in Step 1.Download it to the staging area in a recognizably named directory.
Adobe Reader is required on the Reports Server and on client computers. Download it from http://www.adobe.com
. At this time no particular version is required.
You can run any of the Oracle Universal Installers—including the Oracle Thesaurus Management System Installers—in silent mode. This may be useful to promote uniform installations in many sites or on many computers.
TMS ships with .rsp (response) files that include the parameter prompts and sample parameter values for each component. They are located on the media pack under Disk1\stage\responses and include:
tms_frontend.rsp
tms_db_install.rsp
tms_db_upgrade.rsp
Open the file in a text editor and enter values directly
Run the file.
In UNIX:
./runInstaller -responseFileresponse_file_name
In Windows:
setup.exe -responseFile response_file_name
When you run the file at each location, edit the local parameters as required.
Alternatively, you can run the Installer once, entering values manually, and record the process to create a response file.
Run the file.
In UNIX:
./runInstaller -record -destinationFile response_file_name
In Windows:
setup -record -destinationFile response_file_name
For more information see OUI documentation at:
During the installation of an Oracle Health Sciences component, the Oracle Universal Installer generates the following log file:
This log file records the actions of the Installer — such as loading information from the CD to the Application or Database Server — and is useful for diagnosing problems with the Installer. You should include the log file if you report any problems that occur when installing an Oracle Health Sciences component.
On a Windows installation, the log files are located at:
\Oracle\Inventory\logs
For example:
C:\Program Files\Oracle\Inventory\logs
On a UNIX installation, the log files are located at:
$ORACLE_BASE/oraInventory/logs
For example:
/u01/app/oraInventory/logs
The current log file is installActions.log. All previous log generations have a timestamp appended to the name. For example:
installActions2013-04-30_11-22-52AM.log
Oracle Health Sciences supports certain character sets for each product or each combination of integrated products.
For TMS, Oracle strongly recommends that you use the UTF8 character set (default). TMS supports UTF8, US7ASCII, WE8ISO8859P1, or any single byte character set.
TMS uses the NLS_LANG environment variable to control the language, territory, and character set used for database connections. The NLS_LANG variable concatenates the three components as LANGUAGE_TERRITORY.CHARSET.
The default installation configures the TMS application to use the following character set AMERICAN_AMERICA.UTF8.
You must set the CHARSET component of the NLS_LANG variable to match the character set of the database.
You must use the same character set on the database tier and the application tier. If you select US7ASCII for the database tier and AL32UTF8 or UTF8 for the application tier, TMS stores some special characters incorrectly in the database.
Every quarter, Oracle provides Critical Patch Updates (CPUs) to address security vulnerabilities. These patches are cumulative: each one contains all the fixes contained in the previous patch.
Check My Oracle Support article ID 121863.1, Oracle Health Sciences Supported Technology Stacks, for the latest CPU patch tested with Oracle Health Sciences applications, with a link to the separate article about each one. Install these patches on every computer with an Oracle Home.
Check My Oracle Support article Oracle Thesaurus Management System Patches (Article ID 132626.1) for the latest patch set and apply it. See the patch set release notes for more information.