Contents

List of Examples

List of Figures

List of Tables

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.0.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 11.2.0.4 Enterprise Edition
  • 2.2.2 Install Oracle Database Examples

3 Installing Oracle Database on Windows

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

4 Installing and Configuring the Application Tier

• 4.1 Before You Start
  • 4.1.1 Identify a Single Account to Perform All Application Tier Installation Tasks
  • 4.1.2 Getting a CA Certificate for HTTPS
• 4.2 Installing Adobe Reader
• 4.3 Installing Oracle Java Development Kit
• 4.4 Installing and Configuring Oracle WebLogic Server
• 4.5 Installing and Configuring Oracle Application Server
  • 4.5.1 Install Oracle Application Server 11gR2 (11.1.2.1)
  • 4.5.2 Edit setDomainEnv.cmd
  • 4.5.3 Create ORACLE_INSTANCE Environment Variable
• 4.6 Enabling SSL Between a Browser and Oracle HTTP Server
  • 4.6.1 Enabling SSL Between a Browser and Oracle HTTP Server Using a Certificate Authority
    • 4.6.1.1 Creating an Oracle Wallet and Generating a Certificate Request
    • 4.6.1.2 Obtain Trusted Certificate and User Certificate from Certificate Authority
    • 4.6.1.3 Importing the User Certificate and Trusted Certificate to OWM
    • 4.6.1.4 Edit the Oracle HTTP Server Configuration File
      • 4.6.1.4.1 Add the New Wallet Location and Specify Port
      • 4.6.1.4.2 Make OHS Compatible with Internet Explorer 9 and 10
      • 4.6.1.4.3 Add Security Settings
  • 4.6.2 Enabling SSL Between a Browser and Oracle HTTP Server With Self Signing
• 4.7 Installing Oracle Application Developer FrameWork and Applying Patches
  • 4.7.1 Install Oracle Application Developer Framework (ADF)
  • 4.7.2 Upgrade ADF
• 4.8 Modifying the tnsnames.ora File
• 4.9 Testing Connectivity to Databases for Forms and Reports Servers
  • 4.9.1 Test the Connection from the Application Servers to the Database
  • 4.9.2 Troubleshoot Network Connection Issues
• 4.10 Restart the Computer

5 Creating a TMS Database

• 5.1 Restart Computer and Stop All Servers and Services
• 5.2 Installing the TMS Database Server Code
  • 5.2.1 Gather Required Information
  • 5.2.2 Start the TMS Server Installer
  • 5.2.3 Attend to the TMS Database Server Code Installation Screens
• 5.3 Review Database Requirements and Recommendations (All Databases)
  • 5.3.1 Start with a New Database Instance
  • 5.3.2 Use Lowercase SID Name with Oracle Clinical
  • 5.3.3 Check Required Tablespaces
  • 5.3.4 Use the Database Configuration Assistant
  • 5.3.5 Select Required Components
  • 5.3.6 Use Automatic Memory Management
  • 5.3.7 Set Initialization Parameters
  • 5.3.8 Modify the tnsnames.ora File
• 5.4 Install TMS Database Objects (All Databases)
  • 5.4.1 Unlock Accounts Before Installing the TMS Database
  • 5.4.2 Gather Required Information
  • 5.4.3 Stop PSUB Process (If Integrated with Oracle Clinical)
  • 5.4.4 Start the Installer
  • 5.4.5 Attend to the TMS Database Installer Screens
  • 5.4.6 Check the Database Log File
• 5.5 Create a TMS Administrator User Account (All Databases)
• 5.6 Register Databases Integrated with Oracle Clinical
  • 5.6.1 Gather Required Information
  • 5.6.2 Start the Installer
  • 5.6.3 Attend to the TMS Database Registration Screens
• 5.7 Load Dictionaries (Single or Master Database)
• 5.8 Complete Distributed Environment Setup
  • 5.8.1 Export Data from the Master Database
  • 5.8.2 Import Data to the Slave Database
  • 5.8.3 Clean Up after Export and Import
  • 5.8.4 Complete the Creation of the Slave Database
  • 5.8.5 Configure DSI Import
  • 5.8.6 Setting Up and Starting Symmetric Replication
    • 5.8.6.1 Preliminary Steps to Start Replication
      • 5.8.6.1.1 Check the initdbname.ora File
      • 5.8.6.1.2 Run the opasrc01.sql Script
      • 5.8.6.1.3 Run the opasrc02.sql Script
    • 5.8.6.2 Start Replication on the Master Database
    • 5.8.6.3 Start Replication on Each Slave Instance
  • 5.8.7 Register Slave Databases Integrated with Oracle Clinical

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.3 Installing the TMS Reports Server
  • 6.3.1 Start the WebLogic FRDomain Admin Server
  • 6.3.2 Gather Required Information
  • 6.3.3 Start the TMS Report Server Installer
  • 6.3.4 Attend to the TMS Reports Server Installation Screens
• 6.4 Verifying the Application Tier Installation
• 6.5 Setting Up Automatic Startup of Servers and Services
• 6.6 Starting Servers Manually
  • 6.6.1 Starting the FRDomain Admin Server
  • 6.6.2 Starting the Forms Server
  • 6.6.3 Starting the Reports Server
  • 6.6.4 Starting the OPADomain Admin Server
  • 6.6.5 Starting the OpaServer1 Server
• 6.7 Stopping Servers
  • 6.7.1 Stopping the Forms Server
  • 6.7.2 Stopping the Reports Server
  • 6.7.3 Stopping the FRDomain Admin Server
  • 6.7.4 Stopping the OPADomain Admin Server
  • 6.7.5 Stopping the OpaServer1 Server

7 Upgrading Oracle Thesaurus Management System to Release 5.0.1

• 7.1 Upgrade to Release 4.6.2 If Necessary
• 7.2 Upgrade to Oracle Database 11.2.0.4
  • 7.2.1 Upgrade Oracle Database in UNIX
  • 7.2.2 Upgrade Oracle Database in UNIX
• 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 Upgrade the Database to Oracle Database 11.2.0.4
  • 7.4.3 Gather Required Information
  • 7.4.4 Stop PSUB Process (If Integrated with Oracle Clinical)
  • 7.4.5 Start the Installer
  • 7.4.6 Attend to the TMS Database Upgrade Installer Screens
  • 7.4.7 Check Installation Log for Errors
  • 7.4.8 Configure DSI Import
  • 7.4.9 Load Dictionaries
  • 7.4.10 Create an Export File (Distributed Environments Only)
• 7.5 Upgrade Slave TMS Databases (Distributed Environments Only)
  • 7.5.1 Upgrade Slave Databases
  • 7.5.2 Configure DSI Import
  • 7.5.3 Start Symmetric Replication
• 7.6 Upgrade Cloned Databases
• 7.7 Run Scripts to Gather Schema Statistics for the 11g Optimizer
• 7.8 Install the Application Tier Technology Stack
• 7.9 Install the TMS Front End and Reports Server

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 Configure the Document Repository
• 8.7 Define and Load Dictionaries
• 8.8 Setting Up Client Computers
  • 8.8.1 Configuring Personal Firewall
  • 8.8.2 Using Safari on an iPad
  • 8.8.3 Setting Internet Options for Microsoft Internet Explorer
    • 8.8.3.1 Setting Document Mode to Quirks (the Default Setting)
    • 8.8.3.2 Disabling Cookies
    • 8.8.3.3 Allowing More Connections
    • 8.8.3.4 Turning Off Compatibility View
    • 8.8.3.5 Set Up for Proxy Usage on Fully Qualified Application Tier Names
  • 8.8.4 Download the Java Virtual Machine to Client Computers
  • 8.8.5 Logging In

Index