5 Deprecated and Desupported Features and Parameters

This section describes the deprecated and no longer supported features of Oracle GoldenGate.

Release 21c (21.14.0.0.0) - May 2024

DBOPTIONS USEREPLICATIONUSER is deprecated for Microsoft SQL Server Replicat for Windows

With Oracle GoldenGate for Microsoft SQL Server release 21.14, the DBOPTIONS USEREPLICATIONUSER option is deprecated.

With Oracle GoldenGate for Microsoft SQL Server release 21.14, all SQL Server builds automatically set the connection with Replication=yes option and the functionality of DBOPTIONS USEREPLICATIONUSER remains the same as long as the SQL Server ODBC driver is version 17.8.1 or higher.

Release 21c (21.12.0.0.0) - December 2023

NonStop SQL/MX

Oracle GoldenGate will not support NonStop SQL/MX after Oracle GoldenGate release 21.12 and later.

Release 21c (21.4.0.0.0) - October 2021

USEODBC and USEREPLICATIONUSER options for the DBOPTIONS command have been deprecated for Oracle GoldenGate Replicat for SQL Server

The DBOPTIONS options of USEODBC and USEREPLICATIONUSER have been deprecated for Replicat. Replicat can continue to run with these parameters but they will be ignored and will be desupported in future. Functionality for USEREPLICATIONUSER is now automatic when using the Microsoft ODBC Driver 17 for SQL Server, version 17.8.1 or higher. Functionality for USEODBC is now the default and Replicat connections always use ODBC.

Release 21c (21.3.0) - August 2021

Oracle GoldenGate Classic Architecture is deprecated

Oracle GoldenGate Classic Architecture for Oracle database and heterogeneous databases DB2 z/OS, MySQL, SQL Server, and PostgreSQL is deprecated and may be desupported and unavailable in a future release. Oracle recommends using the Oracle GoldenGate Microservices Architecture.

CUSEREXIT for Extract is deprecated and will be desupported in future

The CUSEREXIT for Extract is deprecated and will be desupported in future releases.

Release 21c (21.1.0) - Initial Release May 2021

Oracle Database: Oracle GoldenGate Classic Extract is desupported
Oracle GoldenGate does not support classic Extract.
Oracle Database: Oracle GoldenGate Classic Architecture is deprecated

Oracle GoldenGate Classic Architecture for Oracle Database is deprecated and may be desupported and unavailable in a future release. Oracle recommends using the Oracle GoldenGate Microservices Architecture.

UDT protocol between Distribution Server and Receiver Server has been desupported

In Oracle GoldenGate Microservices Architecture 21c (21.1.0), the UDT protocol that the Distribution Server uses for sending trails files has been desupported.

Use the wss, ws or ogg protocol instead of UDT because this feature will be desupported in the next major Oracle GoldenGate release.

RMTTASK desupport and deprecation

The RMTTASK parameter is desupported for Oracle GoldenGate Microservices Architecture. The parameter has been deprecated for Classic Architecture and will be desupported for Classsic Architecture in future releases.

NO_OBJECTDEFS and NO_TRAILDEFS parameters are desupported

The NO_OBJECTDEFS and NO_TRAILDEFS parameters are desupported.

OPTIMIZE_PROGRESS_TABLE parameter is desupported

The parameter OPTIMIZE_PROGRESS_TABLE has been desupported for Oracle GoldenGate 21c and higher releases.

Oracle GoldenGate replication support for Oracle Sharding is deprecated

Oracle GoldenGate replication support for Oracle Sharding High Availability is deprecated with Oracle Database 21c and may be desupported in the future release. For Oracle Sharding in Database 21c, the Oracle GoldenGate support is limited to one pluggable database in a multitenant database.