Skip Headers
Oracle® Thesaurus Management System Installation Guide
Release 4.6.1

Part Number A83780-11
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

6 Upgrading Oracle Thesaurus Management System

You can upgrade Oracle Thesaurus Management System (TMS) from Release 4.5.2 or Release 4.6 to Release 4.6.1.

This chapter includes the following topics:

Upgrading the Oracle Database

Upgrade the database to Oracle Database 11g; see Oracle 11g documentation. Install all the Enterprise Edition options.

Upgrading the Application Tier

To upgrade the application tier, complete the following tasks in the order given:

Install Oracle AS10g

Upgrade the TMS Forms Server (Front End)

Upgrade the TMS Database Server Code

Install Oracle AS10g

Install Oracle Application Server 10g Forms and Reports Services; see Installing Oracle AS10gR2.

Upgrade the TMS Forms Server (Front End)

Follow instructions in Installing the TMS Front End.

Upgrade the TMS Database Server Code

Follow instructions in Installing the TMS Database Server Code.

Upgrading TMS Databases

To upgrade the TMS databases, complete the following tasks:

Start the Installer

To begin the installation:

  1. Log in as a user with system administrator privileges.

  2. Insert Disk V17174-01 of the Oracle Clinical 4.6 and Oracle Thesaurus Management System 4.6.1 Media Pack.

  3. Locate and execute the following file:

    tms\install\setup.exe

    The Installer opens to the Welcome screen.

  4. Follow the instructions on the installation screens. The following section describes each screen and the required action

Attend to the Installer

Attend to the Installer screens:

Welcome

Click Next.

Specify File Locations

Enter values:

Source By default, the Installer displays the location in which you extracted the TMS patch. Accept this default value.

Destination Enter values for the Oracle Home you created when you installed Oracle AS10gR2. If the computer has multiple Oracle Homes, the Installer displays them all in the drop-down lists.

  • Name: Select the name of the correct Oracle Home; for example, FRHome1.

  • Path: Browse for the path to the correct Oracle Home; for example, D:\Oracle\FRHome1.

Click Next.

Select a product to install

Select TMS Database Upgrade and click Next.

Select Installation Type

Select Master and click Next.

TMS Server Code Home Directory

Accept the default value for the directory path of the server code; for example d:\opapps46\tms. Click Next.

Enter database connect string

Enter the database name. An alias must exist in tnsnames.ora for this database.


Note:

The Installer sets the LOCAL registry setting to default all connections to this database.

NLS Settings

NLS_LANG Oracle recommends the setting: AMERICAN_AMERICA.UTF8

See Choosing a Character Set.

NLS_DATE_FORMAT Enter a valid date value. A four-digit year is required. Oracle recommends DD-MON-RRRR.

Click Next.

Warning: Stop PSUB process

If you are integrating TMS with Oracle Clinical, stop the PSUB process on this database at this point, restarting it only after you have completely installed TMS.

Directory for data tablespace datafiles

Enter the directory for TMS data tablespace files in the appropriate syntax for your operating system, including a trailing slash. Use the same database name you entered as the connect string. For example:

UNIX: /u01/oradata/dbname/

Windows: Drive:\oradata\dbname\

Enter Password for schema

In a series of Installer screens, enter the passwords for SYS, SYSTEM, CTXSYS, OPA, TMS, RXC. You will need these passwords later.

Ignore Tablespace Creation Errors

You may want to ignore tablespace creation errors if you know that the necessary tablespaces already exist. Select Yes to ignore the errors; select No to view them if they occur.

Information

This screen informs you that the installer will start a SQL*Plus session during the installation and provides the location of the log file.

Summary

The Installer displays information about the installation, including space requirements and space available. Click Install.

Configure DSI Import

Enter following commands:

set LOCAL=databasename
sqlplus tms/password
exec tms_dsi_xml_schema.InstallSchemas;