Creating Infrastructure Schemas Using Repository Creation Utility on FNDHOST1

The Repository Creation Utility (RCU) is used to create schemas to support Oracle Enterprise Performance Management System Java web applications.

To run RCU and update RCU schema properties:

1. Navigate to <Local Drive>:\Oracle\Middleware\oracle_common\bin and launch rcu.bat.
2. On the Welcome page, click Next.
   
   
3. In Create Repository, click Create Repository and System Load and Product Load, and then click Next.
   
   
4. 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.
   
   
5. On the Select Components page, perform these tasks, and then click Next:

   • Select Create new prefix and provide a prefix. For example, specify FNDHOST1.

   • Expand AS Common Schemas and select all the options.
     • Clear the selection for Oracle Data Integrator if Oracle Data Integrator is listed.
     • Clear the selection for Oracle Essbase if Oracle Essbase is listed.

   
   
   
6. On the Schema Passwords page, select Use same passwords for all schemas. Enter a password in Password and Confirm Password, make a note of it, and then click Next.
   
   
7. On the Map Tablespaces page, click Next, and then click OK to create tablespaces.
   
   
8. On the Summary page, review the selections, and then click Create.
   
   
9. On the Completion Summary page, click Close.
   
   
10. Navigate to <Local Drive>:\Oracle\Middleware\EPMSystem11R1\common\config\11.1.2.0\RCUSchema.properties and open it in a text editor.
11. Provide the database details and then save the file.
    • sysDBAUser—The sysdba user for RCU.
    • sysDBAPassword—The sysdba password for RCU.
    • rcuSchemaPassword—RCU schema password created while running RCU.
    • schemaPrefix—The schema prefix used to create RCU.
    • schemaPrefixEssbase —The schema prefix used to create RCU for Essbase.
    • dbURL— The database URL.
    • dbURLEssbase— The database URL for Essbase.

    See Updating RCU Properties .