You can use either Oracle or Microsoft SQL Server on your database server for P6 EPPM installations. 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 that 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.
Notes:
When you attempt to create a database using Oracle Database 12c, the option to create a pluggable database will be 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 these components automatically get installed with the latest versions of an Oracle database (11g and later). 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 on the Oracle Technology Network (OTN) for information on how to install these components.