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

Last updated on NOVEMBER 08, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.2 and later
Primavera P6 Professional Project Management - Version 6.2 and later
All Platforms

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. 

 

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.

 

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

 

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms