1 Introduction

This chapter introduces the Release Notes for Oracle GoldenGate for Big Data12c (12.3.0.1).

Topics:

1.1 Latest Release Information

This document is accurate at the time of publication. Oracle will update the release notes periodically after the software release. You can access the latest information and additions to these release notes on the Oracle Technology Network at:

http://www.oracle.com/technetwork/indexes/documentation/index.html

1.2 Purpose of this Document

This document contains the release information for Oracle Fusion Middleware Release for Oracle GoldenGate for Big Data.

Oracle recommends you review its contents before installing, or working with the product.

1.3 System Requirements and Specifications

Oracle GoldenGate follows the Fusion Middleware system requirements and certifications for production environments. For more information, see http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html.

1.4 Bugs Fixed and Enhancements

This chapter describes the bugs fixed and enhancements at the time of release.

The Bug number is the number of the BugDB ticket. For questions on specific tickets or issues, consult Oracle Support.

1.5 Product Documentation

For complete documentation on Oracle GoldenGate, go to http://docs.oracle.com/goldengate/c1230/gg-winux/index.html.

1.6 Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support at https://support.oracle.com

1.7 Licensing Information

Licensing information for Oracle Fusion Middleware is available at:

https://shop.oracle.com

Detailed information regarding license compliance for Oracle Fusion Middleware is available at:

Licensing Information

1.8 Downloading and Applying Required Patches

Downloading Patches

Go to My Oracle Support to download the latest software patches.

https://support.oracle.com

See the README file in the patch distribution for up-to-date information on the software fixes provided by the patch.

To download and install the latest software patch:

  1. Login to My Oracle Support.
  2. Click the Patches & Updates tab.
  3. Under the Patch Search tab, select Product or Family (Advanced Search), and select the Include all patches in a product family check box.
  4. Enter Oracle GoldenGate as the product, select the platform and release, and click Search.

The list of currently available patches for Oracle GoldenGate is returned.

For SQL Server CDC Extract you may need these software patches:

  • For SQL Server 2012, 2014, and 2016, Microsoft has identified and fixed an issue where some UPDATE operations may be written incorrectly to a CDC staging table as an INSERT followed by a DELETE, rather than a DELETE/INSERT pair. This may cause downstream replication issues, such as a primary key violation, therefore Oracle recommends that you apply the Microsoft fix for this issue: https://support.microsoft.com/en-us/help/3030352

  • For SQL Server 2016, prior to enabling supplemental logging, ensure that you have patched the SQL Server instance based on the following bug fix from Microsoft: https://support.microsoft.com/en-us/help/3166120/fix-could-not-find-stored-procedure-sys.sp-cdc-parse-captured-column-list-error-in-sql-server-2016 If the instance is not correctly patched with the Microsoft fix, issuing ADD TRANDATA against a table for the database may incorrectly report that supplemental logging succeeded when it may not have; therefore no records are captured for that table.

1.8.1 Applying this Patch

You must follow the existing upgrade procedures to overlay the old binaries with the new binaries. In addition, you must rerun ADD TRANDATA for each table that is already enabled for TRANDATA using these steps:
  1. Stop all Oracle GoldenGate processes
  2. Follow normal upgrade procedures for binary replacement though do not start any Oracle GoldenGate processes, see Upgrading to Release 12c (12.3.0.1) for Heterogeneous Databases in Using Oracle GoldenGate for Heterogeneous Databases.
  3. Manually stop the SQL Server CDC Capture job for the database. If the job is processing a large transaction, it may take some time before it actually stops.
  4. Ensure that the Extract is stopped.
  5. Using GGSCI, run ADD TRANDATA again for every table hat you previously enabled it for.

    Important:

    Do not run the DELETE TRANDATA command.

  6. Manually restart the SQL Server CDC Capture job.
  7. Manually restart the Oracle GoldenGate processes (Extract, Replicat, MGR, and so on.)

1.9 Upgrade

There are two upgrade paths that you can choose from to upgrade to Oracle GoldenGate for Big Data 12c (12.3.1.1) and both are described in Installing and Upgrading Oracle GoldenGate for Big Data.