Upgrading an Oracle P6 EPPM Database

When upgrading the P6 EPPM database for a new version of P6 EPPM, you can either use the P6 EPPM Configuration Wizard that is delivered with the latest media pack or you can use dbsetup.

The P6 EPPM Configuration Wizard streamlines the process of upgrading the P6 EPPM with your WebLogic server and additional components. The P6 EPPM Configuration Wizard uses dbsetup to upgrade your database. For more information about using the P6 EPPM Configuration Wizard, refer to About the P6 EPPM Configuration Wizard.

If you only want to upgrade your database, you can use dbsetup.

To upgrade the P6 EPPM database using dbsetup:

1. Perform a cold backup and a full database export.

   If you are unsure how to back up your Oracle database, do not proceed with the upgrade. Contact your database administrator, your database vendor, or Oracle Global Customer Support for assistance in backing up your database before performing the database upgrade. Also, ensure that you are familiar with the process of restoring the backup copy of the database in case you need to do so.

2. Double-click dbsetup.bat (for Windows) dbsetup.sh (for Linux) in the Database folder of the P6 EPPM physical media or download to start the Database wizard.

   Note: Click Next on each wizard screen to advance to the next step.

3. On the Primavera P6 dialog box:
   1. Select Upgrade an existing database.
   2. Select Oracle for the following server type.
4. On the Connection Information dialog box, enter the following information to connect to the database:
   1. In the DBA user name field, enter the database administrator user name. The default is System.
   2. In the DBA password field, enter the password for the DBA user.
   3. In the Database host address field, enter the server machine name or IP address where Oracle is installed.
   4. In the Database host port field, enter the port number that Oracle is using. The default is 1521.
   5. In the Database name field, enter the Service Name or SID, depending on your configuration.
   6. Select the Service Name or SID option, depending on the information you entered in the Database Name field.
   7. In the Keystore Folder field, enter the full path to the keystore file.
5. On the Create New Keystore dialog box, complete the following information:
   1. If a keystore exists, enter the Existing Keystore Password.
   2. If creating a new keystore, select Create New Keystore and enter the keystore credentials.

      Notes:

      • P6 EPPM databases do not require you to use a keystore.
      • If there is no existing keystore and you are not creating one, ensure all fields are clear and click Next.
6. On the Connection Information dialog box, enter the following information:
   1. In the Administrative user name field, enter your administrative user name. The default is admuser.
   2. In the Administrative password field, type the password associated with the user name you entered.
7. On the Upgrade Options dialog box:
   1. Select your Privileged user name for the database. The default is privuser.
   2. In the Privileged user password field, type the password associated with the user name that you entered.
   3. Select your Public user name for the database. The default is pubuser.
   4. In the Public user password field, type the password associated with the user name that you entered.
   5. Select your Background job user name for the database. The default is bjobuser.
   6. In the Background job user password field, type the password associated with the user name that you entered.
8. On the Upgrade Option dialog box:
   1. Select your PX Reporting User name for the database. The default is, pxrptuser.
   2. In the Px Reporting User Password field, type the password associated with the user name that you entered.
9. On the Ready to Begin Upgrading Data dialog box:
   1. Choose Yes, upgrade my database.
   2. Click Upgrade.

   The upgrade process could take several minutes, depending on its size.

10. On the Primavera Database Setup Wizard dialog box, click Next after the process has completed.

    Note: If the database upgrade fails, see PrimaveraDatabaseSetup.log located in the user home directory (for example, C:\Documents and Settings\Administrator). Contact Oracle Global Customer Support if you need further assistance.

11. On the Finish dialog box, click Finish to exit the wizard.

    Your database is now ready to use with P6 EPPM.

Related Topics

About This Guide

Automatic Database Upgrade Considerations and Prerequisites

Prerequisites for P6 EPPM Configuration

About the P6 EPPM Installation Wizard

About the P6 EPPM Configuration Wizard

Post-Upgrade Procedures

Where To Go From Here - Post Configuration Wizard

Copyright

Legal Notices | Your Privacy Rights
Copyright © 1999, 2021

Last Published Tuesday, December 7, 2021