Modify the eventmanagement.properties file under appserver/domains/domain1/jbi/config.
Modify the DatabaseType to ORACLE.
Change the AlertTablename to EMHOSTNAMEVistastccom8080.
This step is required as the default name, EVENTMANAGEMENTHOSTNAMEistastccom8080, exceeded Oracle's 30-character limit for table names.
Change the DBJndiName to OracleXPDB.
You create this in the Admin Console; this is noted in step 2.
Change PersistenceEnbled to true.
Using Enterprise Manager, set the values for DatabaseType, DBJndiName, and PersistenceEnabled in the normal Alert Management Config Agent.
The database scripts should probably be run before enabling persistence. The table name must be changed in the file manually.
Create the JDBC connection pool and resource in the Sun Java System Application Server Admin Console.
Add the location of classes12.zip to the classpath, JVM Settings->Path Settings->Classpath Suffix, and then restart the domain.
This is needed to get the datasource for Oracle.
Create the Connection Pool for Oracle.
Enter a name, such as OracleXPPool, but this name can be your choice.
Select javax.sql.DataSource for the Resource Type.
Select Oracle for the Database Vendor.
Set the appropriate properties:
User: eventdb_user
DatabaseName: orcl
This and other database specific configurations may change depending on how you configured the Oracle database.
Password: eventdb_user
ServerName: hostname
This is the server where the database is running.
PortNumber: 1521
URL: jdbc:oracle:thin:@hostname:1521:orcl
This URL may actually override the other settings; it should match the other settings.
Create the JDBC Resource.
Create the user, tables, etc. needed for alert persistence and journaling manually.
This is automatically done for Derby.
There are database scripts that are packaged in the jbi_rt.jar file under appserver/jbi/lib. However there are some errors, so you need to be correct these scripts manually.
The example scripts have been modified to work with an Oracle 10 GB database; see Oracle Script Examples.
Run the create_event_store_user.sql and create_event_store_schema.sql scripts, in that order, with the system (admin) user.
Corrections made in this example:
Set the absolute path to tablespace data files (database installation dependent)
Modify the command to match Business Process persistence
Comment out the second data file
Move the comments
Fix the table name references to match user schema and table name, which were set above in eventmanagement.properties
Fix the column reference; that is, change the second column name from event_timestamp to timestamp
Change the datatype from timestamp to decimal
Fix the reference for sequence