GoldenGate Free Release notes

Review release information before you install and work with GoldenGate Free. This document is accurate at the time of publication and is updated periodically with each new software release.

What's new in GoldenGate Free

Discover what's new in the latest GoldenGate Free release.

Feature Description
23ai core features This GoldenGate Free release also includes the latest core capabilities of Oracle GoldenGate 23ai. Learn more.
Connections GoldenGate Free now supports Oracle Database 23ai Free - Developer Release for use as a source or target connection, with the exception of Parallel Replicats.
Per-PDB Capture GoldenGate Free now supports per-Pluggable Database (per-PDB) capture. Oracle GoldenGate 23ai enables you to grant privileges for users at the PDB level. Root-level access using common user, c##ggadmin, is not available.
New recipe added Support for Active-Active replication is now available as a new recipe. An Active-Active database replication applies change events in both directions to keep databases synchronized. You can select this recipe when creating a pipeline. Explore recipes.
Quickstarts added Want step-by-step instructions to help you get started with one-way and active-active replication? Use these new quickstart articles:

What's supported

Visit Supported connection types to learn which Oracle Database and Oracle GoldenGate versions Oracle GoldenGate Free supports as source and target connections.

How to get help

Oracle GoldenGate Free is not supported by Oracle Support. Questions regarding GoldenGate Free can be posted in the GoldenGate Free Community Forum.

Licensing information

Visit Oracle GoldenGate Licensing Information to review detailed licensing compliance information for Oracle GoldenGate Free.

Source code availability

For third party technology that you receive from Oracle in binary form, which is licensed under an open source license that gives you the right to receive the source code for that binary, you can obtain a copy of the applicable source code from https://www.oracle.com/downloads/opensource/software-components-source-code.html.

For Helidon, visit https://github.com/helidon-io/helidon.

If the source code for the technology was not provided to you with the binary, you can also receive a copy of the source code on physical media by submitting a written request to:

Oracle America, Inc
Attn: Associate General Counsel
Development and Engineering Legal
500 Oracle Parkway, 10th Floor
Redwood Shores, CA 94065

Or, you may send an email to Oracle using the form located at: https://apex.oracle.com/pls/apex/f?p=34135:1::::::. Ensure your request includes:

The name of the component or binary file(s) for which you are requesting the source code
The name and version number of the Oracle product
The date you received the Oracle product
Your name
Your company name (if applicable)
Your return mailing address and email
A telephone number in the event we need to reach you.

We may charge you a fee to cover the cost of physical media and processing. Your request must be sent (i) within three (3) years of the date you received the Oracle product that included the component or binary file(s) that are the subject of your request, or (ii) in the case of code licensed under the GPL v3, for as long as Oracle offers spare parts or customer support for that product model.

Known issues

Learn about known issues within the current release version.

Unable to log in to GoldenGate Free when strong password policy is disabled

If you disable the strong password policy option during the installation process, then you may encounter an "Invalid username/password" error when logging in to the Oracle GoldenGate Free console.

Recommendation: To avoid this issue, ensure that the strong password policy option stays enabled (don't deselect it) during the installation process.

Parallel Replicat not supported for Oracle Database Free 23ai

Oracle GoldenGate Free doesn't support Parallel Replicats for Oracle Database Free 23ai sources or targets.

You can use Parallel Replicat for all other supported database versions.

GoldenGate Free uses only one deployment

Oracle GoldenGate Free only uses a single deployment. While it is possible to create multiple deployments, GoldenGate Free recognizes only the first deployment created during the initial installation. This deployment is referred to as the primary deployment.

GoldenGate Free doesn't recognize additional deployments created after the primary deployment. If you remove the primary deployment, then it is deregistered with GoldenGate Free. At this point, if a deployment is created and no primary deployment exists, then the new deployment becomes the primary deployment.

Don't delete a deployment while a pipeline is running

If you delete the deployment while a pipeline is running, then the error n[Object.keys(...)[0]] is undefined appears on the pipeline's Runtime page, and the pipeline's status changes to "Not started" on the Pipelines page.

Recommendation: Ensure that no pipelines are running if and when you decide to delete the deployment.

(Optional) Disable Distribution Service in GoldenGate Free installer

Since GoldenGate Free uses only one deployment, you can deselect Enable Distribution Service. The Distribution Service is only used when data must be replicated in a distributed environment (requiring muliple deployments).

You can leave the option selected for use with deployments not managed by GoldenGate Free .

Ignore nonsecure to secure replication option in GoldenGate Free installer

Oracle GoldenGate Free doesn't support multiple deployments, so you can ignore the "This non-secure deployment will be used to send trail data to a secure deployment" option on the Security Options screen of the GoldenGate Free Configuration Assistant.

Active-Active (bidirectional) replication issues

GoldenGate Free doesn't support the addition new tables, nor change the ACDR type, after the active-active pipeline starts. If absolutely necessary, you can either:

  • Create, configure, and start a new pipeline with the new tables added.
  • In the GoldenGate Free console:
    1. Stop the pipeline.
    2. Create a new table externally, such as sqlplus or sqldeveloper.
    3. Under Mapping, expand the schema and select new tables.
    4. Under Options, in Advanced Options and under Replicat, select DISCARD for Actions upon DML Error.
    5. Save the pipeline configuration and then restart the pipeline.