Upgrading the Star Database

Previous TopicNext TopicContents

Use the following procedure to upgrade to the latest version if the previous version of P6 Reporting Database included Star.

Note: The upgrade file only works if you are upgrading from R3.0 and above. If you are upgrading from any other previous release, you need to follow the instructions for upgrading to P6 Reporting Database R3.0 (see the "Upgrading the Star Database" section) before proceeding with these instructions. For instructions, go to http://docs.oracle.com/cd/E27225_01/English/Install_and_Config/Admin_PDF_Library/p6_reporting_database_install_and_config_guide.pdf.

  1. Upgrade your P6 EPPM database to a supported version (see the P6 EPPM Tested Configurations).

    Note: Before proceeding, Oracle recommends you backup your existing Star schema fully.

  2. Follow the instructions in Installing the Star Database. Refer to Configuring the Star Database for detailed instructions.

    Notes:

  3. Run the following command:

    ALTER USER STARUSER QUOTA unlimited ON STAR_HST1;

    where STARUSER is the user name and STAR_HST1 is a tablespace. If you changed the STARUSER name, change it in the command; it should match the user name for the database you are upgrading.

  4. Go to the <star_install_folder>\star\scripts and run upgradeStar.bat (or upgradeStar.sh when upgrading from a non-Windows system).

    Once this finishes, your Star Schema will be P6 Reporting Database 3.2.

Related Topics

Upgrading to the Latest Version

Upgrading the P6 Analytics Catalog

Upgrading the Repository Definition File (.rpd)



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

Last Published Friday, January 31, 2014