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
- 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.
- 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.)
- 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.
- 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.
- 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.
- 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.