Oracle

PPM supports the main versions Oracle 11g, 12c, 18, and 19.

The default database of an Oracle 18 or 19 installation is a container data base, which is not supported by PPM by default.

To access the Oracle database, PPM uses the JDBC Thin Interface (type 4). Enter the access parameters for the Oracle database in the URL key of the client-specific Database_settings.properties configuration file.

If Oracle Containers were used, the syntax is as follows:

jdbc:oracle:thin:@//<host>:<port>/<database service name>

Example

URL= jdbc:oracle:thin:@//pcoracle:1521/PPMPDB1

You must enter this type of URL manually in the Database settings dialog in PPM Customizing Toolkit.