Running the Oracle Database Upgrade Scripts for the P6 Professional Database

To upgrade your database:

1. Go to \database\scripts\install\PPM_<release level> and update the following scripts in a text editor:
   • manual_script_before_install.sql

     By default, grant options are being made to the SYSTEM schema user. The upgrade requires entry of a DBA user account, so if you use SYSTEM, no update is needed. However, if you use another DBA account for the upgrade, update the references to SYSTEM with the actual DBA account.

   • manual_script_before_upgrade.sql

     If you are not using the schema names admuser, privuser, or pxrptuser, update the references with your actual admuser, privuser, and pxrptuser names.

   • orppm_grant_privileges.sql

     If you are not using the schema names admuser, privuser, pubuser, pxrptuser, or bgjobuser, update the references with your actual admuser, privuser, pubuser, pxrptuser, and bgjobuser names.

2. If you are upgrading from P6 Professional 7.0, go to \database\scripts\install\PPM_<release level> and update the orppm_create_bguser_upgrade.sql script in a text editor. If you changed the default tablespace name (PMDB_DAT1) or the default bgjobuser name, modify the tablespace or bgjobuser name in this script.
3. From the command line, run sqlplus sys/@<DBNAME> as sysdba and enter the password when prompted.

   where <DBNAME> is the Net Service Name for your database, which can be found in your $ORACLE_HOME\NETWORK\ADMIN\TNSNAMES.ORA file.

4. Go to \database\scripts\install\PPM_<release_level> and run the following scripts:
   • manual_script_before_install.sql
   • manual_script_before_upgrade.sql
   • orppm_grant_privileges.sql
5. If you are upgrading from P6 Professional 7.0, go to \database\scripts\install\PPM_<release_level> and run the following scripts:
   • orppm_create_bguser_upgrade.sql
6. Log into the database as the admuser (or use your custom administrative user name if you created one).
7. Go to \database\scripts\common and run the or_disable_triggers.sql script.
8. Go to \database\scripts\upgrade\PPM_<release_level> and run one of the following scripts:

   ORPPM_p70sp1.sql, if upgrading from P6 Professional 7.0 or 7.0 Service Pack 1

   ORPPM_p70sp3.sql, if upgrading from P6 Professional 7.0 Service Pack 3

   ORPPM_p70sp5.sql, if upgrading from P6 Professional 7.0 Service Pack 5

   ORPPM_p81.sql, if upgrading from P6 Professional 8.1

   ORPPM_p81sp1.sql, if upgrading from P6 Professional 8.1 Patch Set 1

   ORPPM_p82.sql, if upgrading from P6 Professional 8.2

   ORPPM_p82sp1.sql, if upgrading from P6 Professional 8.2 Patch Set 1

   ORPPM_p82sp3.sql, if upgrading from P6 Professional 8.2 Patch Set 3

   ORPPM_p82sp5.sql, if upgrading from P6 Professional 8.2 Patch Set 5

   ORPPM_p83.sql, if upgrading from P6 Professional 8.3

   ORPPM_p83sp2.sql, if upgrading from P6 Professional 8.3 Patch Set 2

   ORPPM_p83sp3.sql, if upgrading from P6 Professional 8.3 Patch Set 3

   ORPPM_p83sp4.sql, if upgrading from P6 Professional 8.3 Patch Set 4

   ORPPM_p84.sql, if upgrading from P6 Professional 8.4

   ORPPM_p841.sql, if upgrading from P6 Professional 8.4 Patch Set 1

   ORPPM_p843.sql, if upgrading from P6 Professional 8.4 Patch Set 3

   ORPPM_P151.sql, if upgrading from P6 Professional 15 R1

   ORPPM_P152.sql, if upgrading from P6 Professional 15 R2

   ORPPM_P161.sql, if upgrading from P6 Professional 16 R1

   ORPPM_P162.sql if upgrading from P6 Professional 16 R2

9. Go to \database\scripts\source and run the orppm_admuser_upgrade.sql script.

   Note: If you changed the default user names, you must update the privuser and pubuser names in this script with your custom user names.

10. Log into the database as a privuser.
11. Go to \database\scripts\source\PPM_<release_level> and run the orppm_privuser.sql script.

    Caution: The orppm_privuser.sql script contains a table called PUBUSER. Do not replace it if you have to change the pubuser user name.

    Note: If you changed the default user names, you must update the admuser, privuser, and pubuser names in this script with your custom user names.

12. Go to \database and run databaselogins.bat (with Windows) or databaselogins.sh (with UNIX or Linux) to upgrade the encryption of privilege user passwords. See Private Database Credentials for P6 Professional for more information.
13. Log into the database as background job user.
14. Go to \database\source\install\PPM_<release_level> and run the orppm_bguser.sql script.
15. Log into the database as a system user.
16. Go to \database\scripts\source\PPM_<release_level> and run the orppm_reset_priv.sql script.

Legal Notices | Your Privacy Rights
Copyright © 1999, 2020

Last Published Tuesday, December 8, 2020