Database configuration for Oracle Database

This section describes the minimum database requirements that must be fulfilled before creating StreamServe repositories in a testing environment.

For detailed information, see OpenText StreamServe Oracle Database Database Guidelines, available at OpenText Knowledge Center.

Database configuration

•	Specify the following database server parameter:

Parameter	Value
db_block_size	Must be at least 8192. Note: If the database server has more than 4 GB memory, you can raise this value to 16384.

•	Create a UTF database with:

–	Character set AL32UTF8.

–	National character set AL16UTF16.

•	Make all tablespaces locally managed.

•	Where applicable, make tablespaces automatic segment space managed (SEGMENT SPACE MANAGEMENT AUTO, which is default on Oracle 11g).

•	For Oracle 12c, create a service name in tnsnames.ora for every PDB (pluggable database) you want use for a StreamServe repository.

Increasing Unicode support

•	If the database character set uses a multi-byte character encoding scheme and the default Unicode support is not enough, you can increase the Unicode support by specifying the following database server parameter:

Parameter	Value
nls_length_ semantics	char Note: The char value requires more space in the database than the default byte value.