Creating the ActiveMatrix Administrator Database Using Oracle

Create an Oracle database and create a database user to access it.

Procedure

  1. Create an empty database which will be used to hold the ActiveMatrix Administrator database tables - for example, amx.
    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. Create a database user (or identify an existing one) for the system to use to connect to the ActiveMatrix Administrator database - for example, amx_db_user. This user:
    • must not possess "dba" privileges.
    • must have "connect" and "resource" privileges.
    • must be assigned to the default schema.

    You will specify this user in the Username field of the Administrator Server Configuration: Database Details screen when you run the Create TIBCO ActiveMatrix BPM Server Wizard or Create TIBCO ActiveMatrix Administrator Server Wizard.

  4. Make sure that the database is available.