Creating the Database

It is strongly recommended that you use DBCA to create the database.

Note: You must have Oracle Database Server Enterprise Edition installed on your machine in order to create the database.

Linux/UNIX

Create the database using the Database Configuration Assistant (DBCA).

Windows

You should be logged in as a user who is a member of the local ORA_DBA group on that server. The ORA_DBA group should have “administrator” privileges assigned to it.

Make sure to set character set for database as AL32UTF8.

Refer to Creating the Database for steps to create the database on either Linux/UNIX or Windows.

Extended Datatypes

Some of the Oracle Utilities Application Framework application table varchar2 fields require byte size beyond 4000 bytes to store data for new application requirements. To support this requirement the Oracle Utilities Application Framework database should use the Extended Data Types - Oracle database 12c feature (EXTENDED - the 32767 byte limit introduced in Oracle Database 12c applies).

Enable the Extended Data Types by setting DB parameter, max_string_size = EXTENDED.

Follow the instructions provided in Oracle Database online documentation for including this change in your database.

Important! This change in your database environment is mandatory. If not included it will lead to errors during the V4.5.0.0.0 upgrade.