Loading Application Data for Oracle

To continue installing the Oracle Database and load application data:

  1. On the Primavera Database Setup Wizard screen, click Next.
  2. On the Create Oracle Users screen, specify the Oracle Database administrative, privileged, public, and background user names and passwords.

    Caution: Use a unique name for all your user names; do not use duplicate names. Repeating user names will cause conflicts.

    Notes:

    • P6 EPPM does not support passwords with multi-byte characters.
    • Oracle recommends using strong passwords. Strong passwords in P6 EPPM contain between 8 and 20 characters and at least one numeric and one alpha character. To further strengthen the password, use a mixture of upper and lower case letters.
    • Do not use special characters in the database name, privileged user, or public user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~
  3. On the Configuration Options screen:
    1. In the Application User section, enter the P6 Professional application administrative user name and password. By default, the application administrative user will be granted Admin Superuser access rights.

      Note: Oracle recommends using strong passwords. Strong passwords in P6 EPPM contain between 8 and 20 characters and at least one numeric and one alpha character. To further strengthen the password, use a mixture of upper and lower case letters.

    2. Select the Load sample data option if you want to include sample project data in a non-production database. If you do not select the Load sample data option, empty data is loaded in a secure state and includes only the most basic information needed to run the P6 Professional database.

      Caution: You must choose the base currency if you do not want the database to use US dollars ($) as the base currency. You cannot change the base currency once projects are in progress.

    3. If you want to use a currency other than US Dollars as the base currency for the database, select a different base currency in the Currency field.
    4. Click Install to start the process of loading the database tables with application data.
  4. On the Finish screen, click Finish to exit the wizard.

    Notes:

    • If the database creation 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.
    • When the installation successfully completes, delete the installation log: DatabaseSetup.log. You can find this under C:\Documents and Settings. The folder name will depend on what you setup during installation.

Once the application data is installed you can begin to install and configure the client module.

See Database Administration for information on configuring database settings to optimize performance.

Related Topics

Automatically Installing an Oracle Database and Loading Application Data

Creating an Oracle Database

Base Currency



Legal Notices | Your Privacy Rights
Copyright © 1999, 2020

Last Published Thursday, March 18, 2021