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.
- On the Database Configuration wizard, click Add to create a new alias.
- In the Database alias field, enter a name for the new alias.
- In the Driver type field, select Oracle.
- 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.
- If your database is encrypted using a database key, in the Select database key section:
- If you want to use the default key for the database, select Use Default Database Key.
- 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.
- In the Key Name list select the key to use.
- Click Next.
- 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.