Oracle GoldenGate will require a checkpoint table when creating an integrated Replicat.

Any existing integrated Replicats must be rebuilt to include a checkpoint table. The ALTER REPLICAT command cannot be used to add a checkpoint table to an existing Replicat process that was created with NODBCHECKPOINT.

Auto-login property removed from the Oracle GoldenGate wallets

To enhance the security of Oracle GoldenGate wallets that store credential information (login information of Microservices users), the auto-login property of Oracle GoldenGate wallets has been removed.

As a result, after the deployment has been patched to Oracle GoldenGate release 19.25 and higher and started, rolling back to the previous Oracle GoldenGate release of 19.24 or lower, is not feasible as the password protected wallets cannot be converted back to auto-login wallets automatically.

A short-term workaround to get the information stored in the wallets before patching to Oracle GoldenGate Release 19.25 or higher, is to save the auto-login wallets from the earlier version and manually restore these wallets on a rollback.

Opatches bundled with JDK for Oracle

The JDK is now packaged in the Oracle GoldenGate patch starting release version 21.10 and 19.1.0.0.230418. Please note that only <GG_HOME>/jdk directory is updated with the GoldenGate patch releases. See Doc ID 2359395.1 for more information and additional references for updating JDK either through GoldenGate patch or independently.

You still have the option to install the latest JDK patch into <GG_HOME>/jdk directory independently at any time. See Doc ID 1492980.1 for more information.

Parameter TransactionErrorBehavior must be set to 2 while specifying data

For PostgreSQL Replicat to be able to handle the database error conditions appropriately the value of the parameter TransactionErrorBehavior must be set to 2. It is a required parameter for Oracle GoldenGate, which needs to be specified inside the odbc.ini file under the DSN. Following is a sample DSN specifying the parameter:

[ODBC]
IANAAppCodePage=4
InstallDir=/u01/ggate

[pgdsn]
Driver=/u01/ggate/lib/GGpsql25.so
Description=DataDirect 7.1 PostgreSQL Wire Protocol
Database=mypgdb
HostName=mypghost
PortNumber=5432
LogonID=mypguser
Password=**********
TransactionErrorBehavior=2

To know more, see https://media.datadirect.com/download/docs/odbc/allodbc/index.html#page/odbc/transaction-error-behavior.html

DEFERAPPLYINTERVAL not working as expected for PostgreSQL Replicat

If the time zone is not same for the database and operating system, then Replicat waits until the local GMT time of the source system is greater than record commit timestamp + DEFERAPPLYINTERVAL delay.

Replicat is unable to identify the checkpoint table when created in mixed case after Replicat restart

The checkpointtable name must be in lower case without quote and without any special character in it.

Oracle GoldenGate Configuration Assistant (OGGCA) on Windows does not run if the Oracle GoldenGate home directory name or OGG_HOME has space in it, for example OGG HOME.

The INFO HEARTBEATTABLE command for SQL Server now reports heartbeat frequency interval, purge frequency interval, and retention time.

For SQL Server, the default QUERYTIMEOUT has been extended from 30 seconds to 300 seconds.

Extract for SQL Server will abend if it detects a difference in table structure between the source table and the Change Data Capture table.

For SQL Server, TLS 1.2 connection support, if enabled, is provided automatically by the Extract and Replicat.

Oracle GoldenGate for MySQL has a dependency on OpenSSL library, so availability of OpenSSL library is a prerequisite.

Linux: Set LD_LIBRARY_PATH to include the path where OpenSSL library is installed.

Windows: For MySQL 8.0 and higher, the OpenSSL library is shipped with MySQL server and is kept in the \bin directory of the MySQL home directory. You must ensure that the location of the OpenSSL is added to the path environment variable.

For example, D:\path\to\MySQLServer_install_dir\bin directory needs to be added to the PATH environment variable.

Alternatively, you can install the latest MySQL C++ connector (MySQL 8.0 or greater), which contains OpenSSL library and make sure that the location of the OpenSSL is added to the path environment variable. For example, C:\Program Files\MySQL\Connector C++ 8.0\lib64 directory needs to be added to the PATH environment variable.

With MySQL 5.7 or less, you need to install the latest MySQL C++ connector (MySQL 8.0 or greater), which contains the OpenSSL library and make sure that location of the OpenSSL is added to the PATH environment variable. For example: C:\Program Files\MySQL\Connector C++ 8.0\lib64 directory needs to be added to the PATH environment variable.

Oracle GoldenGate for MySQL 8.0 has a dependency on OpenSSL library so the availability of this library is a prerequisite. You need to ensure that the library is installed on the system running Oracle GoldenGate and path to this library is set appropriately.

Constraints for Oracle GoldenGate user name have been removed but the maximum length is 512 characters. For Basic and Certificate type users there are no constraints on special characters for the user name in REST API.

However, in the Microservice Architecture web interface, the user name can only include specific special characters for a Basic type user. These characters are:

at sign (@), period (.) , dash (-), comma (,), underscore (_), number sign (#), dollar sign ($), plus sign (+), backslash (\), slash (/), equal sign (=), less than sign (<), or greater than sign (>).

After Extract update, if a newer trail file format is specified then the primary Extract will automatically rollover to the next trail file and writer in the specified trail file format. There is no need to run the ALTER EXTRACT ETROLLOVER command.

If the target is Oracle Replicat 19c release, +INF, and -INF are applied properly. For all other databases including older Oracle Replicat, 0 value is applied.

This feature is enabled automatically if needed and you no longer need to specify TRANLOGOPTIONS INCLUDEREGIONID. For non-Oracle target, use TRANLOGOPTIONS INCLUDEREGIONIDWITHOFFSET to convert region ID to time offset from UTC.

(MySQL only) Capture silently ignores the binlog events that are not written in the ROW format instead of abending when it detects a binlog_format other than ROW.