Installation guide

TIBCO ActiveMatrix BPM Installation and Configuration
108
|
Chapter 5 Creating and Configuring Runtime Objects
Manually Run the BPM Database Creation Scripts
The structure of the /
BPM/database directory is shown below:
The
admin directory contains the database administrator scripts that contain the
commands needed to create the schema itself. In Oracle, this means creating the
tablespaces and in SQL Server, creating the logins that will own the schema and
database.
The rest of the directories contain the SQL scripts required to create and/or
upgrade the tables for each BPM component. These are for reference only.
Your database administrator needs to run the following scripts in the order shown
to manually create the BPM database:
(This only applies to Oracle)
If you need to manually amend any of the BPM database creation scripts, make
sure that you do not include any blank lines. If there are any blank lines, you will
receive an error similar to the ones below:
SP2-0734: unknown command beginning "CONSTRAINT..."
SP2-0042: unknown command ")"
and the rest of the line is ignored. To resolve this, you can:
remove all blank lines from the script
set sqlblanklines on on the sqlplus session
Script Description Run As
/
BPM/database/admin/setup-a
dmin.sql
These scripts contain the commands needed
prior to creating the schema itself. On Oracle
this means creating the tablespaces and in
SQL Server this means creating the logins
that own the schema and database.
Database
Administrator
/
BPM/database/admin/created
b-admin.sql
These scripts contain the commands required
to create the database and/or schema.
Database
Administrator