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) 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
Parent topic: Creating a TMS Database
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.
Parent topic: Review Database Requirements and Recommendations
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.
Note:
If you are installing the Oracle Thesaurus Management System database on a pluggable Oracle 12.1.0.2 database (PDB), see My Oracle Support article ID 1910177.1, How To Configure TNS / SQLNET using the local_listener parameter for Pluggable Database In Oracle 12c, Allowing a SQLNET Connection to the PDB.
Parent topic: Review Database Requirements and Recommendations
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 |
Parent topic: Review Database Requirements and Recommendations
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
Parent topic: Review Database Requirements and Recommendations
Select Required Components
When you create a TMS database, select the following mandatory components:
-
Oracle Text
-
Oracle JVM
-
Oracle XML DB
Parent topic: Review Database Requirements and Recommendations
Use Automatic Memory Management
Oracle recommends that you use the Oracle Database Automatic Memory Management feature for a new or an upgraded TMS database.
Parent topic: Review Database Requirements and Recommendations
Set Initialization Parameters
For information, see details under Initialization Parameters option in Install and Configure Oracle Database.
Parent topic: Review Database Requirements and Recommendations