As Oracle GoldenGate is constantly improving, and with the exciting release of version 23ai, some features are being phased out or are no longer supported. It’s important for users to be aware of these changes to help ensure a seamless transition and prevent any hiccups along the way.

I understand that it’s easy to forget to read through release notes, so I want to make things easier for you. Here’s a friendly summary of the key updates you need to be aware of when upgrading to 23ai:

Database Options

• DBOPTIONS USEREPLICATIONUSER: The DBOPTIONS USEREPLICATIONUSER option has been deprecated. The functionality remains the same as long as the SQL Server ODBC driver is version 17.8.1 or higher, as all SQL Server builds automatically set the connection with Replication=yes.

Replicat Functionality

• Integrated Replicat: Integrated Replicat is deprecated in Oracle GoldenGate 23ai. As an alternative, users should transition to using parallel Replicat.

Architecture

• Oracle GoldenGate Classic Architecture: Oracle GoldenGate 23ai no longer supports the Classic Architecture. This is a big one, and we have a Migration Unitily to help you move from Classic to Microservices architecture.

Parameters

Several parameters have been desupported in Oracle GoldenGate 23ai:

• FILTERTABLE: The FILTERTABLE parameter has been replaced with the EXCLUDEFILTERTABLE parameter, which provides the same functionality.
• GETREPLICATES
• GETAPPLOPS
• IGNOREREPLICATES
• IGNOREAPPLOPS
• SHOWSYNTAX

Encryption

• Blowfish Encryption: The Blowfish encryption algorithm is no longer supported in Oracle GoldenGate 23ai.

Trace Table Functionality

• The trace table functionality for Oracle databases has been removed. Consequently, the following parameters and commands are also desupported:
  • Parameters:
    • TRACETABLE
    • NOTRACETABLE
  • Commands:
    • ADD TRACETABLE
    • DELETE TRACETABLE
    • INFO TRACETABLE

Trail Files

• Six-Digit Trail File: Support for six-digit trail files has been removed.

Security

• User ID and Password in Parameter Files: The use of userid and password directly in the extract and replicat parameter files is no longer supported. Instead, you must use the useridalias option.

TimesTen Architecture

• TimesTen Scaleout Architecture: Starting with Oracle GoldenGate 23ai, support for the TimesTen Scaleout architecture has been removed. If you use TimesTen versions 18.1 or 22.1, you must use Oracle GoldenGate 21c to deliver to TimesTen Scaleout architecture.

Key Takeaways

• Oracle GoldenGate 23ai introduces significant changes, including removing the Classic Architecture and Integrated Replicat.
• Users should review their configurations and parameter files to address deprecated and desupported items.
• It is important to transition to the suggested alternatives such as parallel replicat and the useridalias option.

Staying up to date with these changes can really help you plan your upgrades smoothly and keep your Oracle GoldenGate environments running strong and stable. It’s a great way to ensure everything performs at its best! Always check the official release notes before upgrading or applying a patch.

https://docs.oracle.com/en/middleware/goldengate/core/23/release-notes/deprecated-features.html