IBM BPM, V8.0.1, All platforms > Install IBM BPM > IBM BPM Advanced > Install IBM BPM Advanced > On Linux > Network deployment environment > Create databases and database design files

Set up databases for Oracle

IBM BPM requires a Process Server database, Performance Data Warehouse database, and Common database. The Common database contains Business Space and other components. You must create the databases before ND.

You can use a single instance of Oracle for configuring BPM. The Oracle instance must exist and be available for access. Consult the Oracle documentation to create an Oracle instance. If you use a single Oracle instance, make sure that you use different user IDs for the three different BPM databases.


Procedure

  1. Create a table space.
    SQL> CREATE TABLESPACE [tablespace_name] DATAFILE '[datafile_name]' SIZE 50M AUTOEXTEND ON NEXT 10M
    MAXSIZE UNLIMITED LOGGING;

  2. Create the users. You will specify these users on the Database Configuration - Part 2 page in pmt.sh.

    The following example assumes you create a BPMDBA user name for the Process Server database, a PDWDBA user name for the Performance Data Warehouse database, and a CMNDBA user name for the Common database:

    SQL> CREATE USER BPMDBA IDENTIFIED BY [password] DEFAULT TABLESPACE [tablespace_name];
    SQL> CREATE USER PDWDBA IDENTIFIED BY [password] DEFAULT TABLESPACE
    [tablespace_name];
    SQL> CREATE USER CMNDBA IDENTIFIED BY [password] DEFAULT TABLESPACE
    [tablespace_name];
  3. Grant privileges to the users that you specified in the previous step.

    For example:

    SQL> GRANT ALL PRIVILEGES TO BPMDBA;
    SQL> GRANT ALL PRIVILEGES TO PDWDBA;
    SQL> GRANT ALL PRIVILEGES TO CMNDBA;
  4. Grant execute privileges on DBMS_LOCK.

    For example:

    SQL> GRANT execute on DBMS_LOCK to BPMDBA;
    SQL> GRANT execute on DBMS_LOCK to PDWDBA;
    SQL> GRANT execute on DBMS_LOCK to CMNDBA;

Create databases and database design files