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.

If you don't have sys DBA credentials, see Configuration Tips and Solutions in Oracle Enterprise Performance Management System Installation and Configuration Troubleshooting Guide .

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

You must run RCU on each machine in your environment. In a distributed environment, create a new, different prefix for each machine in the environment.

Note:

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

In a distributed environment for SQL Server, each RCU must be created on a separate schema. You need need a separate schema for each RCU and each schema needs to be mapped to a different login user.

To create schemas using the Repository Creation Utility:

1. Navigate to Middleware home/oracle_common/bin/.
2. Launch rcu.bat.

   For Linux, run ./rcu

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.

     Note:

     In a distributed environment, create a new, different prefix for each machine in the environment.
   • Expand AS Common Schemas and select all the options.
   • Clear the selection for Oracle Data Integrator if Oracle Data Integrator is listed.

   • 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, you must select Use same passwords for all schemas. Enter a password, make a note of it, and then click Next.

   The maximum password length is 16 characters.

   The password can contain alphabets, numbers, and the following special characters: $, #, _. Password should not start with a number or special character.

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).