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 TMS Architecture
• 1.2 TMS Technology Stack
• 1.3 Product Organization and Related Installation Documentation
• 1.4 Choosing a Character Set
• 1.5 Planning a TMS Database Tier Installation
  • 1.5.1 Database Tier Operating System Requirements
  • 1.5.2 Database Tier Character Set Requirements
  • 1.5.3 Database Tier System Requirements
    • 1.5.3.1 Compatibility with Oracle9i Database on Windows Database Servers
    • 1.5.3.2 Access on Windows Platforms
    • 1.5.3.3 Processors on Windows Platforms
    • 1.5.3.4 Windows Database Server Requires Separate Oracle Home
  • 1.5.4 Oracle Database 11g Release 2 (11.2.0.2) Patch Set 1 Requirements and Options
    • 1.5.4.1 Required Reading
    • 1.5.4.2 Oracle Text Option
• 1.6 Planning a TMS Application Tier Installation
  • 1.6.1 Application Tier Operating System Requirements
  • 1.6.2 Forms Server and Reports Server Requirements
    • 1.6.2.1 Permanent IP Address
    • 1.6.2.2 Oracle Application Servers
    • 1.6.2.3 Java Runtime Environment
  • 1.6.3 Installing TMS with Oracle Clinical
• 1.7 Planning a TMS Client Installation
  • 1.7.1 Client Tier Operating System Requirements
  • 1.7.2 Client Tier Application Requirements
• 1.8 Applying Oracle Critical Patch Updates
• 1.9 Applying the Latest TMS Patch Set

2 Installing Oracle Database 11g Release 2 (11.2.0.2) Patch Set 1 on UNIX

• 2.1 Performing Prerequisite Tasks for Installing Oracle Database 11g Release 2 (11.2.0.2) Patch Set 1
  • 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 11g Release 2 (11.2.0.2) Patch Set 1
  • 2.2.1 Install Oracle Database 11g Release 2 (11.2.0.2) Patch Set 1
  • 2.2.2 Install Oracle Database 11g Release 2 (11.2.0.2) Patch Set 1 Examples
  • 2.2.3 Install Patch 10213073 to Oracle Database 11g Release 2 (11.2.0.2) Patch Set 1
  • 2.2.4 Install CPU/PSU 10248523
• 2.3 Changing Permissions for Running oraenv Script

3 Installing Oracle Database 11g Release 2 (11.2.0.2) Patch Set 1 on Windows

• 3.1 Install Oracle Database 11g Release 2 (11.2.0.2) Patch Set 1
• 3.2 Install Oracle Database 11g Release 2 (11.2.0.2) Patch Set 1 Examples
• 3.3 Apply Patch Bundle 12767726
• 3.4 Install CPU/PSU 10248523

4 Installing and Configuring Oracle Application Server

• 4.1 Installing the Oracle Application Server Technology Stack
  • 4.1.1 Set the Windows Compatibility Mode for the setup.exe File
  • 4.1.2 Install Oracle Application Server 10g Release 2 (10.1.2.0.2)
    • 4.1.2.1 Attend to the Oracle Application Server 10g Release 2 Installation Screens
    • 4.1.2.2 Apply Oracle Application Server 10g Release 2 Patch Set 3 (10.1.2.3.0)
    • 4.1.2.3 Restart the Computer
  • 4.1.3 Install Oracle Application Server 10g Release 3 (10.1.3.1.0)
    • 4.1.3.1 Attend to the Oracle Application Server 10g Release 3 Installation Screens
    • 4.1.3.2 Apply Oracle Application Server 10g Release 3 Patch Set 5 (10.1.3.5.0)
    • 4.1.3.3 Configure the Oracle AS10gR3 Process Manager
    • 4.1.3.4 Restart the Computer
• 4.2 Setting Up Oracle Application Server 10g Release 3 for SSL
• 4.3 Modifying the Oracle Process Manager Service
• 4.4 Applying Critical Patch Updates
• 4.5 Setting Up the SQL*Net Connections for Existing Databases
  • 4.5.1 Test the Connection from the Application Servers to the Database
  • 4.5.2 Troubleshoot Network Connection Issues

5 Installing the TMS Front End Components

• 5.1 Options for Installing the TMS Front End Components
• 5.2 Installing the TMS Front End
  • 5.2.1 Attend to the TMS Front End Installation Screens
  • 5.2.2 Update the Mandatory System Registry Values for TMS Front End
• 5.3 Installing the TMS Reports Server
  • 5.3.1 Attend to the TMS Reports Server Installation Screens
  • 5.3.2 Change to namingServices if Reports and Forms Server Use Different Subnets
• 5.4 Installing the TMS Database Server Code
  • 5.4.1 Attend to the TMS Database Server Code Installation Screens

6 Creating a TMS Database

• 6.1 Review Database Requirements and Recommendations (All Databases)
  • 6.1.1 Start with a New Database Instance
  • 6.1.2 Use Lowercase SID Name with Oracle Clinical
  • 6.1.3 Check Required Tablespaces
  • 6.1.4 Use the Database Configuration Assistant
  • 6.1.5 Select Required Components
  • 6.1.6 Use Automatic Memory Management
  • 6.1.7 Set Initialization Parameters
  • 6.1.8 Modify tnsnames.ora
• 6.2 Install TMS Database Objects (Single or Master Database)
  • 6.2.1 Unlock Accounts Before Installing the TMS Database
  • 6.2.2 Start Installing the TMS Database
  • 6.2.3 Attend to the TMS Database Installation Screens
  • 6.2.4 Check the Database Log File
• 6.3 Install TMS Database Objects (Slave Databases Only)
  • 6.3.1 Check the Database Log File
• 6.4 Load the TMS Jar File (All Databases)
• 6.5 Load Reports (All Databases)
• 6.6 Create a TMS Administrator User Account (All Databases)
• 6.7 Register Databases Integrated with Oracle Clinical
  • 6.7.1 Start the Installer to Register Databases
  • 6.7.2 Attend to the TMS Database Registration Screens
• 6.8 Load Dictionaries (Single or Master Database)
• 6.9 Complete Distributed Environment Setup
  • 6.9.1 Export Data from the Master Database
  • 6.9.2 Import Data to the Slave Database
  • 6.9.3 Clean Up after Export and Import
  • 6.9.4 Complete the Creation of the Slave Database
  • 6.9.5 Setting Up and Starting Symmetric Replication
    • 6.9.5.1 Preliminary Steps to Start Replication
    • 6.9.5.2 Start Replication on the Master Database
    • 6.9.5.3 Start Replication on Each Slave Instance
  • 6.9.6 Register Slave Databases Integrated with Oracle Clinical

7 Upgrading Oracle Thesaurus Management System to Release 4.6.2

• 7.1 Upgrade to Oracle Database 11g Release 2 (11.2.0.2) Patch Set 1
• 7.2 Upgrade Cloned Databases
• 7.3 Install the Application Tier
• 7.4 Install the TMS Front End
• 7.5 Repair TMS Data
  • 7.5.1 Repairing TMS 4.6.1 Data
  • 7.5.2 Repairing TMS 4.6.0 Data
• 7.6 Upgrade a Single or Master TMS Database
  • 7.6.1 Suspend Symmetric Replication (Distributed Environment Only)
  • 7.6.2 Start the Database Upgrade
  • 7.6.3 Attend to the TMS Database Upgrade Installation Screens
  • 7.6.4 Check Installation Log for Errors
  • 7.6.5 Upgrade TMS Reports
  • 7.6.6 Configure DSI Import
  • 7.6.7 Load Dictionaries
  • 7.6.8 Create an Export File (Distributed Environments Only)
• 7.7 Upgrade Slave TMS Databases (Distributed Environments Only)
  • 7.7.1 Upgrade Slave Databases
  • 7.7.2 Upgrade TMS Reports
  • 7.7.3 Configure DSI Import
  • 7.7.4 Start Symmetric Replication
• 7.8 Applying the Latest Patch Set

8 Completing a New TMS Installation or Upgrade

• 8.1 Patch TMS
• 8.2 Change the Password for the opaconfig User
• 8.3 Set Up Database Connections
• 8.4 Update HTML Browser and Web Search Engine Bookmarks
• 8.5 Test the TMS Forms Server
• 8.6 Download the Java Virtual Machine to Client Computers
• 8.7 Add a Link to the TMS Launch Page for the HTML Browser
• 8.8 Configure the Document Repository
• 8.9 Define and Load Dictionaries