WebSphere WebSphere Enterprise Service Bus, Version 6.0.1 Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Configuring an Oracle database

Follow these steps to configure an Oracle event database.

Why and when to perform this task

You must configure the Oracle event database prior to using the Common Event Infrastructure.

Steps for this task

  1. If you are using Oracle8i Database Release 8.1.7 and a type 2 JDBC driver, use the WebSphere administrative console to modify the Common Event Infrastructure data source Event_Oracle_JDBC_Provider to use the class path $ORACLE_HOME/jdbc/lib/classes12.zip.
  2. If you are using Oracle8i Database Release 8.1.7 and a type 4 JDBC driver, do one of the following:
    • Use the WebSphere administrative console to modify the Common Event Infrastructure data source Event_Oracle_JDBC_Provider to use class path $ORACLE_HOME/jdbc/lib/classes12.zip
    • Download the ojdbc14.jar file from http://www.oracle.com and place the file in the $ORACLE_HOME/jdbc/lib directory. (You do not need to modify the data source.)
  3. Create a database to use for the event database. When you create the database, select the appropriate character set:
    • For an Oracle 9 database, select Unicode (AL32UTF8).
    • For an Oracle 8 database, select UTF-8.

    If you are configuring the event database from an Oracle client, the client must be configured to communicate with this database instance. In the next step, specify the Oracle system identifier (SID) in the database response file; the default value is event.

  4. Create a database response file. A database response file is a text file that specifies parameters for configuring the event database. These parameters vary depending on the type of database being used.

    If you are installing multiple event servers using the same Oracle database, remember that table space names must be unique within a database instance. Therefore, you must modify the response file to specify different table space names for each event server you install.

  5. Run the database configuration scripts. The Common Event Infrastructure provides scripts for configuring the event database. These scripts generate customized, database-specific scripts for creating the database configuration using the parameters specified in your response file.
  6. Make sure the following environment variables are set:
    • ORACLE_HOME must be set to the Oracle installation directory.
    • PATH must include $ORACLE_HOME/bin and $ORACLE_HOME/lib.
    • LD_LIBRARY_PATH and LIBPATH must be set to $ORACLE_HOME/lib.
    • CLASSPATH must contain $ORACLE_HOME/jdbc/lib/ojdbc14.jar and $ORACLE_HOME/jdbc/lib/nls_charset12.zip.

Task topic

Terms of Use | Rate this page

Timestamp iconLast updated: 13 Dec 2005
http://publib.boulder.ibm.com/infocenter/dmndhelp/v6rxmx/index.jsp?topic=/com.ibm.websphere.wesb.doc\doc\tcei_install_configureOracle.html

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