You can use Oracle, Microsoft SQL Server, or Oracle Autonomous Database 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 or Oracle Autonomous Database, you must make sure to create a database with the Oracle Text option enabled. Oracle Text supports the Oracle or Oracle Autonomous 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 or Oracle Autonomous 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, clear the Create As Container Database option 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.
- 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.