Upgrading Oracle GoldenGate Microservices – GUI Based

Learn the steps to upgrade Oracle GoldenGate Microservices using the GUI.

Follow these steps to obtain the Oracle GoldenGate installation software and set up the directories for upgrade.

1. Download the latest Oracle GoldenGate Microservices 23ai software from the Oracle Technology Network or eDelivery.

2. Move the Oracle GoldenGate 23ai MA software to a staging folder and unzip it.

   For Linux, use the following example:

   $ mv /home/user/fbo_ggs_Linux_x64_Oracle_services_shiphome.zip /tmp
   $ cd /tmp$ unzip fbo_ggs_Linux_x64_Oracle_services_shiphome.zip

3. Upload the Oracle GoldenGate Microservices 23ai software to a staging location on the server where a previous release of Oracle GoldenGate Microservices exists.

4. Save the changes and return to the Service Manager Overview page.

5. Select the Action dropdown for the deployment and select Restart.

6. Log in to the Administration Service and click Action button in the Replicat section.

7. Click the Parameter File tab and change the value of the BATCHSQL parameter to double the value of BATCHESPERQUEUE. You must do this before starting Replicat. For example: BATCHSQL BATCHESPERQUEUE 40000000.

8. Log back into the Adminstration Service and start Extract and Replicat.

At this point, you should have a new Oracle GoldenGate 23ai MA home and any prior release homes of Oracle GoldenGate MA.

Upgrade the Service Manager

After installing the latest Oracle GoldenGate MA version, the next step is to upgrade the Service Manager:

1. Log into Service Manager from the URL: https://hostname:servicemanager_port

2. Select the ServiceManager link in the Deployments section of the Service Manager Overview page.

3. Click the pencil icon next to the Deployment Detail section to open the dialog box for editing the GoldenGate home path.

4. Update the GoldenGate Home path with the full path to the new Oracle GoldenGate home.

5. Click Apply.

6. Use the Action dropdown to restart the Service Manager.

Upgrade the Deployment

Deployments can be upgraded in the same step with the Service Manager or they can be upgraded at a later time after the Service Manager has been upgraded.

To upgrade a deployment:

1. Stop all Extract and Replicat processes gracefully:

   • Check for open (long running) transaction and Bounded Recovery as it may take longer to stop Extract gracefully.

   • If any unnecessary open transactions are visible, for example SEND EXTRACT group_name SHOWTRANS, then those transactions can be skipped or immediately forced to stop. In this case, a Bounded Recovery checkpoint can be retrieved using the following command:

     SEND EXTRACT group_name, BR BRCHECKPOINT immediate

2. Verify the current location of Oracle GoldenGate home directory from Service Manager.
   1. Login to the Service Manager: http://hostname:servicemanager_port
   2. Click the link to the deployment name in the Deployments section on the Service Manager Overview page. The deployment details are displayed.
3. Edit and update the the deployment with the location of the new Oracle GoldenGate Home directory.
   1. Click the pencil next to Service Manager Deployment Detail to edit the Oracle GoldenGate Home directory on the Details tab.
   2. Update the Oracle GoldenGate Home path with the complete path to the new Oracle GoldenGate home directory.
   3. Click Apply.
   4. Confirm that the Oracle GoldenGate Home path has been updated.
   5. From the left navigation pane of the Service Manager, select the deployment and then click Administration Service to open the Administration Service web interface.
   6. Log in and stop any Extracts and Replicats. Close the Administration Service web page and return to the Service Manager page.
4. On the Service Manager page, select the deployment name from the left navigation pane.
5. Click Configuration to modify the settings for the environment variables. With the Unified Build feature, the environment variables for ORACLE_HOME, LD_LIBRARY_PATH, and TNS_ADMIN need to be adjusted to the Oracle Database Client software within Oracle GoldenGate. Set the environment variables as:

   • ORACLE_HOME = $OGG_HOME/lib/instantclient

   • LD_LIBRARY_PATH = $OGG_HOME/lib:$OGG_HOME/lib/instantclient

   • TNS_ADMIN = Location of tnsnames.ora and sqlnet.ora

   • JAVA_HOME = $OGG_HOME/jdk

6. Save the changes and return to the Service Manager home page.
7. Save the changes and return to the Service Manager home page.
8. Select the Action dropdown for the deployment and select Restart.
9. Log back into the Adminstration Service and start any Extract and Replicats.