3.6.1 Prerequisites

Create separate schemas for MicroTx Distributed Transactions and MicroTx Workflows to persist data in Oracle Database.

Before setting up Oracle Database as data store for MicroTx Distributed Transactions and MicroTx Workflows, complete the following prerequisites:

• Install and configure a data store. Ensure that you set up the required networking rules to allow communication between the transaction coordinator and the data store. For details about setting up the Oracle Database, refer to the documentation that is specific to the database that you want to set up.

• Ensure that you have the required permissions to create tables in the database. When you install MicroTx, the service creates the required tables in the database. So MicroTx requires certain details about the database.

• If you use Oracle Database for persistence of data in both MicroTx Distributed Transactions and MicroTx Workflows, avoid using the same schema user for both. Create separate schemas for MicroTx Distributed Transactions and MicroTx Workflows. You can use the same Oracle Database instance, but ensure that the user schema is different.