1/11

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Oracle Documentation
• Related Documents
• Conventions

1 Preparing to Install Oracle Thesaurus Management System

• 1.1 Installation and User Documentation
  • 1.1.1 My Oracle Support Articles
  • 1.1.2 User Documentation
• 1.2 Architecture
• 1.3 Technology Stack
  • 1.3.1 Planning a TMS Database Installation
    • 1.3.1.1 Character Set Requirements
    • 1.3.1.2 Critical Patch Update
    • 1.3.1.3 Database Tier Operating System Requirements
    • 1.3.1.4 Database Tier System Requirements
    • 1.3.1.5 Oracle Database Requirement: Oracle Text Option
  • 1.3.2 Planning a TMS Application Tier Installation
    • 1.3.2.1 Character Set Requirements
    • 1.3.2.2 Critical Patch Update
    • 1.3.2.3 Permanent IP Address
    • 1.3.2.4 Installing TMS with Oracle Clinical
  • 1.3.3 Planning a TMS Client Installation
• 1.4 Downloading and Extracting the Software
  • 1.4.1 Creating Staging Areas
    • 1.4.1.1 Database Server Staging Area
    • 1.4.1.2 Application Server Staging Area
  • 1.4.2 Downloading and Extracting the Oracle Clinical 5.1 and Oracle Thesaurus Management System 5.1 media pack
  • 1.4.3 Downloading and Extracting Patches from My Oracle Support
  • 1.4.4 Downloading Oracle Java Development Kit
  • 1.4.5 Downloading the Java Runtime Environment
  • 1.4.6 Downloading Adobe Reader
• 1.5 Using the Silent Installer
• 1.6 Reviewing the Installation Log Files
• 1.7 Choosing a Character Set
• 1.8 Applying Oracle Critical Patch Updates
• 1.9 Applying the Latest TMS Patch Set

2 Installing Oracle Database on UNIX

• 2.1 Performing Prerequisite Tasks for Installing Oracle Database
  • 2.1.1 Create Owners, Groups, and Mount Points
  • 2.1.2 Configure Kernel Resources and Adjust Operating System Environment
  • 2.1.3 Install Latest Operating System Patches
• 2.2 Installing Oracle Database
  • 2.2.1 Install Oracle Database 12.1.0.1 Enterprise Edition
  • 2.2.2 Install Oracle Database Examples

3 Installing Oracle Database on Windows

• 3.1 Install Oracle Database 12.1.0.1 Enterprise Edition
• 3.2 Install Oracle Database Examples

4 Creating a TMS Database

• 4.1 Restart Computer and Stop All Servers and Services
• 4.2 Installing the TMS Database Server Code
  • 4.2.1 Gather Required Information
  • 4.2.2 Start the TMS Server Installer
  • 4.2.3 Attend to the TMS Database Server Code Installation Screens
• 4.3 Review Database Requirements and Recommendations (All Databases)
  • 4.3.1 Start with a New Database Instance
  • 4.3.2 Accept Connections as a Service
  • 4.3.3 Check Required Tablespaces
  • 4.3.4 Use the Database Configuration Assistant
  • 4.3.5 Select Required Components
  • 4.3.6 Use Automatic Memory Management
  • 4.3.7 Set Initialization Parameters
  • 4.3.8 Modify the tnsnames.ora File on the Database Server
• 4.4 Install TMS Database Objects (All Databases)
  • 4.4.1 Unlock Accounts Before Installing the TMS Database
  • 4.4.2 Gather Required Information
  • 4.4.3 Stop the PSUB Process (If Integrated with Oracle Clinical)
  • 4.4.4 Start the Installer
  • 4.4.5 Attend to the TMS Database Installer Screens
  • 4.4.6 Check the Database Log File
• 4.5 Create a TMS Administrator User Account (All Databases)
• 4.6 Register Databases Integrated with Oracle Clinical
  • 4.6.1 Gather Required Information
  • 4.6.2 Start the Installer
  • 4.6.3 Attend to the TMS Database Registration Screens
• 4.7 Load Dictionaries (Single or Master Database)
• 4.8 Complete Distributed Environment Setup
  • 4.8.1 Export Data from the Master Database
  • 4.8.2 Import Data to the Slave Database
  • 4.8.3 Clean Up after Export and Import
  • 4.8.4 Complete the Creation of the Slave Database
  • 4.8.5 Configure DSI Import
  • 4.8.6 Setting Up and Starting Symmetric Replication
    • 4.8.6.1 Preliminary Steps to Start Replication
      • 4.8.6.1.1 Check the initdbname.ora File
      • 4.8.6.1.2 Run the opasrc01.sql Script
      • 4.8.6.1.3 Run the opasrc02.sql Script
    • 4.8.6.2 Start Replication on the Master Database
    • 4.8.6.3 Start Replication on Each Slave Instance
  • 4.8.7 Register Slave Databases Integrated with Oracle Clinical

5 Installing and Configuring the Application Tier

• 5.1 Before You Start
  • 5.1.1 Identify a Single Account to Perform All Application Tier Installation Tasks
  • 5.1.2 Get a CA Certificate for HTTPS
• 5.2 Install Adobe Reader
• 5.3 Install Oracle Java Development Kit
• 5.4 Install Oracle WebLogic Server 10.3.6
• 5.5 Install and Configure Oracle Application Server 11gR2
  • 5.5.1 Install Oracle Application Server 11gR2 (11.1.2.1)
  • 5.5.2 Stop Services
  • 5.5.3 Apply Patch
  • 5.5.4 Create ORACLE_INSTANCE Environment Variable
• 5.6 Enable SSL Between a Browser and Oracle HTTP Server
  • 5.6.1 Enabling SSL Between a Browser and Oracle HTTP Server Using a Certificate Authority
    • 5.6.1.1 Creating an Oracle Wallet and Generating a Certificate Request
    • 5.6.1.2 Obtain Trusted Certificate and User Certificate from Certificate Authority
    • 5.6.1.3 Import the User Certificate and Trusted Certificate to OWM
    • 5.6.1.4 Edit the Oracle HTTP Server Configuration File
      • 5.6.1.4.1 Add the New Wallet Location and Specify Port
      • 5.6.1.4.2 Make OHS Compatible with Internet Explorer 9 and Above
      • 5.6.1.4.3 Add Security Settings
  • 5.6.2 Enabling SSL Between a Browser and Oracle HTTP Server With Self Signing
• 5.7 Install Oracle Application Developer FrameWork and Apply Patches
  • 5.7.1 Install Oracle Application Developer Framework (ADF)
  • 5.7.2 Upgrade ADF
  • 5.7.3 Patch ADF to Support Internet Explorer 11
• 5.8 Modify the tnsnames.ora File on the Application Server
• 5.9 Test Connectivity to Databases for Forms and Reports Servers
  • 5.9.1 Test the Connection from the Application Servers to the Database
  • 5.9.2 Troubleshoot Network Connection Issues
• 5.10 Restart the Computer

6 Installing Oracle Thesaurus Management System Application Components

• 6.1 Restart Computer and Stop All Servers and Services
• 6.2 Installing the TMS Front End
  • 6.2.1 Gather Required Information
  • 6.2.2 Start the Installer
  • 6.2.3 Attend to the TMS Front End Installer Screens
  • 6.2.4 Review the Installation Log File
  • 6.2.5 Restart the Computer
  • 6.2.6 Add WebLogic Data Sources If Using Multiple Databases
• 6.3 Make the Java Runtime Environment Available for Download
• 6.4 Installing the TMS Reports Server
  • 6.4.1 Start the WebLogic FRDomain Admin Server
  • 6.4.2 Gather Required Information
  • 6.4.3 Start the TMS Report Server Installer
  • 6.4.4 Attend to the TMS Reports Server Installation Screens
• 6.5 Verifying the Application Tier Installation
• 6.6 Verify and Fix Environment Variables
  • 6.6.1 Check Values
  • 6.6.2 Correct Values
• 6.7 Set Up Automatic Startup
  • 6.7.1 Set Up Script to Execute Automatically at Machine Startup
  • 6.7.2 Verify Autostart Scripts
  • 6.7.3 Test Autostart
• 6.8 Starting Servers Manually
  • 6.8.1 Starting the FRDomain Admin Server
  • 6.8.2 Starting the Forms Server
  • 6.8.3 Starting the Reports Server
  • 6.8.4 Starting the OPADomain Admin Server
  • 6.8.5 Starting the OpaServer1 Server
• 6.9 Verify the Application Tier Installation
• 6.10 Stopping Servers
  • 6.10.1 Stopping the Forms Server
  • 6.10.2 Stopping the Reports Server
  • 6.10.3 Stopping the FRDomain Admin Server
  • 6.10.4 Stopping the OPADomain Admin Server
  • 6.10.5 Stopping the OpaServer1 Server

7 Upgrading Oracle Thesaurus Management System to Release 5.1

• 7.1 Upgrade Oracle Clinical (If Integrated with Oracle Clinical)
• 7.2 Install Oracle Database
  • 7.2.1 Installing the Oracle Database Server on UNIX
  • 7.2.2 Installing the Oracle Database Server on Windows
• 7.3 Install the TMS Database Server Code
• 7.4 Upgrade a Single or Master TMS Database
  • 7.4.1 Suspend Symmetric Replication (Distributed Environment Only)
  • 7.4.2 Prevent Access to Oracle Thesaurus Management System Databases
  • 7.4.3 Upgrade to Oracle Database 12.1.0.1
    • 7.4.3.1 Upgrade in Place
    • 7.4.3.2 Clone Your Database
  • 7.4.4 Gather Required Information
  • 7.4.5 Stop PSUB Process (If Integrated with Oracle Clinical)
  • 7.4.6 Start the Installer
  • 7.4.7 Attend to the TMS Database Upgrade Installer Screens
  • 7.4.8 Set Initialization Parameters
  • 7.4.9 Check Installation Log for Errors
  • 7.4.10 Configure DSI Import
  • 7.4.11 Load Dictionaries
  • 7.4.12 Create an Export File (Distributed Environments Only)
• 7.5 Upgrade Slave TMS Databases (Distributed Environments Only)
• 7.6 Upgrade Cloned Databases
• 7.7 Run Scripts to Gather Schema Statistics for the 11g Optimizer
• 7.8 Install or Upgrade the Application Tier Technology Stack
  • 7.8.1 Upgrading from a Release Earlier than 5.1
• 7.9 Install the TMS Front End and Reports Server
  • 7.9.1 Install the Oracle Thesaurus Management System Front End and Reports Server
  • 7.9.2 Set Remote Method Invocation (RMI) JDBC Security to Secure
• 7.10 Redefine the TMS Load User

8 Post-Installation Steps for the New Installation or Upgrade

• 8.1 Patch TMS
• 8.2 Test the TMS Forms Server
• 8.3 Configure WebLogic Server Data Sources
  • 8.3.1 Confirm the OPA Data Source Value in WebLogic Server Admin Console
  • 8.3.2 Set REPORT_CONFIG Reference Codelist Value
  • 8.3.3 Add Data Source (Required Only If Using Multiple Databases)
• 8.4 Making the Java Runtime Environment Available for Download
• 8.5 Create a Link to TMS HTML Browser
• 8.6 Define and Load Dictionaries
• 8.7 Setting Up Client Computers
  • 8.7.1 Configuring Personal Firewall
  • 8.7.2 Using Safari on an iPad
  • 8.7.3 Setting Internet Options for Microsoft Internet Explorer
    • 8.7.3.1 Setting Document Mode to Quirks (the Default Setting)
    • 8.7.3.2 Disabling Cookies
    • 8.7.3.3 Allowing More Connections
    • 8.7.3.4 Turning Off Compatibility View
    • 8.7.3.5 Set Up for Proxy Usage on Fully Qualified Application Tier Names
  • 8.7.4 Download the Java Virtual Machine to Client Computers
  • 8.7.5 Logging In