Creating Remaining P6 Professional Database Objects

To create the remaining database objects:

1. Log in to the Oracle database as admuser (or use your custom administrative user name if you created one).
2. If you changed the default PMDB_NDX1 tablespace name and privuser user name, go to \database\scripts\install\PPM_<release_level> and update the orppm_admuser.sql script with your custom names.
3. Execute orppm_admuser.sql.
4. Log in to the Oracle database as privuser (or use your custom privileged user name if you created one).
5. If you changed the default admuser user name, go to \database\scripts\source\PPM_<release_level> and update the orppm_privuser.sql script with your custom name.
6. Execute orppm_privuser.sql.
7. Log in to the Oracle database as pubuser (or use your custom public user name if you created one).
8. If you changed the default admuser user name, go to \database\scripts\source\PPM_<release_level> and update the orppm_pubuser.sql script with your custom name.
9. Execute orppm_pubuser.sql.
10. Log in to the Oracle database as bgjobuser (or use your custom background job user name if you created one).
11. If you changed the default admuser user name, go to \database\scripts\source\PPM_<release_level> and update the orppm_bguser.sql script with your custom name.
12. Execute orppm_bguser.sql.
13. Log in to the Oracle database as SYSTEM or your custom DBA user.
14. If you changed any of the following, go to \database\scripts\source\PPM_<release_level> and update the orppm_reset_priv.sql script with your custom names:
    • Tablespace Names
      • PMDB_DAT1
      • PMDB_NDX1
      • PMDB_LOB1
    • User Names
      • admuser
      • bgjobuser
15. Execute orppm_reset_priv.sql.

Related Topics

Creating the P6 Professional Database Structure

Copying the Script Files to a Local Drive

Grant Privileges to the SYSTEM User

Creating the Database Tablespaces

Creating Users and Tables

Installing Sample Data and Creating Your P6 Professional Admin Superuser Password