Mandatory configuration

Most of the default Oracle settings can be used for the Oracle Central Designer database. However, the following Oracle configuration must be used.

Page Option Value

Database Components

Oracle Text, a standard database component.

Selected.

Tip: The Oracle database software installation requires that you install Oracle Data Mining if you install Oracle Text. If you do not want to install Oracle Data Mining, you can install Oracle Text manually after completing the Oracle database installation.

--

Oracle Java Virtual Machine (JVM)

Selected.

Character Sets

Database Character Set

AL32UTF8 - Unicode 4.0 UTF universal character set, UTF-8 compliant.

--

National Character Set

AL16UTF16 - Unicode UTF-16 universal character set.

Parameters

CURSOR_SHARING parameter

FORCE

--

OPEN_CURSORS parameter

500

Additional configuration information

In production databases at Oracle, the DB_BLOCK_SIZE Oracle parameter is set to 16k (16384 bytes).