Review Database Requirements and Recommendations

A TMS database can be installed on Windows, UNIX, Solaris, or Itanium. You must install the TMS Database Server (always on Windows on the Application Tier where TMS Front End will be installed) before installing a TMS database.

Before you install the TMS database component, review the following requirements and recommendations for each TMS database you plan to install.

• Start with a New Database Instance
  
• Accept Connections as a Service
  
• Check Required Tablespaces
  
• Use the Database Configuration Assistant
  
• Select Required Components
  
• Use Automatic Memory Management
  
• Set Initialization Parameters
  

Start with a New Database Instance

Oracle recommends that you set up a new database instance so that neither TMS nor its installation process interferes with other applications. However, you can install TMS on an existing database instance.

Accept Connections as a Service

Choose to configure the database to accept connections as a service instead of a SID. Service name requirements for Oracle Thesaurus Management System include:

• The service name must be less than 15 characters long.

• It must not include the domain.

• It must be all lowercase.

Check Required Tablespaces

Table 4-1 lists the tablespaces, along with their minimum size, required for TMS. Make sure the database contains these tablespaces. The best practice is to create them with the Autoextend On option, to avoid running out of space.

In addition, you may need to increase the minimum sizes for your installation.

Table 4-1 Required Tablespaces and Sizes

Tablespace	Minimum Size
SYSTEM	900 MB
TEMP	100 MB
UNDOTBS1	700 MB
USERS	500 MB
SYSAUX	600 MB

Use the Database Configuration Assistant

To create a new database, use the Oracle Database Configuration Assistant. For instructions about the Database Configuration Assistant, see the Oracle Database 19c Release (19.3.0.0) documentation, including online help and the Oracle Database Installation Guide for the appropriate version and operating system.

Notes:

• Use the Custom Database installation option.

• The following parameters are not listed under All Initialization Parameters. Click Show Advanced Parameters to set the following parameters as described in Set Initialization Parameters:

  • Db_cache_size

  • Db_files

  • Java_pool_size

  • Job_queue_process

  • Large_pool_size

• The Custom installation option allows access to the Database Storage screen, where you can expand the Tablespaces folder in the tree on the left side of the screen and edit the following tablespaces as required; see Check Required Tablespaces

Select Required Components

When you create a TMS database, select the following mandatory components:

• Oracle Text

• Oracle JVM

• Oracle XML DB

Use Automatic Memory Management

Oracle recommends that you use the Oracle Database Automatic Memory Management feature for a new or an upgraded TMS database.

Set Initialization Parameters

For information, see details under Initialization Parameters option in Install and Configure Oracle Database.