Installing Sample Data and Creating Your P6 Professional Admin Superuser Password
Manual Oracle Database Configuration > Manual Oracle Database Configuration Overview > Creating the Database Structure for Oracle and Loading Application Data > Creating the P6 Professional Database Structure
To install sample data:
- Open a command prompt and change your directory to the location of the rundataloader.bat file, which is on the root of the database folder by default.
- Do one of the following:
- If you want to load sample data into a non-production environment, run the following command:
For EPPM:
rundataloader.bat sample:pmdb_mk.zip <admuser>@oracle:<host>:<port>:<instance>
For P6 Professional:
rundataloader.bat sample:ppmdb_mk.zip <admuser>@oracle:<host>:<port>:<instance>
where
<admuser>
is the system admin user you created,<host>
is the server machine name or IP address where Oracle is installed,<port>
is the port number that Oracle is using (the default is 1521), and<instance>
is the database name or SID (for example, PMDB). - If you do not want to load sample data, run the following command:
For EPPM:
rundataloader.bat sample:pmdb_mk_empty.zip <admuser>@oracle:<host>:<port>:<instance>
For P6 Professional:
rundataloader.bat sample:ppmdb_mk_empty.zip <admuser>@oracle:<host>:<port>:<instance>
where
<admuser>
is the system admin user you created,<host>
is the server machine name or IP address where Oracle is installed,<port>
is the port number that Oracle is using (the default is 1521), and<instance>
is the database name or SID (for example, PMDB).Note: This command loads empty data is loaded in a secure state with only the basic information needed to run the P6 Professional database.
- If you want to load sample data into a non-production environment, run the following command:
- At the Please select a password for the P6 'admin' SuperUser account prompt, enter or verify your superuser password.
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 Remaining P6 Professional Database Objects
Last Published Tuesday, December 12, 2023