The Oracle Database administrator (DBA) creates the P6 Professional database, then runs P6 Professional SQL scripts, which create each database’s structure (tables, indexes, relationships, etc.).
Notes:
- Oracle must be run in Dedicated Mode (rather than MTS mode).
- If you need to use the Euro symbol in any Western European language, you must use codepage WE8MSWIN1252 or UTF8. Please note, if you change the NLS_LENGTH_SEMANTICS parameter from BYTE to CHAR, you will not affect the software. Oracle recommends using CHAR if using UTF8 because some characters are two or three bytes.
These instructions assume you are an Oracle DBA or are familiar with administering Oracle databases. They also assume you have set up an Oracle server instance and configured your network. You must complete the steps in the order specified. If you have any questions about the manual setup process, please contact Oracle Global Customer Support before proceeding.
You can also use a wizard that automatically creates the database structures and loads the data for you. See the P6 EPPM Installation and Configuration Guide for more information.
Oracle recommends that you use SQL Plus to run scripts referenced in the following instructions.