Configuring XA transactions

You must configure XA transactions after the Oracle database is installed and before you start the server.

Before you begin

The instructions in this topic must be performed after the Oracle database is installed and before you start the server.

About this task

XA is a two-phase commit protocol defined by the X/Open DTP group.

The following steps must be performed by a database user with SYS authority.

Procedure

  1. As the SYS user, enable the Oracle database for XA by switching to the Oracle user and then configuring the database by running the following script on the BPMDB database:
    ORACLE_HOME/javavm/install/initxa.sql
    For example:
    su - oracle
    sqlplus oracle_user_ID/oracle_password@oracle_instance_name @initxa.sql 
  2. Create the users and grant them access as described in the topic Creating users for Oracle databases in a network deployment environment on Windows.