3 Enhancements

This section highlights the enhancements available with this release of Oracle GoldenGate.

Release 23ai (23.9) - July 2025

Bug 38013716: Generic - Support Iceberg tabletype for Snowflake streaming handler

Starting with this version of Oracle GoldenGate, Iceberg table type for Snowflake streaming handler is supported.

Bug 37680251: Generic - Data Streaming start by timestamp must start from the beginning of the transaction

Enhanced data streaming to start from the beginning of a transaction for data streaming by timestamp.

Bug 37817335: Generic - Print authusername in IAM deployment REST API logs authorization section

Enhanced the restapi.log to include the user name for Bearer authorization requests.

Bug 37945691: Oracle - Add an option to allow integrated Replicat to be created without a checkpoint table

Oracle GoldenGate supports adding integrated Replicat without checkpoint table, in special cases.

Bug 37807752: Oracle - Invalid or incorrect Auth Code received

Enhanced JWK time-to-live functionality to prevent services from becoming unresponsive when the JWK time-to-live expires.

Release 23ai (23.8.0.25.04) - April 2025

Bug 37275192: Db2 z/OS - Enhanced the memory manager to use Operator Commands, STOP and MODIFY

Enhanced the memory manager to use operator commands STOP and MODIFY to shut down the Extract process gracefully.

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 35938413: SQL Server - Start the SQL Server CDC Capture automatically from Extract

Enhanced the functionality for Oracle GoldenGate for SQL to start the SQL Server CDC Capture automatically from Extract.

Bug 37468430: SingleStoreDB - Add Certification with SingleStoreDB (on-prem) for versions 8.1, 8.5, 8.7, and 8.9

Added certification for on-premises SingleStoreDB for versions 8.1, 8.5, 8.7, and 8.9.

Bug 37468442: SingleStore Helios- Add Certification with SingleStore Helios (Cloud DB)

Added certification for SingleStore Helios - Current version available.

Release 23ai (23.7) - January 2025

Bug 37090212: PostgreSQL - Add SSL support for the native driver

Enhanced Oracle GoldenGate for PostgreSQL to provide SSL support for the native driver.

Add support for PostgreSQL version 17

Oracle GoldenGate supports PostgreSQL version 17.

Release 23ai - May 2024

Added new features to Oracle GoldenGate Configuration Assistant (OGGCA)

Oracle GoldenGate 23ai added the following new features for better user experience:

  • OGGCA is enhanced to allow configuring the following features for the Service Manager and deployment:

    • Enable and configure the StatsD server for the deployment and Service Manager

    • Enable and configure the Configuration Service for the deployment

    • Enhanced security configuration from OGGCA

  • Default environment variables are set for OGG_HOME and LD_LIBRARY_PATH

  • Additional configuration options have been provided for the following:

    • Integration with external IDP providers

    • Customization of authentication modes

    • Availability of a sample template of the response file

Added encryption support for user data in cache files and Bounded Recovery Persisted Data Files (PCDFs)

Oracle GoldenGate 23ai provides encryption support for user data included in cache files and Bounded Recovery persisted data files (PCDFs). For more information, see Secure Data in Transit.

Added support for automatic reconnection of parallel Replicat for application continuity

Added support for automatic reconnection of parallel Replicat with databases on connection failures to maintain application continuity.

Integrated OAuth/SSO with identity domains in OCI Identity and Access Management (IAM)

Added the following to improve and simplify the integration of OAuth/SSO with identity providers (IDP):

  • New OAM profile type

  • Validate and enable the authorization profile to automatically configure the confidential application and self-register the redirect URIs

Improved failure detection for distribution and target-initiated paths

Added WebSocket protocol and asynchronous receive thread to improve the network failure detection process for distributed and target-initiated paths.

Improved token-based authentication

Oracle GoldenGate 23ai now supports token-based authentication for IDP-enabled deployments. For this, token-access parameter has been added to the CONNECT and ADD CREDENTIALS commands. In addition, INFO CREDENTIALS command has been updated to display the token related information. For more information, see CONNECT, ADD CREDENTIALS, and INFO CREDENTIALS.

Improved performance monitoring

Added Integrated Diagnostics REST API to obtain performance data to diagnose performance issues related to integrated Extract, integrated Replicat, and parallel integrated Replicat. This is a replacement over the previously used Replication Performance Advisory Utility (UTLRPDAV).

For more information, see Integrated Diagnostics

Enhanced Functionality for Automatic Conflict Detection and Resolution (ACDR)

Automatic Conflict Detection and Resolution provides improved functionality for the following tasks:

  • Removing ACDR entirely from the table or removing ACDR column groups has less impact on the table as the ACDR related columns are marked as UNUSED columns. The decision to drop the columns can be made at a later time.

  • Starting with Oracle Database 23ai, using DBMS_REDEFINITION for ACDR related tables is supported. The DBMS_REDFINITION package can be used to remove unused columns or any other purpose for which the table needs to be reorganized.

See the following topics for details, Configure Latest Timestamp Conflict Detection and Resolution, Support for Online Redefinition, Removing Conflict Detection and Resolution From a Table, and Removing a Column Group.

Oracle Key Vault 21.8 is supported for trail file encryption

Oracle GoldenGate 23ai supports trail file encryption with Oracle Key Vault 21.8. See Using Oracle Key Vault with Oracle GoldenGate.