Upgrading an Oracle P6 EPPM Database

Previous TopicNext TopicContents

To upgrade the P6 EPPM database:

  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 (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. Choose Upgrade an existing database.
    2. Choose Oracle as the 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, 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

Upgrading and Configuring P6 EPPM

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

Database Administration

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 Thursday, February 04, 2016

PDF Library