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:
- Click Add in the Databases tab of the PPC. The Add Database dialog box appears.
- Check the Make this database the current PPM database box if you wish to make this database the current one.
- In the Type field, select Oracle.
- 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).
- Select the connection method (TNS or easy connect).
- 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.
- 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.
- In the User field, enter the user name of an existing database.
- 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.
- Click OK.