Configuring the Oracle Database Server

The following is an overview of the steps required to configure the Oracle Database for use with Unifier. For more information and specific instructions, refer to your Oracle documentation.

Note: For the full list of system requirements, applications, and application version levels, refer to Primavera Unifier Tested Configurations in the Unifier Documentation Library.

Configure an Oracle Database for Unifier as follows:

  1. Create an instance for the database.

    Note: You can accept the defaults except for the following: Ensure to set encoding to Unicode (UTF-8).

  2. Create a user account on the newly created database.

    For successful Primavera Unifier/uDesigner installation, make sure ample free space of at least 2GB is available for the default tablespace where the new user will be located.

  3. Grant the new user with connect, resource, create view, and create table privileges.

    Note: This information will be used later for setting database information in the Database tab of the Unifier Configurator.

    For example:

    create user unifier identified by unifier

    temporary tablespace temp

    default tablespace users;

    grant connect, resource, create view, create table to unifier;

    Notes:

    • (Required) Ensure that maximum open cursor in Oracle DB is set to 1000, or above.
    • Ensure that Database user quota is set to unlimited on tablespace users.

Implementing Transparent Data Encryption (Optional)

Transparent Data Encryption (TDE) is an Oracle Advanced Security feature that is used for Oracle Database encryption. TDE provides strong protection from malicious access to database files by encrypting data before it is written to storage, decrypting data when being read from storage, and offering built-in key management.

For more information about TDE, refer to the Oracle Advanced Security: http://www.oracle.com/technetwork/database/options/advanced-security/overview/index.html.

Explain Plan

In order to be able to use the Explain Plan option for the Data Views, you must ensure that you the following configurations (permissions) are in place:


Last Published Tuesday, February 20, 2024