For Essbase Schema creation, with SYSDBA credentials, see Configure Essbase on Linux topic for more information.

EPM Configurator currently supports only the SYSDBA User for Essbase configuration. The SYSDBA User provides the Essbase RCU prefix in the RCUSchema.properties file, and during configuration, the RCU for Essbase is created.

To enable support for Non-SYSDBA User for Essbase Configuration, a new flag, preCreateEssbaseRCU, is now introduced in the RCUSchema.properties file.

1. Pre-create the RCU schema for Essbase using the RCU tool.
   1. Navigate to Middleware home/oracle_common/bin/.
   2. Launch rcu.bat.

      For Linux, run ./rcu

   3. On the Welcome page, click Next.
   4. On the Create Repository page, click Create Repository, and click System Load and Product Load, and then click Next.

      
      
      

   5. On the Database Connection Details page, leave Connection Parameters selected. Specify a user with DBA or SYSDBA privileges, such as sys, provide the fully qualified host name, service name, Username and Password. Leave the Role as default of SYSDBA. and then click Next.

      
      
      

   6. The Repository Creation Utility checks prerequisites. Click OK to continue.

      
      
      

   7. On the Select Components page, perform these tasks, and then click Next:
      1. Select Create new prefix and provide a unique prefix.
      2. Expand AS Common Schemas and select all the options. Oracle Essbase and Essbase schema will NOT appear if Essbase hasn't been installed.

      
      
      

   8. On Schema Passwords page, enter passwords for the schemas. Click Next.
   9. On Map Tablespaces page, review the tablespaces and click Next.
   10. Click OK to approve creation of new tablespaces in the repository database.
   11. Review the Summary page. Optionally, click Save Response File to save your metadata and choices for reuse. Click Create.
   12. Review the Completion Summary. If status was Success for all components, click Close, otherwise, address any issues.
   13. You have completed pre-creating schemas for Essbase and platform components.
2. Add the following flag to RCUSchema.properties file:

   preCreateEssbaseRCU=true

3. Configure Essbase through the EPM Configurator.

   Note:

   These steps are required only if you are using a Non-SYSDBA User or if you want to manually pre-create and use the RCU.