Upgrading an Oracle Database

The wizard runs the necessary scripts to upgrade the database structure and an upgrade program to add data required by the new version. You must upgrade your P6 Professional database.

Notes:

The upgrade will fail if you are using any Oracle version prior to 10.2.
Datafiles in the LOB tablespace (e.g., PMDB_LOB1) should be made to autoextend. The estimated sizing is not exact, and the database conversion might fail if the datafiles are a fixed size.
If your existing database uses code page WE8ISO8859P1 and you want to use the Euro symbol, you will need to convert your database to WE8MSWIN1252 using the following statement: ALTER DATABASE CHARACTER SET WE8MSWIN1252;
If you need to convert your database, be sure to first refer to the note on Oracle Support: Changing the Database Character Set (NLS_CHARACTERSET)[ID 225912.1].
If you will be using SSL protocol, refer to your Oracle Database documentation and the My Oracle Support's Knowledge Articles for configuration instructions before running the Database wizard (dbsetup).

To upgrade the database:

Perform a cold backup and a full database export.
If you are unsure how to back up your Oracle Database, do not proceed with the upgrade. Contact your database administrator, your database vendor, or Oracle Global Customer Support for assistance in backing up your database before performing the database upgrade. Also, ensure that you are familiar with the process of restoring the backup copy of the database, in case you need to do so.
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, privuser, or pxrptuser, update the references with your actual admuser, privuser, and pxrptuser names.
- 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, 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.
Go to \database\scripts\install\PPM_<release level> and run 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 run 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.
Double-click dbsetup.bat (or dbsetup.sh for Linux) in the Database folder of the P6 EPPM physical media or download to start the Database wizard.
Note: Click Next on each wizard screen to advance to the next step.
On the Connection Information, Connect to Database Server screen:
1. In the DBA User Name field, enter the DBA user name (by default, system).
2. In the DBA Password field, enter the password for the DBA user name.
3. In the Database Host Address field, enter the server machine name of IP address where the Oracle Database is installed.
4. In the Database Host Port field, enter the port number that the Oracle Database is using. The default is 1521.
5. In the Database Service Name field, enter the Oracle Service Name or SID. You can find this value in the TNSNAMES.ORA file, which you created when you or your DBA set up the Oracle client. You can also obtain the Service Name or SID by running the following query against the database as a DBA user (db_name reflects the SID and service_names reflects the service name):
  select name, value from v$parameter where name in ('db_name','service_names');
  
  Note: If you use the P6 PPM schema user (ADMUSER) in the DBA user name field, the following upgrade failure results: "Error in Run SQL Script orppm_grant_privileges.sql: DatabaseToolException (ORA-01031: insufficient privileges)".
On the Connection Information, Enter Administrative screen:
1. Enter the schema owner name for P6 PPM (by default, admuser or admprm$pm for standalone).
2. Enter password of the schema owner for P6 PPM.
On the Upgrade Options screen:
1. In the Privileged User Name field, select the privileged username (by default, privuser or privprm$pm for standalone) from the dropdown.
2. In the Privileged User Password field, enter the password for the privileged user.
3. In the Public User Name field, select the public username (by default, pubuser or pubprm$pm for standalone) from the dropdown.
4. In the Public User Password field, enter the password for the public user.
5. In the Background Job User Name field, select the background job username (by default, bgjobuser or bgjob$pm for standalone) from the dropdown.
6. In the background job user password field, enter the password for the background job user.
On the Ready to Begin Upgrading Data screen:
1. Select the Yes, upgrade my database option.
2. Click Upgrade.
On the Primavera Database Setup Wizard screen, click Next after the process has completed.
Note: If the database upgrade fails, see DatabaseSetup.log located in the user home directory (for example, C:\Documents and Settings\Administrator). Contact Oracle Global Customer Support if you need further assistance.
On the Finish screen, click Finish to exit the wizard.

Upgrading an Oracle Database

Related Topics