Creating Remaining Database Objects for Oracle

Previous TopicNext TopicContents

To create the remaining database objects:

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

  1. Execute the following steps:
    1. From the command line, execute: sqlplus <admuser>/password@<db_tns_names_entry>
    2. Go to \scripts\install\PM_<release_level> and execute 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

  2. Execute the following steps:
    1. From the command line, execute: sqlplus <privuser>/password@<db_tns_names_entry>
    2. Go to \scripts\source\PM_<release_level> and execute 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.

  3. Execute the following steps:
    1. From the command line, execute: sqlplus <pubuser>/password@<db_tns_names_entry>
    2. Go to \scripts\source\PM_<release_level> and execute 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.

  4. Execute the following steps:
    1. From the command line, execute: sqlplus <pxrptuser>/password@<db_tns_names_entry>
    2. Go to \scripts\source\PM_<release_level> and execute 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.

  5. Execute the following steps:
    1. From the command line, execute: sqlplus <bgjobuser>/password@<db_tns_names_entry>
    2. Go to \scripts\source\PM_<release_level> and execute 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.

  6. Execute the following steps:
    1. From the command line, execute: sqlplus <system>/password@<db_tns_names_entry>
    2. Go to \scripts\install\PM_<release_level> and execute 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.

  7. 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.

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



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

Last Published Thursday, February 04, 2016

PDF Library