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 Documentation on Oracle Technology Network
• Related Documents
• Oracle CPU Security Update Patches
• Conventions

1 Preparing to Install Oracle Thesaurus Management System

• About the TMS Network Architecture
• Planning a TMS Database Tier Installation
  • Database Tier Operating System Requirements
  • Database Tier System Resource Requirements
  • Prerequisite Tasks for Oracle Database 11g
  • Database Tier Character Set Requirements
  • UNIX Database Server Requirements
    • Compatibility with Oracle9i Database on UNIX Database Servers
  • Windows Database Server Requirements
    • Compatibility with Oracle9i Database on Windows Database Servers
    • Access on Windows Platforms
    • Processors on Windows Platforms
    • Windows Database Server Requires Separate Oracle Home
  • Oracle Database 11g Requirements
    • Required Reading
    • Oracle Text Option
• Planning a TMS Application Tier Installation
  • Application Tier Operating System Requirements
  • Forms Server and Reports Server Requirements
    • Permanent IP Address
    • Oracle Application Server 10g Release 2 Forms and Reports Services
    • Java Runtime Environment
    • Internet Explorer Requirements
• Planning a TMS Client Installation
  • Client Tier Operating System Requirements
  • Client Tier Application Requirements
• Choosing a Character Set

2 Installing the Database Server on UNIX

• Installing and Patching Oracle Database 11g
  • Install Oracle Database 11g Release 11.1.0.6.0
  • Install Oracle Database Examples 11g Release 1
  • Apply Oracle Database 11g Patch Set 1
  • Apply Oracle Database 11g Standalone Patches
  • Change Permissions on the oraclehomeproperties.xml File
  • Modify the oraenv Script for Oracle Solaris
• Adjusting the Operating System Environment

3 Installing the Database Server on Windows

• Install Oracle Database 11g Release 11.1.0.6.0
• Install Oracle Database Examples 11g Release 1
• Apply Oracle Database 11g Patch Set 1
• Apply Oracle Database 11g Patch Bundle 8451592

4 Installing the Application Tier

• Installing Oracle AS10gR2
  • Install Oracle AS10gR2
  • Restart the Computer
  • Apply Oracle AS10gR2 Patch Set 3 (10.1.2.3)
  • Apply Application Server Patch 7384879
• Locating TMS 4.6.1 and Starting the Installer
• Installing the TMS Front End
• Installing the TMS Reports Server
  • Change to namingServices if Reports and Forms Server Use Different Subnets
• Installing the TMS Database Server Code
  • Start the Installer
  • Attend to the Installer
• Setting Up SQL*Net Connections to TMS Databases
  • Maintain a Central Copy of the tnsnames.ora File
  • Troubleshoot Network Connection Issues
• Adding Printers

5 Creating a TMS Database

• Reviewing Database Requirements and Recommendations
  • Start with a New Database Instance
  • Use Lowercase SID Name with Oracle Clinical
  • Check Required Tablespaces
  • Select Required Components
  • Use the Database Configuration Assistant
  • Use Automatic Memory Management
  • Set Initialization Parameters
  • Modify tnsnames.ora
• Installing TMS Database Objects
  • Unlock Accounts
  • Start the Installer
  • Attend to the Installer
• Loading Reports
• Registering Databases Integrated with Oracle Clinical
  • Start the Installer
  • Attend to the Installer
• Creating a TMS Administrator-Level User Account on the Database

6 Upgrading Oracle Thesaurus Management System

• Upgrading the Oracle Database
• Upgrading the Application Tier
  • Install Oracle AS10g
  • Upgrade the TMS Forms Server (Front End)
  • Upgrade the TMS Database Server Code
• Upgrading TMS Databases
  • Start the Installer
  • Attend to the Installer
  • Configure DSI Import

7 Completing a New Installation or Upgrade

• Patching TMS
• Changing the Default opaconfig Password
• Setting Up Database Connections
• Updating HTML Browser and Web Search Engine Bookmarks
• Testing the TMS Forms Server
• Downloading the Java Virtual Machine to Client Computers
• Adding a Link to the TMS Launch Page for the HTML Browser
• Configuring the Document Repository
• Defining and Loading Dictionaries