1. Release Notes
  2. Default Behavior Changes

4 Default Behavior Changes

This section describes the default behavior changes made to Oracle GoldenGate in relation to the last release..

Release 23ai (23.5) - July 2024

Oracle GoldenGate 23ai 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 23ai (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 23ai (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.

Release 23ai (23.4.2) - June 2024

Behavior change in Oracle GoldenGate 23ai

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

Microsoft ODBC Driver 18 for SQL Server

Oracle GoldenGate 23ai 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.

Release 23ai - May 2024

Behavior change in Oracle GoldenGate 23ai

Oracle GoldenGate 23ai introduces the following features, which impacts the behavior of configuring and using Oracle GoldenGate:

  • In OGGCA, you must use the #pkcs8 format to upload server, client, and rootCA certificates. Uploading wallets (#pkcs12) is not supported. Fore more information, see About Service Manager.

  • When setting up Oracle database 23ai users for Oracle GoldenGate, make sure to use Oracle GoldenGate user roles to assign privileges. Fore more information, see Grant User Privileges for Oracle Database 23ai and Higher.

  • Support for Oracle Boolean and vector data type for Oracle database. Fore more information, see Oracle: Details of Support for Oracle Data Types and Objects.

  • Support for PostgreSQL pgvector extension, array, tsquery, and tsvector datatypes.

  • Only per-PDB Extract is used for Extract rather than root-level Extract except for Downstream Capture, where rool-level Extract is configured.

  • Using Integrated Diagnostics rather than ULT_RPADV Diagnostics integrated in Oracle GoldenGate 23ai.

Oracle GoldenGate 23ai features for Oracle Database 23ai

User roles to grant role-based privileges for Oracle Database 23ai

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

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