IBM WebSphere Process Server V6.1 Oracle Database Configuration Guide

About this manual

This IBM Redpaper explains how to configure WebSphere Process Server V6.1 with an Oracle database. It covers the required environment preparation, database user creation, XA configuration, and the necessary JDBC settings, assuming the reader already has basic knowledge of WebSphere Process Server.

The guide provides concrete command examples for creating Oracle users, granting privileges, enabling the Oracle JVM, and setting up the various schemas used by WebSphere components such as CEI, BPC, and messaging engines. It also includes notes on space planning, driver installation, and troubleshooting XA errors.

What's inside

• Introduction
• Scope of the guide
• Test topology
• Connectivity choices (JDBC vs OCI)
• High‑level configuration steps
• Preparing the environment
• Creating the Oracle database and users
• Configuring the Oracle JVM
• Configuring XA transactions
• Messaging engines data stores

Specifications

Frequently asked questions

What JDBC driver should be used with WebSphere Process Server V6.1?

Download the latest supported Oracle JDBC drivers from the Oracle website and copy them to the server, e.g., /opt/ProcServer1/OracleDrivers.

How do I grant Java privileges to a new Oracle user for WebSphere Process Server?

Run the command `grant javauserpriv to ;` as SYS after creating the user.

How is XA support enabled for the Oracle database?

Execute the script `/javavm/install/initxa.sql` and run the required GRANT statements for XA views.

What schemas are required for WebSphere Process Server?

Schemas such as WPCDB, CEIDB, SCASYSMSG, SCAAPPMSG, CEIMSG, BPCMSG, BPCDB, and ESBLOG are created with specific privileges.