Before upgrading P6 EPPM on an Oracle database, run the following scripts:
- Navigate to the following locations, open the designated scripts in a text editor, and modify the schema user references to match your actual schema user names:
\scripts\install\PM_<release level>\manual_script_before_install.sqlYou must apply grant options to the SYSTEM schema user or a custom user associated with the Oracle DBA role. If you plan to use a custom schema user, other than SYSTEM, to complete steps which require a DBA role, then you must update the references to SYSTEM in the script with the new custom schema user associated with the DBA role.
\scripts\install\PM_<release level>\manual_script_before_upgrade.sqlIf you are not using the schema names admuser or pxrptuser, update the references with your actual admuser and pxrptuser names.
- Complete the following steps:
- From the command line, run the following and provide the password when prompted:
sqlplus sys@<db_tns_names_entry> as sysdba - Go to \scripts\install\PM_<release_level> and run the manual_script_before_install.sql script.
- From the command line, run the following and provide the password when prompted:
sqlplus system@<db_tns_names_entry> - Go to \scripts\install\PM_<release_level> and run the manual_script_before_upgrade.sql script.
- From the command line, run the following and provide the password when prompted: