3.7 Set Up Oracle Database as Data Store

Create a data store for MicroTx to store the transaction logs. You can use either etcd or Oracle Database as the data store.

Skip this section if you want to set up etcd as data store. See Set Up etcd as Data Store.

Before installing MicroTx, you must 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.

Topics:

• Grant Privilege to Run Stored Procedures
  The MicroTx coordinator creates a stored procedure when the service starts. If the Oracle Database user does not have the permission to create and run stored procedures, the service does not start.
• Get Autonomous Database Client Credentials
  MicroTx supports using Oracle Database as a persistent store to keep track of the transaction information.
• Create a Kubernetes Secret for Oracle Database Credentials
  MicroTx supports using Oracle Database as a persistent store to keep track of the transaction information.