Table of Contents

• Title and Copyright Information
• Preface
  • Documentation accessibility
  • Diversity and Inclusion
  • Related resources
  • Access to Oracle Support
• 1 Prepare to Install Oracle Thesaurus Management System
  • Check Installation Documentation
    • My Oracle Support Articles
    • User and Installation Documentation
  • Architecture
  • Network Topology
  • Software Requirements
    • Database Tier Operating System Requirements
  • Supported Configurations with Oracle Data Guard and RAC
    • Supported Configurations with Oracle Real Application Clusters (RAC)
      • Node 1: Install and Set Up Everything Required for Oracle Clinical
      • Node 2: Install the Minimum Required as a RAC Node
      • Node 3: Install Everything Required for Oracle Clinical as Backup
    • Supported Configurations with Oracle Data Guard
  • Download the Software
    • Create Staging Areas
    • Download the Oracle Thesaurus Management System 5.3.1.0.x Media Pack
    • Download Patches from My Oracle Support
    • Download Oracle Java Development Kit
    • Download the Java Runtime Environment
    • Download Adobe Reader
    • Download Oracle Critical Patch Updates
  • Use the Silent Installer (Optional)
  • Choose a Character Set
  • Download the Latest TMS Patches
  • Integrate TMS with Other Products and Options
    • Oracle Clinical Remote Data Capture Onsite
    • Oracle Clinical
    • Oracle Health Sciences Data Management Workbench and Oracle Life Sciences Data Hub
    • Custom Applications for TMS
• 2 Install Oracle Database
  • Get the Oracle Database Installation Guide
  • Download and Extract the Oracle Database Software
  • Performing Prerequisite Tasks for Installing Oracle Database
    • Create Owners, Groups, and Mount Points
    • Configure Kernel Resources and Adjust Operating System Environment
    • Install Latest Operating System Patches
  • Install Oracle Database
    • Install and Configure Oracle Database
    • Modify the tnsnames.ora File on the Database Server
    • Create the oinstall User Group
    • Check Required Tablespaces
    • Performance Tuning Step for Pluggable Databases
  • Install Oracle Database 12c Release 1 (12.1.0.2) or 19c (19.3.0) Examples
  • Install Oracle Critical Patch Update
• 3 Install and Configure the Oracle Application Tier
  • Before You Start
    • Identify a Single Account to Perform All Application Tier Installation Tasks
    • Get a CA Certificate for HTTPS
    • Permanent IP Address
  • Gather Required Information
  • Install Oracle Java Development Kit
  • Install Oracle WebLogic Server 12.2.1.4
  • Install the Oracle Fusion Middleware Infrastructure Software
  • Install the Oracle Forms and Reports Servers
  • Create the Repository Creation Utility
  • Configure the FRDomain
    • Run ohs_updateInstances
  • Enable SSL Between a Browser and Oracle HTTP Server
    • Enable SSL Between a Browser and Oracle HTTP Server Using a Certificate Authority
      • Create an Oracle Wallet and Generate a Certificate Request
      • Obtain Trusted Certificate and User Certificate from Certificate Authority
      • Add the User Certificate and Trusted Certificate to an Oracle Wallet
      • Edit the Oracle HTTP Server Configuration File
    • Enable SSL Between a Browser and Oracle HTTP Server With Self Signing
      • Edit the Oracle HTTP Server Configuration File
  • Modify the tnsnames.ora File on the Application Server
  • Configure Firewall on the Application Tier
  • Test Connectivity to Databases for Forms and Reports Servers
    • Test the Connection from the Application Servers to the Database
    • Troubleshoot Network Connection Issues
  • Restart the Computer
• 4 Creating a TMS Database
  • Install the TMS Database Server
    • Gather Required Information
    • Start the TMS Database Server Installer
    • Attend to the TMS Database Server Code Installation Screens
  • Review Database Requirements and Recommendations
    • Start with a New Database Instance
    • Accept Connections as a Service
    • Check Required Tablespaces
    • Use the Database Configuration Assistant
    • Select Required Components
    • Use Automatic Memory Management
    • Set Initialization Parameters
  • Install TMS Database Objects
    • Unlock Accounts Before Installing the TMS Database
    • Gather Required Information
    • Stop the PSUB Process (If Integrated with Oracle Clinical)
    • Start the Installer
    • Attend to the TMS Database Installer Screens
    • Check the Database Log File
  • Create a TMS Administrator User Account
  • Register Databases Integrated with Oracle Clinical
    • Gather Required Information
    • Start the Installer
    • Attend to the TMS Database Registration Screens
  • Load Dictionaries
• 5 Installing Oracle Thesaurus Management System Application Components
  • Restart Computer and Stop All Servers
  • Installing the TMS Front End
    • Gather Required Information
    • Start the Installer
    • Attend to the TMS Front End Installer Screens
    • Find the Installation Log Files
    • Restart the Computer
    • Add WebLogic Data Sources If Using Multiple Databases
  • Make the Java Runtime Environment Available for Download
  • Installing the TMS Reports Server
    • Start the WebLogic FRDomain Admin Server
    • Gather Required Information
    • Start the TMS Report Server Installer
    • Attend to the TMS Reports Server Installation Screens
    • Review the Installation Log File
    • Start the TMS Report Server
  • Verifying the Application Tier Installation
  • Verify and Fix Environment Variables
    • Check Values
    • Correct Values
  • Set Up Automatic Startup
    • Create boot.properties
    • Increase the Delay for Auto Start OPADomain and FRDomain
    • Set Up Scripts to Execute Automatically at Machine Startup
    • Test Autostart
  • How to Start Servers Manually
    • Start the FRDomain Node Manager
    • Start the FRDomain Admin Server
    • Start the Forms Server
    • Start the Reports Server
    • Start the OPADomain Node Manager
    • Start the OPADomain Admin Server
    • Start the Managed Server of OPADomain
    • Start the OHS Server
    • Start the TMS Reports Server
  • Verify the Application Tier Installation
  • Stopping Servers
    • Stopping the Forms Server
    • Stopping the Reports Server
    • Stopping the FRDomain Admin Server
    • Stopping the OPADomain Admin Server
    • Stopping the Managed Server of OPADomain
    • Stop the OHS Server
    • Stop the TMS Reports Server
    • Stop the FRDomain Node Manager
    • Stop the OPADomain Node Manager
• 6 Upgrading Oracle Thesaurus Management System to Release 5.3.1
  • Upgrade Oracle Clinical (If Integrated with Oracle Clinical)
  • Install Oracle Database
  • Back Up Your Database(s)
  • Upgrade Oracle Database
    • Upgrade the Database to Oracle Database 12c Release 1 (12.1.0.2)
      • Clone Your Database
    • Upgrade the Database to Oracle Database 19c (19.3.0)
      • Upgrade in Place from Oracle Database 12.1.0.2 to 19c
      • Clone Your Database on a Oracle Database 19c
  • Upgrade and Configure the Application Tier Technology Stack
    • Before You Start
      • Identify a Single Account to Perform All Application Tier Installation Tasks
    • Gather Required Information
    • Restart Computer and Stop All Servers
    • Install Oracle Application Tier 12.2.1.4
    • Run Pre-Upgrade Readiness Check
    • Upgrade the Domain Schema
    • Run the Reconfiguration Wizard
    • Upgrade the Forms Server
    • Complete the Upgrade for FRDomain
      • Check EXTRA_JAVA_PROPERTIES for setDomainEnv.cmd
      • Run WLST to Provide Grant for Forms Application Keystore and Update OHS
      • Update OHS Instance Files
    • Start all components of FRDomain and OPADomain
  • Install the TMS Database Server Code
  • Upgrade a TMS Database
    • Back Up Database Objects
    • Prevent Access to Oracle Thesaurus Management System Databases
    • Gather Required Information
    • Stop PSUB Process (If Integrated with Oracle Clinical)
    • Start the Installer
    • Attend to the TMS Database Upgrade Installer Screens
    • Set Initialization Parameters
    • Check Installation Log for Errors
    • Configure DSI Import
    • Load Dictionaries
    • Integration with Oracle Clinical
  • Upgrade Cloned Databases
  • Run Scripts to Gather Schema Statistics for the 12c or 19c Optimizer
  • Upgrade the TMS Front End
    • Gather Required Information
    • Start the Installer
    • Attend to the TMS Front End Installer Screens
    • Find the Installation Log Files
    • Set Remote Method Invocation (RMI) JDBC Security to Secure
  • Upgrade the TMS Reports Server
• 7 Post-Installation Steps for the New Installation or Upgrade
  • Patch TMS
  • Test the TMS Forms Server
  • Configure WebLogic Server Data Sources
    • Confirm the TMS Data Source Value in WebLogic Server Admin Console
    • Set REPORT_CONFIG Reference Codelist Value
    • Add Data Source (Required Only If Using Multiple Databases)
  • Making the Java Runtime Environment Available for Download
  • Create a Link to TMS HTML Browser
  • Configure Report Template File Size
  • Configure Report Template File Type
  • Define and Load Dictionaries
  • Setting Up Client Computers
    • Configure Personal Firewall
    • About Using Safari on an iPad
    • Set Internet Options for Microsoft Internet Explorer
      • Set Up for Proxy Usage on Fully Qualified Application Tier Names
      • Turn Off Compatibility View in Internet Explorer
    • Download Required Applications
      • Download the Java Runtime Environment
      • Download Adobe Reader
      • Download the Java Virtual Machine to Client Computers
    • Logging In