You can use either Oracle or Microsoft SQL Server on your database server for P6 EPPM deployments. For more information about supported database versions, refer to Tested Configurations. You must install the database server before you can create the P6 EPPM database.
If you are using an Oracle Database, you must make sure to create a database with the Oracle Text option enabled. Oracle Text supports the Oracle Database content repository by using standard SQL to index, search, and analyze text and documents stored in the database, in files, and on the web. For more details, refer to the Oracle Database documentation.
If you are using a Microsoft SQL Server Database, you must make sure that you enable FILESTREAM before attempting your P6 EPPM installation or upgrade. For information about how to enable FILESTREAM, refer to the Microsoft SQL Server documentation for your version.
Notes:
- If you attempt to create a database using an Oracle Database, the option to create a container database is enabled by default. If you do not want to create a container database, deselect the Create As Container Database check box during the database creation process. If you create a container database, you must also create a pluggable database on which to install your P6 EPPM instance.
- When using an Oracle Database, you must install Oracle Multimedia, along with these supporting components: Oracle JVM, Oracle XML DB (XDB), and XML Developer's Kit (XDK). Unless you specify otherwise, all of these components will automatically be installed with an Oracle Database. If you chose not to install these components, you will need to install them before you install P6 EPPM. See the Oracle Multimedia's User's Guide for information on how to install these components.
- Oracle Text is enabled by default.
- jobsvc.job_data_x is used to store XML data for XML import processes using the Varbinary(Max) datatype. In order to support the Varbinary(Max) datatype, you must enable FILESTREAM.
- A SQL database name must not contain a space.