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 one of the following server types:
      • Oracle
      • Microsoft SQL Server
  4. On the Connection Information dialog box, enter the following information to connect to the database:
    1. In the DBA user name field, log on to the database as a DBA.
    2. In the DBA password field, type the password associated with the user name that you entered.
    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 Oracle Service Name. It can be found in the TNSNAMES.ORA file, which was created when you or your DBA set up the Oracle client.
  5. On the Connection Information dialog box, enter the following information:
    1. In the Administrative user name field, log on to the database as an administrative user, such as admuser. The user name must have administrative privileges and must be the owner of the application tables. The database must also have the Oracle compatible parameter set to 10.2 or greater.
    2. In the Administrative password field, type the password associated with the user name you entered.
  6. On the Upgrade Options dialog box:
    1. Select your Privileged user name for the database (for example, 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 (for example, 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 (for example, bjobuser).
    6. In the Background job user password field, type the password associated with the user name that you entered.
  7. On the Upgrade Option dialog box:
    1. Select your PX Reporting User name for the database (for example, pxrptuser).
    2. In the Px Reporting User Password field, type the password associated with the user name that you entered.
  8. 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.

  9. 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.

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

    Your database is now ready to use with P6 EPPM.

Related Topics

About Automatically Upgrading and Configuring P6 EPPM

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

Legal Notices



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Monday, October 24, 2016