How To Create A Project Management (P6) Database
(Doc ID 911067.1)
Last updated on MAY 16, 2023
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 22.214.171.124 and later All Platforms
Unable to connect to the database. Would you like to configure the database connection now?
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 InstallationMethod 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:
Java JRE is installed on the machine where the utility will be running.
A JAVA_HOME environment variable exists pointing the the location of the Java JRE installation.
The Java JRE version is a tested version for the appropriate P6 version. The tested JRE versions are listed in each respective version's Tested Configurations document.