Creating an Oracle database for process choreographer

Why and when to perform this task

There is no script to quickly create a default Oracle database for 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 located in the lib32 subdirectory.
  2. For the root user, set the environment variables ORACLE_BASE and ORACLE_HOME.
  3. If you are not using the thin JDBC driver, install the database client on:
    • All remote application servers that use the database server.
    • On the deployment manager machine if you are using Network Deployment to administer process choreographer, for example if you are creating a clustered Process choreographer setup.
  4. Check the classpath to be sure that your driver (thin or OCI) is using the ojdbc14.jar file.
  5. On UNIX systems, create soft links to the following Oracle libraries in the /usr/lib directory:
    • For Oracle 8i: Link to: libwtc8.so, libclntsh.so.8.0, and libocijdbc8.so.
    • For Oracle 9i: Link to: libwtc9.so, libclntsh.so.9.0, and libocijdbc9.so.
  6. Create an Oracle database using the Database Configuration Assistant, for example with the name BPEDB.
    Make sure that you select the JServer option for the database. It is recommended that you use a Unicode code page when creating the database because the text data you pass to the APIs must be compatible with the selected code page.
  7. Start the Oracle listener by entering the command:
    lsnrctl start
  8. On your application server machine, change to the directory where the configuration scripts for process choreographer are located:

    On Windows systems, enter:

    cd install_root\ProcessChoreographer

    On UNIX systems, enter:

    cd install_root/ProcessChoreographer

  9. If your database server is on a different machine to your application server:
    1. Copy the following Oracle configuration DDL scripts from the process choreographer subdirectory on the application server machine to an appropriate directory on your database machine:
      • clearSchemaOracleX.ddl
      • createSchemaOracleX.ddl
      • createTablespaceOracleX.ddl
      • dropSchemaOracleX.ddl
      • dropTablespaceOracleX.ddl
      where X is your Oracle version digit ('8' or '9').
    2. On your database machine, change to the directory where you copied the DDL scripts.
  10. Edit the table space creation script according to the instructions at the top of the file:
    • For Oracle 8i: Edit createTablespaceOracle8.ddl
    • For Oracle 9i: Edit createTablespaceOracle9.ddl
  11. Make sure that you are using the user ID that has administrator rights for the database system.
  12. If you do not want to create the schema in the default instance, set the ORACLE_SID environment variable.
  13. To create the table space, run the createTablespaceOracleX.ddl script, as described in the script header, where 'X' is your Oracle version digit (8 or 9).
    For test purposes, you can use the same location for all table spaces and pass the path as command line argument to the script, for example, on Windows systems, using Oracle 8i, user ID bpeuser, password bpepwd, database name BPEDB, and table space path d:\mydb\ts, enter:
    sqlplus bpeuser/bpepwd@BPEDB @createTablespaceOracle8.ddl d:\mydb\ts
    If you want to drop the table spaces, you can use the dropTablespaceOracleX.ddl script, where 'X' is your Oracle version digit (8 or 9).
  14. To create the schema, run the createSchemaOracleX.ddl script, where 'X' is your Oracle version digit (8 or 9).
    For example, on Windows systems using Oracle 9i, enter:
    sqlplus bpeuser/bpepwd@BPEDB @createSchemaOracle9.ddl
    If you want to drop the schema use the clearSchemaOracleX.ddl script to clear the schema, and the dropSchemaOracleX.ddl script to drop the schema.

Results

The Oracle database for process choreographer exists.



Searchable topic ID:   t2codbor
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/workflow/tasks/t2codbor.html

Library | Support | Terms of Use | Feedback