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:
- 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.
- On the Primavera P6 screen, complete the following:
- Select Install a new database.
- Select Oracle Autonomous Database (ATP).
Note: Create Read Only User is only intended for use with cloud installations of the application.
- Click Next.
- On the Connection Information screen:
- Enter the DBA user name and DBA password.
- Click Browse, browse to and select the wallet zip file.
- 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.
- Click Next.
- 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.
- On the Configuration Options screen, complete the following:
- Enter a name and password for an administrative application user.
- Choose whether or not you want to load sample data.
- Choose whether or not you want to se Oracle Database Partitioning.
- Select your currency from the Currency list.
- 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