Running Upgrade Scripts with an Oracle XE Database

If you are upgrading from a previous version that uses an Oracle XE database, you must run scripts before upgrading:

Download and extract the media zip file locally to the client.
Go to \database\scripts\install\PPM_<release level> and update the following scripts in a text editor:
- manual_script_before_upgrade.sql
  If you are not using the schema names admuser or privuser, update the references with your actual admuser and privuser names. Default schema names are admprm$pm and privprm$pm.
- 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.
From the command line, execute sqlplus sys/<password>@<DBNAME> as sysdba
where <password> is the password for your sysuser and <DBNAME> is the Net Service Name for your database, which can be found in your $ORACLE_HOME\NETWORK\ADMIN\TNSNAMES.ORA file.
Go to \database\scripts\install\PPM_<release level> and execute manual_script_before_upgrade.sql.
For example, at the SQL prompt, enter @C:\P6_Professional_Database\database\scripts\install\PPM_15_01_00\manual_script_before_upgrade.sql.
Go to \database\scripts\install\PPM_<release level> and execute manual_script_before_install.sql.
For example, at the SQL prompt, enter @C:\P6_Professional_Database\database\scripts\install\PPM_15_01_00\manual_script_before_install.sql.