Creating Remaining Database Objects for Oracle

Previous TopicNext TopicContents

The scripts in this task are located in:

Install scripts: \database\scripts\install\PM_<release_level>

Source scripts: \database\scripts\source\PM_<release_level>

Upgrade scripts: \database\scripts\upgrade\PM_<release_level>

To create the remaining database objects:

  1. Log into the P6 EPPM database as admuser, or use your custom administrative user name if you created one.
  2. Execute the orpm_querylib.sql install script.
  3. Execute the orpm_ins_aux.sql install script.
  4. Execute the orpm_settings.sql install script.

    Notes:

  5. Execute the orpm_src.plb source script.
  6. Execute the orpm_secpac.sql source script.
  7. Execute the orpm_logon_trigger.sql source script.
  8. Execute the orpm_ctxindex.sql source script.
  9. Execute the orpm_dbcrudseq.sql source script.
  10. Execute the orpm_grants.sql upgrade script.
  11. Execute the orpm_synonyms.sql upgrade script.
  12. Log into the P6 EPPM database as PxRptUser, or use your custom PX reporting user name if you created one.

    Follow steps a-c if you changed the default admuser name.

    If you did not change the default admuser name, skip a-c and go to the next step.

    1. Go to \scripts\source\PM_<release_level> and edit the orpm_px_rpt_src.sql script.
    2. Replace the default admuser name with your custom admuser name.
    3. Save and close the script file.
  13. Execute the orpm_px_rpt_src.sql source script.
  14. If you used a non-default privuser name, you must do the following:
    1. Log into the databaselogins.bat (on Windows) or databaselogins.sh (on Unix) database as admuser, or use your custom administrative user name if you created one.
    2. Update the privuser name and password to match what you used when you created users in Creating Users and Tables for Oracle.
  15. Execute the orpm_database_version.sql install script as admuser, or use your custom administrative user name if you created one.

Related Topics

Creating the P6 EPPM Database Structure for Oracle

Copying the Script Files to a Local Drive for Oracle

Grant Privileges to the SYSTEM User

Creating the Database Tablespaces for Oracle

Creating Users and Tables for Oracle

Installing Sample Data and Creating Your P6 EPPM Admin Superuser Password for Oracle

Initializing Background Jobs and Creating the Background Job User



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

Last Published Wednesday, July 29, 2015

PDF Library