Configuring the BPM Database Server Using Oracle 12c

Create an Oracle database instance (including a pluggable database for BPM), configure it, and start it.

Procedure

  1. Create an Oracle database instance that will be used to hold the ActiveMatrix BPM database.
    You must create a pluggable database (PDB) in your container database (CDB) for BPM to use. This is because BPM users have exclusive rights to perform actions; if you install ActiveMatrix BPM on the CDB, BPM users have exclusive rights to perform actions on the CDB.
    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.
    After the startup of the CDB, the PDBs are not opened automatically. You must make sure that the PDB on which BPM is running is opened after startup. For more information, please refer to the documentation supplied with Oracle12c.