To change database connection settings for P6:
- Do one of the following:
- On Windows platforms, run dbconfigpv.cmd (located in the p6home directory that you specified when installing P6).
- On UNIX platforms, change to the p6home directory that you specified when installing P6, and run dbconfigpv.sh.
- On the Setup and Configuration of the Primavera P6 Database dialog box, select the database type.
- On the Please enter the following information. . . dialog box:
- Specify the database connection parameters. Type your database user name (for example, pubuser) and password, the database name, host address, and host port. The database name, host address, and host port are specific to your database installation. The Database Host Port field displays the default port for the database type you selected. You can edit this port.
- To use the SSL protocol to securely communicate between the P6 application server and the database server, select the SSL option. If you select the SSL option, you must specify an SSL-enabled port number in the Database Host Port field.
Notes:
- See the appropriate database server documentation and the My Oracle Support's Knowledge Articles for information on configuring SSL.
- Using the SSL protocol will impact database performance.
- Ensure that the Public Group ID is 1 for a standard configuration.
- If there is an existing Primavera configuration, on the The installer has detected. . . dialog box, choose whether you want to use it, or create a new configuration.
Note: If you are upgrading from a previous version of P6 against the same database, choose the option to create a new configuration. This is necessary to accommodate newly added configuration settings. See Primavera P6 Administrator Setup Tasks for more information about configurations.
If you have not created a Primavera configuration, the The installer has detected. . . dialog box does not appear and the installation process automatically creates a default configuration named Primavera P6 Configuration. You can edit the settings for this configuration through the Primavera P6 Administrator.
- When the message displays to confirm that the database configuration has completed successfully, click OK.
- On the End of Installation screen, click Exit.