Creating an Oracle database for Business Process Choreographer

Use this task to create an Oracle database for Business Process Choreographer.

Steps for this task

  1. Install the Oracle server on the computer that hosts the database. Be sure that you are using the 32-bit Oracle libraries that are located in the lib32 subdirectory.
  2. On Linux® and UNIX® systems, make sure that the environment variables ORACLE_BASE and ORACLE_HOME are set for the root user.
  3. Check the class path to be sure that your JDBC driver is using the ojdbc14.jar file.
  4. On Linux and UNIX systems, create soft links to the following Oracle libraries in the /usr/lib directory:
    • For Oracle 10g: Link to: libclnt.so.10.1.
    • For Oracle 9i: Link to: libwtc9.so, libclntsh.so.9.0, and libocijdbc9.so.
  5. Create an Oracle database using the Database Configuration Assistant, for example, with the name BPEDB. There is no script to quickly create a default Oracle database for Business Process Choreographer. Make sure that you select the JServer option for the database. The database must be created to have a Unicode code page.
  6. Start the Oracle listener by entering the command:
    lsnrctl start
  7. On the server that hosts your application server, change to the directory where the Business Process Choreographer configuration scripts for your database system are located:
    • On Windows® systems, enter:
      cd install_root\dbscripts\ProcessChoreographer\Oracle
    • On UNIX and Linux systems, enter:
      cd install_root/dbscripts/ProcessChoreographer/Oracle
  8. If your database is on a different server from your application server:
    1. Copy the following Oracle configuration SQL scripts from the Business Process Choreographer subdirectory on the server that is hosting the application server to an appropriate directory on the server that is hosting your database:
      clearSchema.sql
      createSchema.sql
      createTablespace.sql
      dropSchema.sql
      dropTablespace.sql
    2. Optional: If you want Business Process Choreographer Observer to use the same database as the business process container:
      1. Also copy the following SQL scripts to the same directory on your database server:
        clearSchema_Observer.sql
        createSchema_Observer.sql
        createTablespace_Observer.sql
        dropSchema_Observer.sql
        dropTablespace_Observer.sql
      2. Copy the jar file bpcodbutil.jar, from the lib subdirectory of the install_root directory to the same directory on your database server.
    3. On your database server, change to the directory where you copied the SQL scripts.
  9. Edit the table space creation script according to the instructions at the top of the file createTablespace.sql.
  10. Make sure that you are using a user ID that has at least the following rights for the database: CONNECT, RESOURCE, CREATE TABLESPACE, DROP TABLESPACE and CREATE TABLE.
  11. If you do not want to create the schema in the default instance, set the ORACLE_SID environment variable.
  12. To create the table spaces, run the createTablespace.sql script, as described in the script header. For test purposes, you can use the same location for all table spaces and pass the path as a command-line argument to the script, for example, on a Windows system, using user ID bpeuser, password bpepwd, database name BPEDB, and table space path d:\mydb\ts, enter:
    sqlplus bpeuser/bpepwd@BPEDB @createTablespace.sql d:\mydb\ts
    If you want to drop the table spaces, you can use the dropTablespace.sql script.
  13. To create the schema, run the createSchema.sql script. For example, on Windows systems, enter:
    sqlplus bpeuser/bpepwd@BPEDB @createSchema.sql
  14. Optional: If you want Business Process Choreographer Observer to use the same database as the business process container, perform the following actions:
    1. Install the jar file that contains UDFs for Business Process Choreographer Observer.
      1. On your database server, change to the directory where the jar file bpcodbutil.jar is located:
        • If your database is on the same server as the application server, change to the lib subdirectory of the install_root directory.
        • If your database is not on the same machine as your application server, change to the directory where you copied the jar file bpcodbutil.jar in step 8.b.ii.
      2. Run the Oracle loadjava utility to install the jar file bpcodbutil.jar, by entering the following command:
        loadjava -user user/password@database -resolve bpcodbutil.jar
        where user, password, and database have the same values that you specified for user, password, and database in step 12.
      3. In case of problems, you can drop the jar file using the command: dropjava bpcodbutil.jar.
    2. Create the table space
      1. Edit the createTablespace_Observer.sql script file according to the instruction at the top of the file.
      2. Run the createTablespace_Observer.sql script file according to the instruction at the top of the file.
      3. Make sure that the script output contains no errors. If errors occur, you can drop the table space using the dropTablespace_Observer.sql script file.
    3. Create the schema (tables, indexes, and views).
      1. Run the createSchema_Observer.sql script file according to the instruction at the top of the file.
      2. Make sure that the script output contains no errors. If you want to drop the schema, use the dropSchema_Observer.sql script file.

Result

The database for Business Process Choreographer exists.

What to do next

Continue configuring in the parent topic at step 2.

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)