Installing a P6 EPPM Database with Oracle

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.

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

3. On the Connection Information screen, enter the connection details for an Oracle database using system credentials.
4. On the Create New Keystore screen, complete one of the following:
   • If you want to use an existing keystore, enter the password in the Existing Keystore Password field.
   • If you are creating a new keystore, do the following:
   1. Select Create New Keystore.
   2. In the Enter Keystore Password field, enter a password for the new keystore.
   3. In the Confirm Keystore Password field, enter the new password again for verification.
   • If you do not want to create a keystore and you do not have an existing keystore, ensure all fields are clear.
5. On the Configure Oracle Tablespaces screen, enter a name for each tablespace and modify the tablespace size (M) if necessary.
6. On the Specify Oracle Tablespace Location screen, enter the location at which you want to create each tablespace and then click Create.
7. On the Create Oracle Users screen in the User Name, Password, and Confirm Password fields, modify the database user names and enter the credentials for each database user.
8. 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. Select your currency from the Currency list.
   4. If synchronizing P6 EPPM and Oracle Primavera Cloud select Use Oracle Database Partitioning Option(separately licensed) to improve synchronization performance.
   5. Click Install.

Related Topics

Setting Up the P6 EPPM Database

Installing a P6 EPPM Database with Microsoft SQL Server

Upgrading a P6 EPPM Database with Oracle Database

Upgrading a P6 EPPM Database with Microsoft SQL Server

Legal Notices | Your Privacy Rights
Copyright © 1999, 2023

Last Published Thursday, January 12, 2023