Creating Remaining Database Objects for Oracle

To finalize the creation of your P6 EPPM database structure, you must create the remaining database objects within your database.

To create the remaining database objects:

Note: After each step, log out of the database.

Complete the following steps:
1. From the command line, run the following and provide the password when prompted: sqlplus <admuser>@<db_tns_names_entry>
2. Go to \scripts\install\PM_<release_level> and run the orpm_admuser.sql script.
  Running the orpm_admuser.sql script references the following default user names: admuser, privuser, and pxrptuser. If you created non-default user names, you must open the script in a text editor and then replace the default references before you run the script.
  
  Running the orpm_admuser.sql script references the following default tablespace names: PMDB_NDX1 and PMDB_PX_DAT1. If you created the tablespaces using non-default names, you must open the script in a text editor and then replace the default references before you run the script
Complete the following steps:
1. From the command line, run the following and provide the password when prompted: sqlplus <privuser>@<db_tns_names_entry>
2. Go to \scripts\source\PM_<release_level> and run the orpm_privuser.sql script.
  Running the orpm_privuser.sql script references the admuser name. If you created non-default user names, you must open the script in a text editor and then replace the default references before you run the script.
Complete the following steps:
1. From the command line, run the following and provide the password when prompted: sqlplus <pubuser>@<db_tns_names_entry>
2. Go to \scripts\source\PM_<release_level> and run the orpm_pubuser.sql script.
  Running the orpm_pubuser.sql script references the admuser name. If you created non-default user names, you must open the script in a text editor and then replace the default references before you run the script.
Complete the following steps:
1. From the command line, run the following and provide the password when prompted: sqlplus <pxrptuser>@<db_tns_names_entry>
2. Go to \scripts\source\PM_<release_level> and run the orpm_pxrptuser.sql script.
  Running the orpm_pxrptuser.sql script references the admuser name. If you created non-default user names, you must open the script in a text editor and then replace the default references before you run the script.
Complete the following steps:
1. From the command line, run the following and provide the password when prompted: sqlplus <bgjobuser>@<db_tns_names_entry>
2. Go to \scripts\source\PM_<release_level> and run the orpm_bguser.sql script
  Running the orpm_bguser.sql script references the admuser name. If you created non-default user names, you must open the script in a text editor and then replace the default references before you run the script.
Complete the following steps:
1. From the command line, run the following and provide the password when prompted: sqlplus <system>@<db_tns_names_entry>
2. Go to \scripts\install\PM_<release_level> and run the orpm_reset_priv.sql script.
  Running the orpm_reset_priv.sql script references the following default user names: admuser, pxrptuser, and bgjobuser. If you created non-default user names, you must open the script in a text editor and then replace the default references before you run the script.
  
  Running the orpm_reset_priv.sql script references the following default tablespace names: PMDB_DAT1, PMDB_NDX1, PMDB_LOB1, and PMDB_PX_DAT1. If you created the tablespaces using non-default names, you must open the script in a text editor and then replace the default references prior to running the script.
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 your user names and passwords.

Creating Remaining Database Objects for Oracle

Related Topics