To upgrade the P6 EPPM Oracle Database:
Note: Make a backup copy of any files you will modify before you edit them.
\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.
\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 execute 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>\
orpm_grant_privileges.sqlIf you are not using the schema names admuser, privuser, bgjobuser, pubuser, and pxrptuser update the references with your actual admuser, privuser, bgjobuser, pubuser, and pxrptuser names.
Note: If you are upgrading from 8.1 or later, you can skip steps d, e, f, and g.
\scripts\install\PM_
<release_level>\
orpm_create_bguser_upgrade.sql script.Modify the tablespace or bgjobuser name in this script if you changed the default tablespace name (PMDB_DAT1) or the default bgjobuser name.
\scripts\install\PM_
<release_level>\
orpm_grantpriv_bguser_upgrade.sqlIf you are not using the schema name bgjobuser, update the references with your actual bgjobuser name.
\scripts\install\PM_
<release_level>\
orpm_init_px.sqlModify the tablespace name in this script if you changed the default tablespace name (PMDB_PX_DAT1).
\scripts\install\PM_
<release_level>\
orpm_create_plus_users.sqlIf you want to create a user without a default name, you need to update pxrptuser with your actual pxrptuser name.
If you are using a custom admuser name, you need to modify the reference to admuser with your actual admuser name.
Notes: Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
\scripts\install\PM_
<release_level> and execute the manual_script_before_upgrade.sql script.\scripts\install\PM_
<release_level> and execute the manual_script_before_install.sql script.Note: If you are upgrading from 8.1 or later, you can skip steps d, e, f, and g and then continue to step h.
\scripts\install\PM_
<release_level> and execute orpm_create_bguser_upgrade.sql script.\scripts\install\PM_
<release_level> and execute orpm_grantpriv_bguser_upgrade.sql script.\scripts\install\PM_
<release_level> and execute orpm_init_px.sql script.\scripts\install\PM_
<release_level> and execute orpm_create_plus_users.sql script.\scripts\install\PM_
<release_level>, update the user in the script, and then execute the orpm_grant_privileges.sql script.\scripts\common\PM_
<release_level> and execute the or_disable_triggers.sql script.\scripts\upgrade\PM_
<release_level> and execute one of the following scripts:ORPM_p70sp1.sql, if upgrading from P6 version 7.0, 7.0 service pack 1, or 7.0 service pack 2
ORPM_p7.0sp3.sql, if upgrading from P6 version 7.0 service pack 3
ORPM_p70sp5.sql if upgrading from P6 version 7.0 service pack 5
ORPM_p80.sql if upgrading from P6 version 8.0
ORPM_p81.sql if upgrading from P6 version 8.1
ORPM_p81sp3.sql if upgrading from P6 version 8.1 service pack 3
ORPM_p82.sql if upgrading from P6 version 8.2
ORPM_p82sp2.sql if upgrading from P6 version 8.2 service pack 2
ORPM_p82sp2f10.sql if upgrading from P6 version 8.2 patch set 2 Hotfix 10
ORPM_p83.sql if upgrading from P6 version 8.3
ORPM_p832.sql if upgrading from P6 version 8.3 or 8.3 service pack 2
ORPM_p833.sql if upgrading from P6 version 8.3 or 8.3 service pack 3
ORPM_p834.sql if upgrading from P6 version 8.3 or 8.3 service pack 4
ORPM_p835.sql if upgrading from P6 version 8.3 or 8.3 service pack 5
ORPM_p84.sql if upgrading from P6 version 8.4 or 8.4 patch set 1
ORPM_p841.sql if upgrading from P6 version 8.4 or 8.4 patch set 1
ORPM_p843.sql if upgrading from P6 version 8.4 or 8.4 patch set 3
Notes:
\scripts\source\PM_
<release_level> and execute the orpm_admuser_upgrade.sql script.\scripts\source\PM_
<release_level> and execute the orpm_privuser.sql script.\scripts\source\PM_
<release_level> and execute the orpm_pxrptuser.sql script.Note: If you changed the system username to a custom dba user in step 3b, you need to execute orpm_reset_priv.sql as the custom dba user instead of the default system user.
\scripts\source\PM_
<release_level> and execute the orpm_reset_priv.sql script.
Legal Notices
Copyright © 1999, 2016,
Oracle and/or its affiliates. All rights reserved.
Last Published Thursday, February 04, 2016