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. You don't need to run RCU in a distributed environment on the machine where only Hyperion Financial Management application server or Oracle Essbase Server is configured.
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:
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).