IBM® Business Process Manager 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 network deployment.
About this task
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
- Create a table space.
SQL> CREATE TABLESPACE [tablespace_name] DATAFILE '[datafile_name]' SIZE 50M AUTOEXTEND ON NEXT 10M
MAXSIZE UNLIMITED LOGGING;
- Create the users. You will specify these
users on the Database Configuration - Part 2 page
in the Profile Management Tool. 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];
- 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;
- 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;