6 Installing Oracle Thesaurus Management System

This section includes the following topics:

• Set Up a Windows Computer for Launching the TMS Installation

• Setting up the SQL*Net Connections for Existing Databases

• Install the TMS Server

• Install the TMS Database

• Apply TMS Patch

• Check the def_instance_name Column Value

The Oracle Life Sciences Data Hub (Oracle LSH) uses the Oracle Thesaurus Management System (TMS) Release 4.6.1 database tier internally for its classification system.

Users who will run Oracle LSH APIs that insert, delete, or modify Oracle LSH classification hierarchies and terms (LSH Classification Admin tasks) need security access for their Oracle LSH database account to the Oracle Thesaurus Management System (TMS) instance that is installed as part of Oracle LSH. See "Creating Database Accounts" in the Oracle Life Sciences Data Hub System Administrator's Guide for further information.

Note:

If you have installed RAC and you have Load Balancing and Failover enabled, the database connection may change from one node to another on the server side. To avoid this problem, shut down all but one database node for the duration of the TMS installation.

Set Up a Windows Computer for Launching the TMS Installation

Oracle LSH uses only the database portion of TMS, which you must install into the Oracle LSH database. However, you must install TMS using the Oracle Universal Installer from a Windows computer. You will not need this computer to run Oracle LSH, but you should maintain it for the purpose of applying any patches to TMS that may be required in the future.

The Windows computer should have Windows 2003 or 2008. See My Oracle Support document 333701.1, Oracle Life Sciences Applications Windows 2003 Support Notice.

The Windows computer must have a 11g Client Oracle Home. When you install almost any Oracle product, you establish an Oracle Home and SQL*Plus. If you already have a Windows computer with an Oracle Home directory and SQL*Plus at Release 11g, you can proceed directly to Install the TMS Server.

If not, install the Oracle Database 11g Release 1 Client for Microsoft Windows, which is included in the media pack in both:

• B43982-01 for Windows 2003 Server

• V15836-01 for Windows 2008 Server

Setting up the SQL*Net Connections for Existing Databases

Ensure that SQL*Net connections exist between the TMS Application Server computer and any Oracle LSH databases you have already created by modifying the file tnsnames.ora to include entries for all the databases and TMS Application Servers. The tnsnames.ora file for the 11g Client Oracle Home is located at oracle_home\network\admin.

Network Troubleshooting

If the system returns a connection error, you must resolve this problem before continuing. Possible causes of error include:

• The computer is not physically connected to the network.

• The network protocol software is not loaded on the computer (try a remote log-in to check).

• The SQL*Net software is not loaded on the computer.

• The database or SQL*Net listener process is not started on the server.

• An incorrect connect string, userid or password, was entered.

• The tnsnames.ora file is not present in the correct directory or does not contain the correct entries.

Install the TMS Server

Follow instructions in the TMS Release 4.6.1 Installation Guide sections specified below with the Oracle LSH specification noted. Download the most recent version of this document from My Oracle Support as document 859752.1; see "Finding Information and Patches on My Oracle Support".

1. Install the Oracle TMS Release 4.6.1 Server; see Section 4.5, Installing the TMS Database Server Code.

   Specify the $ORACLE_HOME you created in Set Up a Windows Computer for Launching the TMS Installation (or the most recent Oracle Home, if you are using an existing Oracle Home).

2. At the end of the installation, click Exit (not Next Install).

Note:

Do not follow the instructions in the other sections of this chapter.

Install the TMS Database

Install the TMS database wherever you have installed the Oracle LSH database. To install the TMS database, do the following:

1. On the Windows server add the environment variable USE_DEFAULT_OUI_OH with a value of 1.

2. Add an initialization parameter db_domain to the database with a value of your_company_name.com.

   Note:

   To integrate TMS with Oracle LSH, the database short global name must be the same as the Oracle SID. If they are not the same, you must change the short global name to match the Oracle SID.

   For example, if the Oracle SID is LSHX2R10, the short global name must also be set to LSHX2R10.

   Note:

   You must also add the database's tnsname (which is the same as its Oracle SID) to the tnsnames.ora file on the current server.

3. Install the Oracle TMS 4.6.1 database; in the TMS Release 4.6.1 Installation Guide follow instructions the following sections only.

   • Section 5.1.1.4 Setting Initialization Parameters

   • Section 5.2 Installing TMS Database Objects

   Note:

   You are prompted to enter passwords for various accounts. Make a note of these passwords.

   If you are installing on Linux, follow the UNIX-specific instructions where they are provided.

Apply TMS Patch

Apply TMS patch 4.6.1.7 (patch number 9728948) using instructions in the release notes.

Check the def_instance_name Column Value

Check the value of the def_instance_name column in the tms_def_instances table. It must have a value in all UPPERCASE in the form of DB_NAME.DOMAINNAME.

If necessary, in SQL*Plus, enter the following:

update tms_def_instances set def_instance_name='DB_NAME.DOMAIN_NAME'

For example, where the database name is LSHX2R10 and the domain name is us. oracle.com:

update tms_def_instances set def_instance_name='LSHX2R10.US.ORACLE.COM'