WebSphere Process Server Version 7.0
with Oracle 10g & 11g Configuring for XA Recovery

Content

This document describes how to set up and configure WebSphere Process Server for distributed transactions (XA) using Oracle as the database product. It describes what is necessary to ensure transactional safety of WebSphere Process Server data, including transaction recovery with Oracle. In addition to the configuration information, this document also describes the required database privileges and the expected results during and after an XA recovery of WebSphere Process Server.

To provide real-life data, XA recovery was tested for failures occurring during the two-phase commit cycle between Oracle and WebSphere Process Server. In particular, failures during the prepare and during the commit phase were tested for appropriate recovery.

To ensure that XA recovery behaves as expected in a production environment of WebSphere Process Server and Oracle, it is important to configure the related XA and recovery settings correctly to ensure that no business data get lost in case of an unexpected failure like a sudden power outage.

All described steps were verified during real tests on systems in the IBM Böblingen test lab based on the following general available software versions:

* Red Hat Enterprise Linux 5.4
* WebSphere Process Server V 7.0.0.2
* Oracle 10g Release 2 (10.2.0.3.0) or (10.2.0.4.0) and
* Oracle 11g Release 1 (11.1.0.6.0) or (11.1.0.7.0)

(261,884 Bytes)

This document is produced by the WebSphere Business Process Management (BPM) test team in Böblingen, Germany.