Installing and configuring Oracle Database

Use the following instructions to install and configure Oracle Database for use with .

Before you begin

You should have advanced knowledge of Oracle Database (at the DBA level) before you change the database settings as recommended in this documentation.
For more information about Oracle Database, go to the Oracle Database home page. You can obtain copies of the Oracle Database documentation and software from the Oracle Technology Network. The Oracle Database information in this documentation is provided only as a guideline.
You can access Oracle Database patches and patch sets at the Oracle Metalink Web Page.
For more information about Oracle database terminology and concepts, see the Oracle Concepts document that is provided with your purchase of Oracle.

Procedure

Install Oracle Database. The following versions are supported for use with :
- Oracle Database 19c
For more information about installing Oracle, see the Oracle Database Installation Guide for Linux.

Create and configure a non-CDB database for use with before you deploy .

When you create and configure a non-CDB Oracle Database, take note of the following information:

User account to own Oracle software
Oracle Database home directory
Oracle database name
Oracle SID for database
Oracle ID and password for database administrator
Oracle ID and password for database user
Oracle TCP/IP listener port number

This information is needed when you deploy .

For security reasons, ensure that an Oracle DBA account is not used as the database user.

Also, do not use SYSTEM or SYS as user IDs for the schema.

Note: It is recommended that you use the Oracle automatic memory management feature to manage the Oracle database memory on your system. For details on the Oracle automatic memory management feature, see your Oracle documentation.

Ensure that the following settings are applied when you create your Oracle Database through the Oracle Database configuration assistant:

The following settings are recommended.

Recommended database parameter settings for Oracle 19c
Parameter	Value
block size	8 KB
open_cursors	1000
MEMORY_TARGET	700 MB
MEMORY_MAX_TARGET	700 MB

Ensure that the database uses the following character sets:

Required database parameter settings for Oracle 19c
Parameter	Value
Database character set	AL32UTF8
National character set	UTF8

Important: Refer to the Oracle Database documentation for instructions on setting or changing database parameters. Ensure that you set these values correctly because you cannot change the character sets after the database is created.

If you intend to support multi-byte languages, for example, German (de_DE), ensure that NLS_LENGTH_SEMANTICS is set to CHAR. For more information, see .

Several columns of the TI_ATTR table have had their data type changed from CLOB. The six columns are now defined as varchar(32672) in DB2, and varchar2(32767) for Oracle in the wc-dataimport-preprocess-attribute.xml configuration file. The same change has been made in the ATTRIBUTES column of TI_ADATTR. This change reduces the preprocessing time of these two tables.
This change requires that Oracle users enable the "Extended Data Types" feature described in https://oracle-base.com/articles/19c/articles-19c. If you are migrating from a previous version, ensure that you drop all temporary tables before proceeding.
Note: You must also execute the instruction highlighted below, or the Oracle database will not come back online after a restart. You need only execute this instruction once.
```
CONN / AS SYSDBA
SHUTDOWN IMMEDIATE;
STARTUP UPGRADE;
ALTER SYSTEM SET max_string_size=extended;
@?/rdbms/admin/utl32k.sql
SHUTDOWN IMMEDIATE;
STARTUP;
```
Complete the creation of your database. For information about creating your database, see the Oracle documentation.

Results

The is now configured and ready to use in your .