Running Database Configuration Manually with an Oracle Database Driver

To run Database Configuration manually with an Oracle database driver, complete the following steps:

  1. 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.
  2. Click Next.
  3. On the Select Database Alias Task dialog box, choose to either Modify an existing database alias or Create a new database alias.
  4. On the Select or Create Alias dialog box, select values for the following fields:
    1. In the Database alias field, enter a new alias. For example, PMDB.
    2. In the Driver type field, select Oracle.
  5. 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.

  6. On the Enter Public Login Information dialog box, enter your public login information that was defined by your administrator.
  7. On the Validate Database Connection dialog box, review the settings and click Next to test the database connection.
  8. If the connection is successful, click Finish.

    If the connection is not successful, click Back to revise the database information.

Related Topics

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



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Tuesday, October 04, 2016