Upgrading a P6 EPPM Database with Oracle Database

If you want to manually upgrade P6 EPPM, you should upgrade your P6 EPPM database using the Primavera Database Setup Wizard.

To upgrade a P6 EPPM database using the Primavera Database Setup Wizard:

To open the Primavera Database Setup Wizard, run dbsetup.bat (with Windows) dbsetup.sh (with UNIX or Linux) at <P6_EPPM_Home>/database where <P6_EPPM_Home> is the P6 EPPM home directory that was set during installation.
Note: Click Next after each of the following steps.
On the Primavera P6 screen, complete the following:
1. Select Upgrade an existing database.
2. Select Oracle.
On the Connection Information screen, enter the connection details for an Oracle database using system credentials.
On the Create New Keystore screen, do one of the following:
- If you want to use an existing keystore, enter the password in the Existing Keystore Password field.
- If you are creating a new keystore, do the following:
1. Select Create New Keystore.
2. In the Enter Keystore Password field, enter a password for the new keystore.
3. In the Confirm Keystore Password field, enter the new password again for verification.
- If you do not want to create a keystore and you do not have an existing keystore, ensure all fields are clear.
On the Configure Oracle Tablespaces screen, enter the credentials for the administrative user. The default is admuser.
On the Upgrade Options screen, enter the credentials for the privileged, public, and background user. The defaults are privuser, pubuser, and bgjobuser.
On the Ready to Begin Upgrading Data screen, select Yes, upgrade my database.