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
-
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
andvector
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
, andtsvector
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.