Configuring the BPM Database Server Using Oracle 11g

Create an Oracle database instance, configure it, and start it.

Procedure

  1. Create an Oracle database instance that will be used to hold the ActiveMatrix BPM database.
    Note: The ActiveMatrix BPM database (for each BPM system) and ActiveMatrix Administrator database must use separate Oracle database users/schemas. Use of separate tablespaces is also advised.
  2. Set the OPEN_CURSORS initialization parameter to a value of 400 or greater.
  3. Configure the character sets for the Oracle database instance as follows: NLS_CHARACTERSET must be AL32UTF8 and NLS_NCHAR_CHARACTERSET must be AL16UTF16.
  4. Start the Oracle database instance.