Creating Infrastructure Schemas Using Repository Creation Utility

The Repository Creation Utility (RCU) is used to create schemas to support Oracle Enterprise Performance Management System Java web applications. This process requires sys DBA credentials.

You must run RCU on each machine in your environment.

Make sure you've set up database schemas for your database. See Preparing a Database.

If you are using SQL Server, you must create an additional database for use with RCU. See Using a Microsoft SQL Server Database.

To create schemas using the Repository Creation Utility:

  1. Navigate to Middleware home/oracle_common/bin/.
  2. Launch rcu.bat.
  3. On the Welcome page, click Next.
  4. Click Create Repository and System Load and Product Load, and then click Next.
    If you have previously created a repository and configured EPM System, and you want to perform a fresh configuration , drop the repository, and then create a new repository.
  5. On the Database Connection Details page, specify a user with DBA or SYSDBA privileges, such as sys, provide the fully qualified service name, and then click Next.
  6. On the Select Components page, perform these tasks, and then click Next:
    • Select Create new prefix and provide a prefix.

      Oracle recommends that you use the same prefix for the EPM System database user and for the RCU database.

    • Expand AS Common Schemas and select all the options.
    • Clear the selection for Oracle Data Integrator.
    • Make a note of the Schema Owner names for all the components because you need them to configure Oracle Web Services Manager.

  7. On the Schema Passwords page, Oracle recommends that you select Use same passwords for all schemas. Enter a password, make a note of it, and then click Next.
  8. On the Map Tablespaces page, click Next, and then click OK to create tablespaces.
  9. On the Summary page, review the selections, and then click Create.
  10. On the Completion Summary page, click Close.

For additional information on the Repository Creation Utility, see the Oracle® Fusion Middleware Repository Creation Utility User’s Guide 11g Release 1 (11.1.1).