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 machine 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 your application server machine, change to the directory where the configuration scripts for Business Process Choreographer are located:
    • On Windows® systems, enter:
      cd install_root\ProcessChoreographer
      On UNIX and Linux systems, enter:
      cd install_root/ProcessChoreographer
  8. If your database server is on a different machine from your application server:
    1. Copy the following Oracle configuration DDL scripts from the Business Process Choreographer subdirectory on the application server machine to an appropriate directory on your database machine:
      clearSchemaOracle.ddl
      createSchemaOracle.ddl
      createTablespaceOracle.ddl
      dropSchemaOracle.ddl
      dropTablespaceOracle.ddl
    2. On your database machine, change to the directory where you copied the DDL scripts.
  9. Edit the table space creation script according to the instructions at the top of the file createTablespaceOracle.ddl.
  10. Make sure that you are using the user ID that has administrator rights for the database system.
  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 createTablespaceOracle.ddl 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 @createTablespaceOracle.ddl d:\mydb\ts
    If you want to drop the table spaces, you can use the dropTablespaceOracle.ddl script.
  13. To create the schema, run the createSchemaOracle.ddl script. For example, on Windows systems, enter:
    sqlplus bpeuser/bpepwd@BPEDB @createSchemaOracle.ddl

Result

The Oracle database for Business Process Choreographer exists.

What to do next

Continue configuring in the parent topic at step 2.

Terms of use | | Broken links

Last updated: Tue Dec 06 04:14:40 2005

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