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.
-
Navigate to EPM_ORACLE_HOME
/common/config/11.1.2.0/RCUSchema.properties
. -
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