1. Transaction Manager for Microservices Developer Guide
  2. Upgrade to 24.4
  3. Upgrade to the Latest Enterprise Edition Using SQL Scripts

6.6 Upgrade to the Latest Enterprise Edition Using SQL Scripts

Run these steps to upgrade to the latest release of Transaction Manager for Microservices Enterprise Edition using SQL scripts only if you used Oracle Database to store the transaction logs in the previous release.

Prerequisites

  • Oracle Database is installed and running.
  • SQL*Plus or any other Oracle-compatible SQL tool is available to run SQL scripts on the Oracle Database.

  • Ensure that you have the following required privileges to perform this task if you are not a database administrator.

    • SELECT privilege on DBA_TABLE
    • CREATE SESSION
    • CREATE TABLE
    • CREATE PROCEDURE
    • EXECUTE ANY PROCEDURE

Do not use the instructions in this section in the following scenarios:

  • if you can grant the required privileges, such as ALTER and DELETE to the database user and if init containers are available your environment. In such scenarios, skip this section and see Upgrade to the Latest Enterprise Edition in Kubernetes Cluster.
  • if you used etcd or internal memory to store the transaction logs in a previous release of Transaction Manager for Microservices Enterprise Edition.
  • if you want to upgrade to the latest release of MicroTx Free.
To upgrade to Transaction Manager for Microservices 24.4 Enterprise Edition:
  1. Before you begin, run the MicroTx transaction coordinator in maintenance mode to back up cached data. See Back Up Cached Maintenance Data.
  2. Download the files to install the latest release of MicroTx. See Download the Installation Bundle.

    Ensure that you do not overwrite the installer files for earlier versions of MicroTx.

    The latest image of the transaction coordinator is available at installation_directory/otmm-24.4/otmm/image/tmm-24.4.tgz. In the next steps, you will use this file to update the existing transaction coordinator image.

  3. Load the transaction coordinator image to the local repository, tag the image, and then push the image. See Push Images to a Remote Docker Repository.
  4. Update the YAML file for the transaction coordinator with the name of the latest image in the repo. If you want to use the latest features, complete the required tasks to use these features, and then update the YAML file with the property values. See Configure the values.yaml File.
  5. Only if you are setting up a fresh Oracle Database, run the Setup_Microtx.sql file to create the required tables in the Database. Skip this step if you are upgrading the MicroTx coordinator with an existing Oracle Database. This file is available at installation_directory/otmm-RELEASE/otmm/dba_scripts.
  6. Run the 24.2.1_MicroTx.sql file to create an entry for the latest release. This file is available at installation_directory/otmm-RELEASE/otmm/dba_scripts.
  7. Start the transaction coordinator.

Parent topic: Upgrade to 24.4