My Oracle Support Banner

How To Create A Project Management (P6) Database (Doc ID 911067.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.2 and later
Primavera P6 Professional Project Management - Version 6.2 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 15.1.0.0 and later
All Platforms
Unable to connect to the database. Would you like to configure the database connection now?

Goal

While it is best to have an experienced database administrator install and set up P6 applications to run on a network server, your company may not have this type of person available. Oracle Primavera provides a quick and easy Setup program for installing the necessary database components on your database server.

Oracle Primavera provides an Automatic Database Installation Method using a wizard to create a new project management and/or methodology management database and load the required data.  If you choose not to follow the automated steps, you can also manually set up the database and load the data, using a Manual Database Configuration Method with database scripts.

Note: Beginning with the P6 8.x releases, there is a difference between a PROFESSIONAL and an ENTERPRISE database.  The same utility is used to create either one, but the source (download) of the utility matters.  If you have downloaded the Professional version of the software, it will create a Professional database.  If you have downloaded the Enterprise version of the software, it will create an Enterprise database.

Using the provided database creation utility assumes that the underlying database software has already been installed (Oracle or SQL Server) with a running database instance.

 

Note:  Beginning with P6 Professional 8.4 (standalone product), the default database provided is open-source database SQLite.  Both an Oracle or SQL Server database can still be used with 8.4 and the dbsetup instructions are still applicable for those databases.  For a SQLite database, however, the creation of a database is different, and instructions are provided.

 

Note: If using the automatic database creation instructions (using dbsetup), the utility expects that:

Solution

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
Goal
Solution
 For the P6 v6.2 or P6 v6.2.1 Administrator Guide:
 For the P6 v7 Administrator Guide:
 For the P6 Release 8.0 Administrator Guides:
 For the P6 Release 8.1 Administrator Guides:
 For the P6 Release 8.2 Administrator Guides:
 For the P6 Release 8.3 Administrator Guides:
 For the P6 Release 8.4 Administrator Guides:
 For the P6 Release 15.1 Administrator Guides:
  For the P6 Release 15.2 Administrator Guides:
 For the P6 Release 16.1 Administrator Guides:
 For the P6 Release 16.2 Administrator Guides:
 For the P6 Release 17.7 (and later) Administrator Guides:
 POST-DATABASE CREATION
References

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