Update RCU schema properties on each machine in your environment.
You don't need to update RCU schema properties in a distributed environment on the machine where only Oracle Essbase Server is configured.
Navigate to EPM_ORACLE_HOME
Provide the required database details. If you are using Microsoft SQL Server, provide the database details for the RCU database you created.
These properties are used during configuration.
sysDBAUser—The sysdba user for RCU
sysDBAPassword—The sysdba password for RCU. The maximum password length is 16 characters.
rcuSchemaPassword—RCU schema password created while running RCU. 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.
schemaPrefix—The schema prefix used to create RCU. (Make sure it is the same as the Oracle Hyperion Shared Services Registry database user)
Note:In a distributed environment, for each machine, specify the prefix you created for that machine.
The passwords are encrypted.
Enter these properties once before configuring. You don't need to make subsequent updates if you reconfigure or redeploy.
Format for Oracle Database with SID:
Format for Oracle Database with service name:
Format for Microsoft SQL Server, with SID, using the name for database you already created: