Running Database Configuration Manually

Use Database Configuration to change connection settings for the client module if your database server configuration changes. For example, if the database is moved to a new server, run Database Configuration to configure the connection to the new server.

Note:

To run Database Configuration manually, 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. On the Database Configuration wizard, click Add to create a new alias.
    1. In the Database alias field, enter a name for the new alias.
    2. In the Driver type field, select Oracle.
  3. 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.

  4. If your database is encrypted using a database key, in the Select database key section:
    1. If you want to use the default key for the database, select Use Default Database Key.
    2. If you do not want to use the default key:
      • In the Key File Name field, click Browse.
      • In the Open dialog box, browse to your key file and click Open.
    3. In the Key Name list select the key to use.
  5. Click Next.
  6. In the Enter public login Information section, enter your public login information that was defined by your administrator.

    Click Test to test the database connection. If the connection is successful, click Save. If the connection is not successful, revise the database connection information you provided.



Legal Notices | Your Privacy Rights
Copyright © 1999, 2020

Last Published Thursday, March 18, 2021