My Oracle Support Banner

Database Options Supported When Primavera P6 is Configured For an Oracle Database (Doc ID 1192664.1)

Last updated on DECEMBER 06, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.0 and later
Information in this document applies to any platform.

Details

Oracle offers a wide range of options to extend the power of an Oracle Database to meet specific requirements in the areas of performance and availability, security and compliance, data warehousing, and manageability.

Starting with Release 8.0, Oracle | Primavera P6 has been tested and supports the use of the following database options when configured to use an Oracle Database:

The following database options, which have been supported in previous P6 releases, will extend to the Oracle | Primavera P6 Release 8.0:

Actions

Review the following detailed information for Oracle Database options that have been tested and supported, starting with the Oracle | Primavera P6 version 8.0 release:

Oracle Data Guard

Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guard maintains these standby databases as transactionally consistent copies of the production database. Then, if the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch any standby database to the production role, minimizing the downtime associated with the outage. Data Guard can be used with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability.  For more information on Oracle Data Guard, click here.

For P6 EPPM Web Products
For the web products which use JDBC connection, the format of the JDBC URL should be as follows:
jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =(PROTOCOL = TCP) (HOST = <primary_host_name>) (PORT = <port>)) (ADDRESS =(PROTOCOL = TCP) (HOST =<standby_host_name>) (PORT = <port>)))(CONNECT_DATA = (SERVICE_NAME = <service_name>)))

Instruction for configuring the P6 EPPM modules can be modeled after the knowledge base document found under the "Oracle Real Application Clusters (Oracle RAC)" section below.

For P6 Professional
For P6 Professional to utilize Data Guard, the Oracle Client P6 Professional is using should be configured with the Local Naming Method (TNSNAMES) and the TNSNAMES.ora file should be configured with an alias that uses the following format:
ALIASNAME =
  (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = primary.hostname)(PORT = primary.port))
       (ADDRESS = (PROTOCOL = TCP)(HOST = standby.hostname)(PORT = standby.port))
       (CONNECT_DATA =
           (SERVICE_NAME = database_servicename)
       )
  )

P6 Professional is then configured to utilize the ALIASNAME referenced in the TNSNAMES.ora file for connection to the Oracle Database. For instruction to configure a P6 Professional database connection, refer to the following - How To Create Or Modify A Database Alias For Project Management (Also Known As P6 Professional or Optional Client), Methodology Management, Job Services or Contractor (Doc ID 899068.1).

Oracle Active Data Guard

Oracle Active Data Guard, with an Oracle Database 11g Enterprise Edition, enhances quality of service by offloading resource-intensive activities from a production database to one or more synchronized standby databases. Oracle Active Data Guard enables read-only access to a physical standby database for queries, sorting, reporting, Web-based access, and so on, while continuously applying changes received from the production database. Oracle Active Data Guard also enables the use of fast incremental backups when offloading backups to a standby database and can provide additional benefits of high availability and disaster protection against planned or unplanned outages at the production site.  For more information on Oracle Active Data Guard, click here.
For P6 EPPM Web Products
For the web products which use JDBC connection, the format of the JDBC URL should be as follows:
jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =(PROTOCOL = TCP) (HOST = <primary_host_name>) (PORT = <port>)) (ADDRESS =(PROTOCOL = TCP) (HOST =<standby_host_name>) (PORT = <port>)))(CONNECT_DATA = (SERVICE_NAME = <service_name>)))

Instruction for configuring the P6 EPPM modules can be modeled after the knowledge base document found under the "Oracle Real Application Clusters (Oracle RAC)" section below.

For P6 Professional
For P6 Professional to utilize Data Guard, the Oracle Client P6 Professional is using should be configured with the Local Naming Method (TNSNAMES) and the TNSNAMES.ora file should be configured with an alias that uses the following format:
ALIASNAME =
  (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = primary.hostname)(PORT = primary.port))
       (ADDRESS = (PROTOCOL = TCP)(HOST = standby.hostname)(PORT = standby.port))
       (CONNECT_DATA =
           (SERVICE_NAME = database_servicename)
       )
  )

P6 Professional is then configured to utilize the ALIASNAME referenced in the TNSNAMES.ora file for connection to the Oracle Database. For instruction to configure a P6 Professional database connection, refer to the following - How To Create Or Modify A Database Alias For Project Management (Also Known As P6 Professional or Optional Client), Methodology Management, Job Services or Contractor (Doc ID 899068.1).

Oracle Advanced Compression

Oracle Advanced Compression with an Oracle Database helps manage more data in a cost-effective manner. With data volumes, on average, tripling every two years, Oracle Advanced Compression delivers compression rates of 2-4x across all types of data and applications. Storage savings from compression will cascade throughout the data center, reducing network traffic and data backups as well. And by reading fewer blocks off disk, Oracle Advanced Compression also improves query performance.  For more information on Oracle Advanced Compression, click here.

Oracle Advanced Compression is a database option configured against the Oracle database itself. There is no specific configuration required for the P6 modules to use Advanced Compression.

Oracle Real Application Clusters (Oracle RAC)

Oracle Real Application Clusters (Oracle RAC), with an Oracle Database, enables a single database to run across a cluster of servers, providing unbeatable fault tolerance, performance, and scalability with no application changes necessary.  For more information on Oracle Real Application Clusters (Oracle RAC), click here.

For instruction to configure Primavera P6 modules with Oracle RAC, please refer to the following document:  <Document 1192650.1> "Configuring Primavera P6 Modules for Use With Oracle Database Real Application Clusters (RAC)"

Transparent Data Encryption (TDE)

Oracle Advanced Security Transparent Data Encryption (TDE) provides the ability to encrypt sensitive application data on storage media completely transparent to the application itself. TDE addresses encryption requirements associated with public and private privacy and security mandates such as PCI and California SB1386. Oracle Advanced Security TDE tablespace encryption was introduced with Oracle Database 11gR1, and is supported with the P6 EPPM schema.

For more information regarding best practices of TDE, refer to the following white paper:  Oracle Advanced Security Transparent Data Encryption Best Practices

For an Oracle Database Security data sheet regarding TDE for P6 EPPM, refer to the following:  ORACLE DATABASE SECURITY FOR PRIMAVERA P6 EPPM 8

For steps to configure TDE for the P6 EPPM schema, refer to the following knowledge base document:  Oracle Advanced Security TDE “OneCommand” for Oracle Primavera P6 EPPM 8.2+ (Doc ID 1584095.1)

Oracle Partitioning

A key requirement of high performance, high availability database environments, partitioning splits tables and indexes into smaller, more manageable components.  Oracle Database offers the widest choice of partitioning methods available, including interval, reference, list, and range. Additionally, it provides composite partitions of two methods, such as order date (range) and region (list) or region (list) and customer type (list).  For more information on Partitioning, click here.

For partitioning availability with a P6 Project Management Oracle Database, please refer to the following document:  <Document 912820.1> "Table Partitioning Support For P6 Project Management Oracle Schema (Database)"

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
Actions
 Oracle Data Guard
 Oracle Active Data Guard
 Oracle Advanced Compression
 Oracle Real Application Clusters (Oracle RAC)
 Transparent Data Encryption (TDE)
 Oracle Partitioning
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.