Updating RCU Schema Properties

Update RCU schema properties on each machine in your environment.

Note:

You don't need to update RCU schema properties in a distributed environment on the machine where only Oracle Essbase Server is configured.

1. Navigate to EPM_ORACLE_HOME /common/config/11.1.2.0/RCUSchema.properties.

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

   • dbURL—For example: dbURL=jdbc:oracle:thin:@hostname:port:sid

The passwords are encrypted.

Enter these properties once before configuring. You don't need to make subsequent updates if you reconfigure or redeploy.

Notes for dbURL:

• Format for Oracle Database with SID:

  dbURL=jdbc:oracle:thin:@hostName:port:SID

• Format for Oracle Database with service name:

  dbURL=jdbc:oracle:thin:@hostName:port/serviceName

  or

  dbURL=jdbc:oracle:thin:@//hostName:port/serviceName

• Format for Microsoft SQL Server, with SID, using the name for database you already created:

  dbURL=jdbc:weblogic:sqlserver://hostName:port;databaseName=databaseName