You must create specific users and tables within your Oracle database to use it with your P6 EPPM installation.
Note: The scripts in this task are located in:
\database\scripts\install\PM_<release_level>
To create users and tables:
- Complete the following steps:
- From the command line, run the following and provide the password when prompted:
sqlplus system@<db_tns_names_entry>
- Run the orpm_create_users.sql script.
Running the orpm_create_users.sql script automatically creates database user names: admuser, privuser, pubuser, pxrptuser, and bgjobuser. If you want to create non-default usernames, you must first open the script in a text editor and then replace the default references before you run the script.
Running the orpm_create_users.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 first open the script in a text editor and replace the default references before you run the script.
Note: Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
- Run the orpm_grant_privileges.sql script.
Running the orpm_grant_privileges.sql script references the following database user names: admuser, privuser, pubuser, pxrptuser, and bgjobuser. If you want to create non-default usernames, you must first open the script in a text editor and then replace the default references prior to running the script.
- From the command line, run the following and provide the password when prompted:
- Complete the following steps:
- From the command line, run the following and provide the password when prompted:
sqlplus <admuser>@<db_tns_names_entry>
- Run the orpm_tables.sql script.
Running the orpm_tables.sql script references the following default user names: privuser, pubuser, and pxrptuser. If you created non-default user names, you must first open the script in a text editor and replace the default references before you run the script.
Running the orpm_tables.sql script references the following default tablespace names: PMDB_DAT1, PMDB_LOB1, and PMDB_PX_DAT1. If you created the tablespaces using non-default names, you must first open the script in a text editor and replace the default references before you run the script.
- From the command line, run the following and provide the password when prompted: