Creating users for Oracle databases

You can create the users for Oracle databases either before or after you create the profiles and the deployment environment. Create the deployment environment-level user, the Process Server user, and the Performance Data Warehouse user.
When you use the Deployment Environment wizard to create the deployment environment, you can use the Create Tables option to specify whether database tables are created when the deployment environment is created:
  • If the Create Tables option is selected, database tables are automatically created at the same time as the deployment environment. Therefore, the database users must exist before you run the Deployment Environment wizard.
  • If the Create Tables option is not selected, database table creation is deferred when you create the deployment environment. Therefore, you can create the database users either before or after you run the Deployment Environment wizard. You might find it useful to create the database users after running the wizard because you can use the set of populated scripts, which the wizard generates, to create the database users and database tables at a time that you choose.

Before you begin

You can use a single instance of Oracle for configuring IBM® Business Process Manager. 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 IBM Business Process Manager databases.

About this task

The default database names are BPMDB for the Process database, PDWDB for the Performance Data Warehouse database, and CMNDB for the Common database.

For more information about creating databases, see the following sections:
Parent topic: Configuring the profiles and network deployment environment using multiple tools
Related information:
Creating or augmenting network deployment profiles
Using the Deployment Environment wizard
Troubleshooting Oracle transaction recovery messages

Creating users for the databases before creating profiles or the deployment environment

To create the users for the databases before you create the profiles or before you use the Deployment Environment wizard to create your deployment environment, you can use the createUser.sql template that is provided with your IBM Business Process Manager installation.

Procedure

Complete the following steps for each database user that you want to create:

  1. Navigate to the BPM_HOME/BPM/dbscripts/Oracle/Create directory and make a copy of the createUser.sql file.
  2. In the copied file, replace @DB_USER@ with the user name that you want to use for the database and replace @DB_PASSWD@ with the user password. Save the file.
  3. Create the database user by running the following command on your local or remote database server: 
    sqlplus oracle_user_ID/oracle_password@db_name @createUser.sql

Creating users for the databases after creating the profiles and the deployment environment

After you create the profiles, you can use the Deployment Environment wizard to create the deployment environment and generate the database scripts. The scripts are populated with the configuration values that you specified in the wizard. You can use some of these scripts to create the users for the databases if you chose to defer the creation of the database tables.

Before you begin

You must have already used the Profile Management Tool, the BPMConfig command, or the manageprofiles utility to create and augment the profiles. You must also have used the Deployment Environment wizard to configure the deployment environment.

Procedure

  1. On the computer where you created the deployment manager profile, navigate to one or more of the following default subdirectories where the SQL database scripts were generated:
    • /dmgr_profile_name/dbscripts/deployment_environment_name/Oracle/oracle_instance_name/CMN_user
    • /dmgr_profile_name/dbscripts/deployment_environment_name/Oracle/oracle_instance_name/PS_user
    • /dmgr_profile_name/dbscripts/deployment_environment_name/Oracle/oracle_instance_name/PDW_user

    These directories contain the createUser.sql scripts that you can use to create the users for the databases.

    The number of subdirectories that are generated is dependent on the number of database users that were configured in the Deployment Environment wizard.

  2. For each createUser.sql file that was generated, run the following command on your local or remote database server: 
      sqlplus oracle_user_ID/oracle_password@db_name @createUser.sql