PPM Database Requirements

This section provides the details on PPM database requirements.

Oracle Database

The following Oracle database versions are supported on all PPM Server platforms:

• Oracle 12.1.0.1, Standard and Enterprise Edition (RAC and Non-RAC)

• Oracle 12.1.0.2, Standard and Enterprise Edition (RAC and Non-RAC)

• Oracle 12.2.0.1, Standard and Enterprise Edition (RAC and Non-RAC)
• Oracle 18.x, Standard and Enterprise Edition (RAC and Non-RAC)
• Oracle 19c, Standard and Enterprise Edition (RAC and Non-RAC)
• Oracle 19.3, Standard and Enterprise Edition (RAC and Non-RAC)

Note:

• For the production environment only, PPM can run on Oracle 12c with Container Database (CDB) or Pluggable Database (PDB) enabled.
• Because Oracle Enterprise DB Server is not supported on VMware, PPM does not work with Oracle Enterprise DB Server on VMware.

• There is a known issue in Oracle 12.1.0.2. If you are using this version, you should permanently alter the session parameter "optimizer_adaptive_features".

  To do so:

  1. Log on to PPM database schema as PPM_SCHEMA.

  2. Run the commands as follows:

     create trigger PPM_LOGON_ORACLE_18311854
     after logon on <PPM_SCHEMA_NAME>.schema
     begin
     execute immediate 'alter session set "optimizer_adaptive_features" = false';
     end;

For sizing information for database-based DMS solutions, see Database Sizing.

For details about server requirements, see the Oracle documentation specific to your operating system in the Oracle Database Documentation Library (https://docs.oracle.com/en/database/oracle/oracle-database/index.html).

For information on periodic database maintenance tasks, see the Oracle Database Administrator's Guide.

Oracle Database Character Sets

The table below lists the database character sets supported for English-language deployments of this version of PPM.

Code	Description
US7ASCII	ASCII 7-bit U.S. America
WE8ISO8859P1	ISO 8859-1 Western Europe
WE8ISO8859P9	ISO 8859-9
WE8ISO8859P15	ISO 8859-15
WE8MSWIN1252	Microsoft Windows code page 1252 8-bit Western Europe Note: Supported for legacy reasons. Do not use for new PPM installations.
UTF8	Unicode 3.0 UTF-8
AL32UTF8	Unicode 3.0 UTF-8 Note: For new PPM installations, make sure you ALWAYS use AL32UTF8.

You should also specify:

• AL32UTF8 for NLS_CHARACTERSET

• AL16UTF16 for NLS_NCHAR_CHARACTERSET

Note: We strongly recommend the use of AL32UTF8 for new installations.

PostgreSQL Database

The following PostgreSQL database version is supported on the PPM server:

PostgreSQLVersion	PPM Version
	10.0-10.0.3	10.0.4	2023
PostgreSQL 11.0
PostgreSQL 13.8

Note:

• You must also install the orafce extension version 3_24_4. For instructions, see https://github.com/orafce/orafce.

• We do not offer the utility of database migration to PostgreSQL.

• For security considerations, PostgreSQL 11.0 is not supported in PPM 10.0.4 and later versions.