Upgrading Oracle GoldenGate Microservices Using REST APIs

Learn how to upgrade Oracle GoldenGate MA to Oracle GoldenGate MA 19c (19.1.0) using REST APIs.

Follow these steps to perform the upgrade using REST APIs:

1. Download the latest Oracle GoldenGate MA 19c software from the Oracle Technology Network or eDelivery.

2. Upload the Oracle GoldenGate MA 19c software to a staging location on the server where a previous release of Oracle GoldenGate Microservices exists.

3. Unzip Oracle GoldenGate MA 19c software in the staging location.

   $ cd /tmp

   $ unzip ./fbo_ggs_Linux_x64_services_shiphome.zip

4. Untar the tar file that gets created after the unzip command:

   tar -xvf ggs_Linux_x64_Oracle_64bit.tar

5. Move into the unzipped files and execute the runInstaller command.

   $ cd ./fbo_ggs_Linux_x64_services_shiphome/Disk1

   $ ./runInstaller

6. For Software Location, specify where the new Oracle GoldenGate home will be located. This will not be the same location as the current Oracle GoldenGate home. Click Next.

7. Click Install to begin installing the new Oracle GoldenGate MA. When the installation is done, click Close.

8. At this point, you should have two Oracle GoldenGate MA home directories: one for your old home (12c or 18c) and a new home (19c).

Now, you are ready to update the Oracle GoldenGate MA home (OGG_HOME) for the Service Manager or deployments using REST API.

Upgrade a Service Manager

To upgrade the Service Manager, the following cURL command can be used to update the Oracle GoldenGate home:

curl -X PATCH \
  https://<hostname>:<port>/services/v2/deployments/ServiceManager \
  -H 'cache-control: no-cache' \
  -d '{"oggHome":"/opt/oracle/product/19.1.0/oggcore_1", "status":"restart"}'

Upgrade a Deployment

To upgrade a Deployment:

1. Stop all Extract and Replicats within the Administration Service.

2. Stop all Distribution Paths within the Distribution Service.

3. Run this simple cURL command to update the Oracle GoldenGate home:

   curl -X PATCH \
     https:// ://<hostname>:<port>/services/v2/deployments/<deployment name> \
     -H 'cache-control: no-cache' \
     -d '{"oggHome":"/opt/app/oracle/product/19.1.0/oggcore_1",
      "status":"restart"}'

   Note:

   You can confirm that the Oracle GoldenGate home was updated by looking at the process from the operating system for Service Manager. The Service Manager process should be running from the new Oracle GoldenGate home.

4. Start all distribution paths within the Distribution Server.

5. Start all Extracts and Replicats within the Administration Server.

Once the Service Manager or Deployment restarts, you are upgraded to the next version.