GoldenGate Studio Free Release notes
Review release information before you install and work with GoldenGate Studio Free. This document is accurate at the time of publication and is updated periodically with each new software release.
What's new in GoldenGate Studio Free
Discover what's new in the latest GoldenGate Studio Free release.
| Feature | Description |
|---|---|
| 23ai core features | This GoldenGate Studio Free release also includes the latest core capabilities of Oracle GoldenGate 23ai. Learn more. |
| Connections | GoldenGate Studio 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 Studio 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 Studio Free supports as source and target connections.
How to get help
Oracle GoldenGate Studio Free is not supported by Oracle Support. Questions regarding GoldenGate Studio Free can be posted in the GoldenGate Studio Free Community Forum.
Licensing information
Visit Oracle GoldenGate Licensing Information to review detailed licensing compliance information for Oracle GoldenGate Studio 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 Studio 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 Studio 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 Studio 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 Studio Free uses only one deployment
Oracle GoldenGate Studio Free only uses a single deployment. While it is possible to create multiple deployments, GoldenGate Studio Free recognizes only the first deployment created during the initial installation. This deployment is referred to as the primary deployment.
GoldenGate Studio Free doesn't recognize additional deployments created after the primary deployment. If you remove the primary deployment, then it is deregistered with GoldenGate Studio 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 Studio Free installer
Since GoldenGate Studio 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 Studio Free .
Ignore nonsecure to secure replication option in GoldenGate Studio Free installer
Oracle GoldenGate Studio 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 Studio Free Configuration Assistant.
Active-Active (bidirectional) replication issues
GoldenGate Studio 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 Studio Free
console:
- Stop the pipeline.
- Create a new table externally, such as sqlplus or sqldeveloper.
- Under Mapping, expand the schema and select new tables.
- Under Options, in Advanced Options and under Replicat, select DISCARD for Actions upon DML Error.
- Save the pipeline configuration and then restart the pipeline.