The P6 Professional database stores all P6 Professional data used by all P6 Professional applications.
P6 Professional supports Oracle and Microsoft SQL Server databases. See the Tested Configurations document for details on which versions are supported. The Microsoft SQL Server or Oracle server software must be installed on the database servers before you can create the database.
Note: P6 Professional R8.x includes an encryption algorithm that provides enhanced security for private database logins; however, the encryption algorithm is not automatically enforced when you manually configure or upgrade your database. If you manually configure or upgrade your database, Oracle recommends that you use this encryption algorithm. To do so, you must reset the private database login. See Resetting Private Database Passwords to Use the New Encryption Algorithm for instructions. If automatically installing or upgrading your database, no configuration is needed after the upgrade to use the encryption algorithm. User logins and passwords are not affected.
Tips
- P6 Professional does not support passwords with multi-byte characters.
- When you install the Oracle client, the TNSPING.EXE utility is automatically installed in the \oracle\ora_home\bin folder. This utility must be present for P6 Professional applications. Do not delete it.
- See Automatic Database Upgrade Considerations and Prerequisites for instructions on automatically upgrading your databases to the current version if you have manually configured P6 Professional databases for an earlier version. If you want to manually upgrade your databases, see the Manually Upgrading the P6 Professional Database for Oracle document or the Manually Upgrading the P6 Professional Database for Microsoft SQL Server document.
- For security reasons, Oracle strongly recommends that you replace the default database users' (admuser, privuser, pubuser, and bgjobuser) passwords immediately after a manual database installation or an upgrade from P6 version 7.0 and earlier. Do not use special characters in the database name, privileged user, or public user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
- Oracle recommends using strong passwords. Strong passwords in P6 Professional are defined as passwords containing between 8 and 20 characters and at least one numeric and one alpha character. To further strengthen the password, use a mixture of upper and lower case letters.
- See Modifying Private Database Logins for P6 Professional for instructions on how to replace the private database login. For all other database user names and passwords, use the tools included with Oracle Database. The background job user only has to be reset for manual installations.
- For security reasons, Oracle strongly recommends that you replace the default Admin Superuser (admin) immediately after a manual database installation or an upgrade from P6 version 7.0 and earlier.
- To configure the Oracle Database server for SSL, please see the Advanced Security Administrator's Guide included with the Oracle Database Server Documentation for configuring the Oracle Server and Oracle Client(s) for SSL.