Adding an Oracle Database

The Add Database dialog box allows adding an existing Oracle database. However, to add a new Oracle database you must first create a new user in Oracle, as specified below.

To add an Oracle database:

1. Click Add in the Databases tab of the PPC. The Add Database dialog box appears.
2. Check the Make this database the current Primavera Portfolio Management database box if you wish to make this database the current one.
3. In the Type field, select Oracle.
4. If you are creating a new database, click Create User. The Create User button launches the Oracle Configuration Utility that guides you through the process of creating a new Oracle user (refer to the Oracle Primavera Portfolio Management Install and Upgrade Guide).
5. Select the connection method (TNS or easy connect).
6. If you select TNS, the 'Service' field is shown.

   In the 'Service' field, enter the service connection string that you use to connect to your Oracle server.

7. If you select EZ Connect, the 'Instance' and 'Server' fields are shown.

   In the 'Instance' field, enter the instance name.

   In the 'Server' field, enter the server name.

8. In the User field, enter the user name of an existing database.
9. In the Password field, enter the password of an existing database. If you created a new database using the Oracle Configuration Utility enter the password you specified there.
10. Click OK.