Oracle GoldenGate Microservices are available from a single console

Oracle GoldenGate web interface displays all Oracle GoldenGate processes and Microservices from a single console. Logging in to each Microservice separately, is not required. This implies that you can access Extract, Replicats, Distribution Service Paths, Receiver Service Paths, Data Streams, and performance metrics from a single window console.

Bug 37236254: Generic - Change default trail file size from 500MB to 2GB

Updated the default trail file size from 500MB to 2GB.

Bug 38080969: Generic - Extract should fail with Parse error when second BRDIR is present in the Extract param file

Extract will not allow multiple BRDIR entries in the parameter file. If more than one BRDIR parameter is defined, then Extract will exit with a parse error.

Bug 37909236: MariaDB - Remove the requirement for MariaDB binlog_annotate_row_events=OFF

Starting with this version of Oracle GoldenGate, the requirement to set binlog_annotate_row_events to OFF has been removed for MariaDB.

Bug 37757820: Generic - Enable NOCHECKUNIQUEKEYS as default for BATCHSQL for all Non-Oracle AI Databases

Enabled NOCHECKUNIQUEKEYS as default for BATCHSQL for all non-Oracle AI Database.

Bug 29709965: MySQL - Extract to skip XA transactions and log a Warning instead of Abend

Changed the functionality in Oracle GoldenGate Extract for MySQL to skip XA transactions with a warning, instead of abending.

Bug 37465578: MySQL - Change the default capture for Extract CDC to be remote capture

Changed the default capture of Oracle GoldenGate for MySQL from local to remote capture for Linux-x64 platform.

Bug 37581809: Oracle - Allow IR to run with nodbcheckpoint

All Replicats are required to create and maintain a database checkpoint table, which serves as a mechanism for ensuring data consistency and facilitating recovery processes. The only exception to this requirement is the integrated Replicat. However, it is strongly recommended that you create and maintain a checkpoint table for the integrated Replicat.

Bug 37643197: SQL Server - Upgrade odbcinst.ini contents to the absolute path and driver descriptions

When upgrading an Oracle GoldenGate deployment for SQL Server to Oracle GoldenGate 23.7 from the previous versions or the 21c release using OPATCH, you must reset the contents of the odbcinst.ini file. For details on performing this task, see Upgrading Oracle GoldenGate Microservices GUI.

Bug 36862037: SQL Server - Standardize the SQL Server driver string in odbcinst.ini

Beginning with Oracle GoldenGate 23.6, the provided ODBC driver for SQL Server changed from libmsodbcsql-18.3.so.2.1 to libmsodbcsql.so and the driver’s name in the odbcinst.ini file has changed from ODBC Driver 18 for SQL Server to Microsoft ODBC Driver for SQL Server.

When patching an Oracle GoldenGate deployment for SQL Server from version 23.4 or 23.5 to Oracle GoldenGate 23.6 or later, you must update the contents of the odbcinst.ini and odbc.ini (if exists) files.

For details on performing this task, see Patching Oracle GoldenGate for SQL Server.

Bug 37298528 - MySQL: Make TRANLOGOPTIONS TRACKSCHEMACHANGES enabled by default

Enhanced TRANLOGOPTIONS TRACKSCHEMACHANGES option to be enabled by default.

Bug 37539434: Oracle - All Replicats without checkpoints are desupported

The creation of integrated and classic Replicat without checkpoint tables is not supported in Oracle AI Database. Additionally, any Replicats that were created without the checkpoint tables, will not start successfully.

For existing Replicats to run successfully, you must alter the Replicat to add a checkpoint table or add the checkpoint table to GLOBALS and then restart the Replicat. See ADD REPLICAT CHECKPOINTTABLE in the Command Line Interface Reference for Oracle GoldenGate for details.

Bug 35569409: PostgreSQL - Use Microservices Architecture task scheduler to update the heartbeat tables instead of relying on cron job

Configured an Administration Service task to update the heartbeat table to avoid replying on the cron job to do it.

Oracle GoldenGate does not need the OGG_SERVICEMANAGER_ID environment variable to be set for using the command line utilities that access database credentials

In Oracle GoldenGate 23.5 release, there is no requirement to set up the OGG_SERVICEMANAGER_ID environment variable for using command line utilities that access database credentials. This is required in the Oracle GoldenGate 23.4 release.

MySQL - Removed the remote (RMTTRAIL) option from the WebUI

For MySQL, the Remote button that was used for adding an Extract, has been removed from the WebUI.

Behavior change in Oracle GoldenGate

Oracle GoldenGate introduces the following feature, which impacts the behavior of configuring and using Oracle GoldenGate:

Microsoft ODBC Driver 18 for SQL Server

Oracle GoldenGate for SQL Server now packages the Microsoft ODBC Driver 18 along with the Oracle GoldenGate for SQL Server installation, and database connections will use this driver by default.

Behavior change in Oracle GoldenGate

Oracle GoldenGate features for Oracle AI Database

User roles to grant role-based privileges for Oracle AI Database

Oracle GoldenGate for Oracle AI Database has introduced user roles to grant role-based privileges.

For details, see the Grant User Privileges topic in Oracle GoldenGate Microservices Documentation.