Configuring XA transactions

Draft comment:
This topic only applies to BAW, and is located in the BAW repository. Last updated on 2025-03-13 12:15

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.

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

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

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 
```
Create the users and grant them access as described in the topic Creating users for Oracle databases in a network deployment environment on Windows.