Primavera P6 Oracle Database pre-Requisite-checks

Home/P6/Primavera P6 Oracle Database pre-Requisite-checks

Primavera P6 Oracle Database Pre-Requisite checks 

050117_0052_PrimaveraP61 Primavera P6 Oracle Database pre-Requisite-checks

 

The following options should be checked before installing or creating Primavera P6 EPPM schemas on Oracle database. I have explained each option in the upcoming section

1. Version of Oracle database supported by Oracle database

2. P6 Database Pre-requisite check

3. Mandatory P6 scripts before Create or Upgrade

 

Version of Oracle database supported by Primavera P6

 

  • Oracle provided a tested configuration of P6 on each version, and it is available on Oracle Primavera P6 EPPM documentation. Check in the tab Systems_Oracle DB and column Oracle_Database; there you will find the supported database versions. Below image is the P6 16.2 supported database versions. 

 

050117_0052_PrimaveraP62 Primavera P6 Oracle Database pre-Requisite-checks

 

  • Oracle Database Enterprise Edition is the supported edition of Primavera P6 database.

 

Note: Recently I imported the database dump of P6 16.2 in Oracle database 12.2.1 which is the latest Oracle database. After that, many of the P6 triggers and PL/SQL were not compiled. Further investigation showed me; the Oracle database 12.2.1 has not supported many REPUTIL functions present in 12.1.0.2 which is a supported P6 version. P6 schema depends on these functions

The below image shows Oracle 12.1.0 SYS.DBMS_REPUTIL functions required by P6 16.2. Those functions are not available in Oracle database 12.2.0, so long thing short install the database version present in the tested configuration

 

050117_0052_PrimaveraP63 Primavera P6 Oracle Database pre-Requisite-checks

 

2. P6 Database Pre-requisite check

 

 

  • Primavera P6 requires the following component in Oracle database; By default, Oracle Database comes with these components but make sure you have this component installed.

 

  1. Oracle Multimedia
  2. Oracle JVM
  3. Oracle XML DB (XDB)
  4. XML Developer’s Kit (XDK)

The following SQL statement will tell you the following components are installed on your database or not

 

 

 

050117_0052_PrimaveraP64 Primavera P6 Oracle Database pre-Requisite-checks

 

  • Make sure you installed Oracle database in DEDICATED mode. Establish a database connection and run the following query will tell you on what mode your database is running

 

 

 

050117_0052_PrimaveraP65 Primavera P6 Oracle Database pre-Requisite-checks

  • P6 supports AL32UTF 8, Western European (WE8MSWIN1252) character sets; Run the below query to identify the CHARACTER SET installed on Oracle database

 

 

 

050117_0052_PrimaveraP66 Primavera P6 Oracle Database pre-Requisite-checks

 

3. Mandatory P6 scripts before Create or Upgrade

 

  • If you creating a new Primavera P6 schema then run the script manual_script_before_install.sql as SYSDBA present under <P6_SOFTWARE>\p6suite\database\scripts\install\<P6_VERSION>\;

 

Note: If you plan to create P6 schema using custom DBA account other than SYSTEM then edit this script and replace the SYSTEM with the custom user account you are going to run

 

050117_0052_PrimaveraP67 Primavera P6 Oracle Database pre-Requisite-checks

 

  • If you are upgrading the existing P6 schemas than run the script manual_script_before_upgrade.sql

 

Note: If you plan to create P6 schema using custom DBA account other than SYSTEM then edit this script and replace the SYSTEM with the custom user account you are going to run

If you are using custom Primavera schema names than edit the file and update it accordingly

 

050117_0052_PrimaveraP68 Primavera P6 Oracle Database pre-Requisite-checks

 

That’s it. Please leave us a comment if you have any question

pgn Primavera P6 Oracle Database pre-Requisite-checks

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
pgn Primavera P6 Oracle Database pre-Requisite-checks
  • nilesh megha

    Hi Govind, Can you please share the step to installation of P6 EPPM with Oracle database for primavera version 16.2.2

Like us on Facebook.
Connect!