3 Creating the Master and Work Repository Schemas

Learn how to create the Master and Work Repository (ODI_REPO) database schemas using the Repository Creation Utility (RCU).

Database schemas creation is required before you configure any domain for your Oracle Data Integrator agent.

This chapter includes the following sections:

3.1 Configuring a Certified Database

Learn how to configure a certified database.

Before you begin, make sure you have installed and configured a certified database.

For more information, see Installing a Database and Database Schemas.

3.2 Starting the Repository Creation Utility

Learn how to start Repository Creation Utility.

Navigate to the ORACLE_HOME/oracle_common/bin directory and start RCU.

  1. Set the JAVA_HOME environment variable to your JDK location.

    On UNIX operating systems:

    setenv JAVA_HOME /home/Oracle/Java/jdkversion
  2. Start RCU.

    On UNIX operating systems:

    ./rcu

    On Microsoft Windows operating systems:

    rcu.bat

3.3 Navigating the Repository Creation Utility Screens to Create the Schema

Learn how to create a database schema for Oracle Data Integrator with Repository Creation Utility (RCU).

Refer to Understanding Repository Creation Screens for more information about any of the screens mentioned in this topic.

To create a schema for Oracle Data Integrator:

  1. Start RCU - Click Next.
  2. Select a Repository Creation Method.

    If you have permission to perform DBA activities on your database, select System Load and Product Load Concurrently.

    If you do not have the permission to perform DBA activities in the database, you must select Prepare Scripts for System Load on this screen. This option will generate a SQL script, which can be provided to your database administrator. See Understanding System Load and Product Load.

  3. Provide the database connection details for RCU to connect to your database.

    Note:

    If you are unsure what the service name for your database is, you can obtain it from the SERVICE_NAMES parameter in the initialization parameter file of the database. If the initialization parameter file does not contain the SERVICE_NAMES parameter, then the service name is the same as the global database name, which is specified in the DB_NAME and DB_DOMAIN parameters.

    For Oracle RAC databases, specify the service name of one of the nodes in this field. For example:

    examplehost.exampledomain.com

    Click Next to proceed, then click OK on the dialog window confirming that connection to the database was successful.

  4. Select Create a new prefix, specify a custom prefix, then select the Oracle Data Integrator schema.

    The custom prefix is used to logically group these schemas together for use in this domain only; you must create a unique set of schemas for each domain as schema sharing across domains is not supported.

    Tip:

    For more information about custom prefixes, see Understanding Custom Prefixes.

    For more information about how to organize your schemas in a multi-domain environment, see Planning Your Schema Creation.

    If you are running RCU from a Standalone installation, you will see the following:

    Description of GUID-39A18D45-510B-4A86-A885-191551C17E8E-default.gif follows
    Description of the illustration GUID-39A18D45-510B-4A86-A885-191551C17E8E-default.gif

    If you are running RCU from an Enterprise installation, you will see the following:

    Description of GUID-4874FC43-0B23-4625-A35B-898EE97BEFF4-default.gif follows
    Description of the illustration GUID-4874FC43-0B23-4625-A35B-898EE97BEFF4-default.gif

    Note:

    If you have already created the ODI repository using ODI Studio, uncheck the ODI entry here and create only the dependent schema. In the Configuration Wizard, after retrieving the dependent schema connectivity from STB schema, manually fill in the ODI repository details

    .

    Tip:

    Make a note of the custom prefix you choose to enter here; you will need this later on during the domain creation process.

    Select Oracle Data Integrator and click Next to proceed, then click OK on the dialog window confirming that prerequisite checking for schema creation was successful.

  5. Specify how you want to set the schema passwords on your database, then specify and confirm your passwords.

    Tip:

    You must make a note of the passwords you set on this screen; you will need them later on during the domain creation process.

  6. Specify the custom variables for the Master and Work Repository.
    Description of GUID-C3ABF5CB-278F-447E-B6BA-06F7AD899301-default.gif follows
    Description of the illustration GUID-C3ABF5CB-278F-447E-B6BA-06F7AD899301-default.gif

    Tip:

    More information about the fields on this screen can be found in Custom Variables.

  7. Navigate through the remainder of the RCU screens to complete schema creation. When you reach the Completion Summary screen, click Close to dismiss RCU.