Running Database Configuration Manually with an Oracle Database Driver
To run Database Configuration manually with an Oracle database driver, complete the following steps:
- If Database Configuration does not launch automatically, click Start, All Programs, Oracle - Primavera P6, P6 Professional <release level>, P6 Professional <release level> Help and Tools, Database Configuration.
- Click Next.
- On the Select Database Alias Task dialog box, choose to either Modify an existing database alias or Create a new database alias.
- On the Select or Create Alias dialog box, select values for the following fields:
- In the Database alias field, enter a new alias. For example, PMDB.
- In the Driver type field, select Oracle.
- On the Configure ORACLE Connection dialog box, in the Oracle Connection String field, enter the Oracle EZCONNECT string in the format,
//<server name>:<listen port>/<service name>
. If using the TNSNAMES file, enter the Oracle Database name.
Note: The two leading slashes are mandatory for API applications like Update Baseline, XML Export/import, and Schedule Comparison.
- On the Enter Public Login Information dialog box, enter your public login information that was defined by your administrator.
- On the Validate Database Connection dialog box, review the settings and click Next to test the database connection.
- If the connection is successful, click Finish.
If the connection is not successful, click Back to revise the database information.
Running Database Configuration Manually
Running Database Configuration Manually with a Microsoft SQL Server Database Driver
Running Database Configuration Manually with a Cloud Connect Database Driver