Configuring the ODS Database Connection

Previous TopicNext TopicContents

Use the ODS Database Connection screen to configure the Oracle connection settings for the ODS database instance:

  1. In the Oracle Database Connection section:
    1. In the Host Name field, enter the server machine name or IP address where you installed the database.
    2. In the Port Number field, enter or verify the port number for your database.

      The default for Oracle is 1521.

    3. Choose the Service Name or SID option. Enter the Service Name or SID.
  2. In the Database Credentials section, enter the Oracle system username and password:
    1. In the Username field, enter or verify your DBA user name that has DBA privileges for the ODS database. The default name is SYSTEM.
    2. In the Password field, enter the password for the DBA user.
  3. In the New User section, enter the connection information for the table owner:
    1. In the Username field, enter or verify the ODS user name. This user will own the ODS tables.
    2. In the Password and Confirm Password fields, enter a password for the ODS user.
  4. Click Next.

Related Topics

Configuring the Oracle ODS Database

Configuring the P6 EPPM Database Connection on an Oracle Instance

Configuring the P6 EPPM Database Connection on a Microsoft SQL Server Database

Configuring ETL Settings for ODS

Finishing the Configuration Wizard for ODS

Finishing the ODS Database Configuration



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014