Properties for Oracle Autonomous Database 19c

Starting with Release 11.2.21, Oracle Autonomous Database 19c on Dedicated Infrastructure (ATP-D) is certified and supported.

Note:

• For all Oracle Autonomous Database (ADB) EPM deployments where the ADB database is not deployed on dedicated infrastructure in Oracle Cloud, it is necessary to map RCU tablespaces to "DATA" and "TEMP" when pre-creating RCU schemas for EPM and the bundled Essbase 21c. See Known Issues and Workarounds Related to Product Installation and Configuration on an Autonomous Transaction Processing Database for details.
• In Oracle Autonomous Database the predefined administrative user is ADMIN (which is a non-SYSDBA user). See Enabling Non-SYSDBA User Support for Essbase Configuration for Essbase Configuration.

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=<sysdba user>
   sysDBAPassword=<The sysdba password for RCU>
   schemaPrefix=<The schema prefix used to create RCU>
   rcuSchemaPassword=<RCU schema password>
   dbURL=jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_TIMEOUT=120)(RETRY_COUNT=20)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=HOST_NAME)(PORT=PORT_NUMBER)))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))

   Table 10-2 Properties for Oracle Autonomous Database 19c

   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	For detailed password information, see Create Users on Autonomous Database - Connecting with a Client Tool.
   dbURL	Database URL: dbURL=jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_TIMEOUT=120)(RETRY_COUNT=20)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=HOST_NAME)(PORT=PORT_NUMBER)))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))
   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: dbURLEssbase=(DESCRIPTION=(CONNECT_TIMEOUT=120)(RETRY_COUNT=20)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=HOST_NAME)(PORT=PORT_NUMBER)))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME))) Note: If you choose to pre-create the Essbase RCU schemas, ensure that the preCreateEssbaseRCU=true parameter is set in the RCUSchema.properties file.