Creating Oracle databases and validating database connections

For each deployment environment that you are creating, complete the following steps:

1. Create required databases.
   If you are migrating to a Standard deployment environment:

   • Create a database for Business Space if you did not have one in the source environment.
   • Create a messaging engine database if you want to use a single messaging engine bus in the new environment (recommended). If you want to use multiple buses, you can reuse the previous messaging engine database and schema.

   If you are migrating to an Advanced deployment environment:

   • Create a database for Business Space if you did not have one in the source environment.
   • Create a Business Process Choreographer database.
   • Create a messaging engine database if you want to use a single messaging engine bus in the new environment (recommended). If you want to use multiple buses, you can reuse the previous messaging engine database and schema.

   For each database, make any required changes and run the following script:

   install_root\BPM\dbscripts\Oracle\Create\createUser.sql

2. For case management, you must create three additional users, one for IBM Content Navigator (ICN), one for the design object store (DOS), and one for the target object store (TOS).
   1. Find the files to create the databases in install_root\BPM\dbscripts\Oracle\Create.
   2. To create the IBM Content Navigator database, replace the parameters in the following files:

      createUser.sql
      createTablespace_ICN.sql

      where:

      • @DB_NAME@ is the Oracle instance name, for example, orcl.
      • @DB_DIR@ is the directory, which you must create before running the SQL files. The DB_DIR directory is the data directory of your database.
      • @ECMClient_TBLSPACE@ is the table space used by IBM Content Navigator (ICN). The default value is WFICNTS.
      • @ECMClient_SCHEMA@ is the schema used by ICN.
      • @DB_USER@ is the ICN user name, for example, icnuser. The schema name and user name are usually the same.
      • @DB_PASSWD@ is the password for the user.
   3. Run the files to create the IBM Content Navigator database.

      createUser.sql
      createTablespace_ICN.sql

   4. To create the users and table spaces for IBM Enterprise Content Management, using the embedded Content Platform Engine, find the following database creation SQL file and make a copy of it.

      createUserTablespace_ECM.sql

      Replace the following parameters:

      • Use the backslash ("\") to replace the forward slash as the file separator.
      • @ECM_DATA_TS@ is the data table space used by DOS or TOS. The default value for DOS is WFDOSDATATS. The default value for TOS is WFTOSDATATS. You can set these values in the SQL file.
      • @DB_NAME@ is the Oracle instance name, for example, orcl.
      • @DB_DIR@ is the data directory of your database.
        Important: Make sure that the @DB_DIR@\@DB_NAME@ path already exists on your database computer. You will use this value when you update the properties file later.
      • @DB_USER@ is the DOS user name or TOS user name. for example, dosuser or tosuser.
      • @DB_PASSWD@ is the password for the user.
   5. Run the file to create the Enterprise Content Management users and table spaces.

      createUserTablespace_ECM.sql

3. On the target deployment manager computer, validate that all database connections are correctly configured by running the BPMConfig -validate command.
   Use the following syntax:

   target_install_root\bin\BPMConfig -validate -db configuration_properties_file

   where

   • configuration_properties_file is the full path and name of the properties file that you copied over to the target environment after you extracted information using the BPMConfig -migrate command. Update the properties in the file for any new databases that you created.
   The command checks each connection and displays a message similar to the following message:

   A JDBC connection to the 'BusinessSpaceDb' (CMNDB.bpmadmin) has been successfully established.