You can install sample data within your P6 EPPM database. Sample data enables you to familiarize yourself with P6 EPPM applications by emulating business scenarios.
To install sample data:
- Open command prompt (if Windows) or terminal (if UNIX) and connect to your database using the following command:
sqlplus sys/password@dbservicename as sysdba
- Run the following commands in the same window:
noaudit policy ORA_SECURECONFIG;
noaudit policy ORA_LOGON_FAILURES;
- Close the window.
- Open a fresh command prompt (if windows) or terminal (if UNIX) and then change your directory to the location of the rundataloader.bat (.sh) file, which is on the root of the database folder by default.
- Run a statement similar to one of the following:
- Use this command if you want to load sample data into a non-production environment.
If you are using Windows
rundataloader.bat sample:pmdb_mk.zip <
admuser>@oracle:<
host>:<
port>:
<SID_name>rundataloader.bat sample:pmdb_mk.zip
<admuser>/
<admuser_password>@oracle:
<host>:
<port>/
<service_name>If you are using Unix
./rundataloader.sh sample:pmdb_mk.zip
admuser@oracle:
host:
port:
<SID_name>./rundataloader.sh sample:pmdb_mk.zip
<admuser>/
<admuser_password>@oracle:
<host>:
<port>/
<service_name> - Use this command if you do not want to load sample data. Empty data is loaded in a secure state and includes only the basic information needed to run the P6 EPPM database.
If you are using Windows
rundataloader.bat sample:pmdb_mk_empty.zip
admuser@oracle:
host:
port:
<SID_name>rundataloader.bat sample:pmdb_mk_empty.zip
<admuser>/
<admuser_password>@oracle:
<host>:
<port>/
<service_name>If you are using Unix
./rundataloader.sh sample:pmdb_mk_empty.zip <
admuser>@oracle:
host:
port:
<SID_name>./rundataloader.sh sample:pmdb_mk_empty.zip
<admuser>/
<admuser_password>@oracle:
<host>:
<port>/
<service_name>Note:
- For the connection strings above: <admuser> is the database admin user that you created, <admuser_password> is the password for the database admin user, <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), <SID_name> is the database SID (for example, PMDB), and <service_name> is the database service name (for example, orcl.us.oracle.com)
- If you use the connection string that is associated with a service name and do not include <admuser_password> in your connection string, you will experience a Java error and no data will be loaded into your environment.
- Use this command if you want to load sample data into a non-production environment.
- Do the following:
- In the "WARNING:This operation will destroy existing data in the database: Do you wish to continue? (Y or N)" prompt, enter: Y.
- In the "Password for admuser:" prompt, enter the the password of your admuser or custom administrative user that you created.
- In the "Please select a password for the P6 'admin' SuperUser account" prompt, enter or verify your superuser password.