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:
- If you are using Oracle EZCONNECT, enter the connection string in the format,
//<server name>:<listen port>/<service name>.Note: The two leading slashes are mandatory for API applications like Update Baseline, XML Export/import, and Schedule Comparison.
- If you are using the TNSNAMES file, enter the Oracle Database name.
- If you are using Oracle EZCONNECT, enter the connection string in the format,
- Choose whether to use ADO.NET Data Access option.
- If your database is encrypted using a database key, in the Keystore section:
- If you want to use the default key for the database, select Use default database keystore.
- If you do not want to use the default key:
- In the Keystore file 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.