Properties for Oracle Database

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

  2. Provide the required database details:

    Example RCUSchema.properties file for Oracle Database 

    sysDBAUser=EPMLogin
sysDBAPassword=<The sysdba password for RCU>
schemaPrefix=<The schema prefix used to create RCU>
rcuSchemaPassword=<RCU schema password>
dbURL=jdbc:oracle:thin:@hostname:port:SID

    Table 9-1 Properties for Oracle Database

    Property Description
    sysDBAUser The SYSDBA user for RCU.
    sysDBAPassword The SYSDBA password for RCU. The maximum password length is 16 characters.
    schemaPrefix The schema prefix used during RCU creation. Ensure it matches the Oracle Hyperion Shared Services Registry database user.
    rcuSchemaPassword The RCU schema password created while running RCU. The maximum password length is 16 characters and cannot start with a number or special character. Allowed special characters: $, #, _.
    dbURL Database URL:
    • With SID dbURL=jdbc:oracle:thin:@hostName:port:SID
    • With Service Name dbURL=jdbc:oracle:thin:@hostName:port/serviceName or dbURL=jdbc:oracle:thin:@//hostName:port/serviceName
    For Essbase only
    schemaPrefixEssbase
    • The schema prefix used for creating the RCU schema for Essbase. Ensure that this prefix is unique and different from the schemaPrefix value.
    • The schema prefix must be at least 1 character long and no more than 12 alphanumeric characters (0-9, a-z, or A-Z), excluding the underscore character. It cannot begin with a number, and whitespace or special characters are not allowed.
    • The EPM Configurator will create the Essbase RCU schema based on the value entered in schemaPrefixEssbase.
    dbURLEssbase The database URL for Essbase. For example: hostname:port:sid

    Database URL:

    • With SID dbURLEssbase=hostName:port:SID
    • With Service Name dbURLEssbase=hostName:port/servicename or dbURLEssbase==(DESCRIPTION=(ADDRESS=(host=host_name)(protocol=protocol_name)(port=port_number))(CONNECT_DATA=(SERVICE_NAME=service_name)))
    • With PDB dbURLEssbase=hostName:port/PDB
    • For SSL dbURLEssbase=serviceName?TNS_ADMIN=PATH_TO_WALLET_FILES

      Note:

      TNS_ADMIN must point to a folder containing sqlnet.ora, tnsnames.ora, a wallet, and ojdbc.properties files.