Installing a P6 EPPM Database with Oracle Autonomous Database

If you want to manually install P6 EPPM, you should install a P6 EPPM database using the Primavera Database Setup Wizard.

To install a P6 EPPM database using the Primavera Database Setup Wizard:

  1. To open the Primavera Database Setup Wizard, run dbsetup.bat (with Windows) dbsetup.sh (with UNIX or Linux) at <P6_EPPM_Home>/database where <P6_EPPM_Home> is the P6 EPPM home directory that was set during installation.

    Note: Click Next after each of the following steps.

  2. On the Primavera P6 screen, complete the following:
    1. Select Install a new database.
    2. Select Oracle Autonomous Database (ATP).

      Note: Create Read Only User is only intended for use with cloud installations of the application.

    3. Click Next.
  3. On the Connection Information screen:
    1. Enter the DBA user name and DBA password.
    2. Click Browse, browse to and select the wallet zip file.
    3. In the Database services list, select the service you want to use.

      Note: Oracle recommends using one of the autonomous database services with Parallel Data Manipulation Language (DML) disabled when creating the P6 EPPM schema on Oracle 19c. Parallel DML is disabled in the following services: TP, TPURGENT, and LOW. Using the MEDIUM or HIGH services with parallel DML enabled will cause dbsetup.bat to fail with an error code of either ORA-12838 or ORA-12839.

    4. Click Next.
  4. On the Create Oracle ATP Users screen in the User Name, Password, and Confirm Password fields, modify the database user names and enter the credentials for each database user.
  5. On the Configuration Options screen, complete the following:
    1. Enter a name and password for an administrative application user.
    2. Choose whether or not you want to load sample data.
    3. Choose whether or not you want to se Oracle Database Partitioning.
    4. Select your currency from the Currency list.
  6. Click Install.

Related Topics

Setting Up the P6 EPPM Database

Disabling Parallel DML for Oracle Autonomous Database on Oracle 19c

Installing a P6 EPPM Database with Oracle

Installing a P6 EPPM Database with Microsoft SQL Server

Upgrading a P6 EPPM Database with Oracle Database

Upgrading a P6 EPPM Database with Oracle Autonomous Database

Upgrading a P6 EPPM Database with Microsoft SQL Server



Last Published Friday, August 8, 2025