Release Notes for Oracle GoldenGate Studio
This section outlines the new features that are being introduced in the release, features that have been enhanced, and changes to existing features.
Support for the use of an ampersand (&) with multiline parameters when using
SQLEXEC was added. For example:
SQLEXEC "Insert into SQL_SSYSTEM Select SXRSNXT_TIME_SEQ.nextval, cnt || ' records were relicated after ' || SXRSNXT_TIME_SEQ.currval * 3 || ' seconds',SYSDATE from (Select count(*) cnt from SXRSNXT_SQL_NOTOKENS)" EVERY 3 SECONDS &
The Consolidation and Distribution solution templates are introduced.
Support for the DB2 LUW database replication was added.
The ability to scale Deployment profiles diagram information to one replication path (unidirectional or bidirectional) in the Deployment Profile Editor was added.
The ability to reverse engineer existing Oracle GoldenGate artifacts (parameter files, database objects) so that existing environment configuration can be created that can be further designed and deployed was added.
REPERROR parameter with the
TRANSABORT option is not supported.
Big Data System and
Teradata as target database.
DB2 z/OS as source and target database.
MySQL as repository database.
Support for Oracle Data Pump which enables very high-speed movement of data and metadata from one database to another.
Support for Automatic Coordination for Initial Load with Oracle GoldenGate CDC process.
Support for Consolidation of Capture where Oracle GoldenGate Studio generates a single capture for a single database. This result in performance improvement.
Support for single SUPERVISOR user. Oracle GoldenGate Studio support only one SUPERVISOR user that is created during repository creation is responsible for adding, modifying, and deleting other users. The SUPERVISOR user can access the Security Navigator window. Non SUPERVISOR users can only change their own password.
Support for heterogeneous database. In the current release
MySQL are supported as source and target database.
Oracle GoldenGate Studio requires
JAgent installation as Oracle GoldenGate Studio interacts with Oracle GoldenGate through
JAgent. Also, for features like creating backup directories in goldengate
JAgent should be in the same system as Oracle GoldenGate. All Oracle GoldenGate Installing and Configuring Guides that include installation prerequisites and instructions are found at
For questions on specific bugs or ticket numbers, consult Oracle Customer Support. SR is the Oracle Support SR number, and BugDB is the bug identification number.
Bug 24515376 - OracleGoldenGate Studio instance connection to remote host always uses localhost
An issue where the Oracle GoldenGate instance connection to remote host used localhost regardless of the
Host Name setting in Oracle GoldenGate instance connection was fixed.
Bug 23234498 - Manage secondary truncation point option always appends with
An issue where the manage secondary truncation point option appends the
tranlogoptions was fixed. You can disable the parameter by selecting the thick line from the menu, which is the first menu item. The line represents spaces, which is the disabling option.
Bug 22809171 - Mapping PI shows
INSERTAPPEND parameters for MySQL tables
An issue where the mapping displayed invalid parameters like
INSERTAPPEND for MySQL tables or databases was fixed. The
INSERTAPPEND parameter was removed from the Mapping Editor. It is only available for Classic Replicat in the tuning category.
Bug 22734341 - Oracle GoldenGate Studio does not show an option for Integrated Extract or Replicat with RDBMS 188.8.131.52
An issue where the properties screen does not show an option for Integrated Extract or Integrated Replicat with Oracle Database 184.108.40.206 was fixed. The Integrated Replicat and Integrated Extract are enabled for Oracle Database 11g database. You should use these features with Oracle Database 220.127.116.11 and later versions. A warning message will be added to the message log if you are using Integrated Extract with Oracle GoldenGate release 11.2.1 and earlier or Integrated Replicat with Oracle GoldenGate release 18.104.22.168.0 and earlier.
For questions on specific bugs or ticket numbers, consult Oracle Customer Support.
SR is the Oracle Support SR number, and
BugDB is the bug identification number. The information in this section is divided into the following releases:
Bug 25531499 - Chinese characters do not display correctly
When a Chinese locale is set, the correct help content is not displaying correctly in the UI.
Bug 24911786 - Error status is not updated in Oracle Data Pump tabIn Oracle Data Pump method, if the remote link (DB link) is empty or an incorrect remote link is provided, no error message is shown during deployment and the status is shown as Finished.
Bug 24421874 - Drop repository option does not show Oracle GoldenGate Studio schema option in enabled stateWhen the Drop Repository option in RCU facility is selected, the checkbox to select Oracle GoldenGate Studio schema in the following step is not enabled.
Bug 22537513 - To successfully launch RCU, JDK should be local and fully accessible
To launch RCU successfully from
oggstudio/oracle_common/bin location, you should have full permission to access JDK 8 which is mentioned in the environment variable. It is safe to point to a local JDK installation rather than a remote JDK installation. RCU will throw JAVA exception if it could not access the JDK.
Bug 22844671 - Error message displayed during deployment for backup of file
The error message
GGSTU-60009: Unable to take backup of the file is displayed while deploying a solution with older version of JAgent. Using the latest version of JAgent is recommended.
Bug 23232534 - Table exclude and Map exclude behavior
When you exclude table on source side a
tableexclude parameter is written on source side but corresponding map statements are not be written to target side. Similarly, when you exclude table on target side a
mapexclude parameter is written on target side , but corresponding table statements are not written to source side
Bug 24403645 - Oracle Data Pump does not support wildcard mapping
Wildcard mapping are not supported with Oracle Data Pump. No errors are shown during deployment but the data on target side are not loaded.
Bug 24529782 - Validate profile fails with error code GGSTU-60031, GGSTU-60001, and GGSTU-60002
The validate profile fails with error code
GGSTU-60031: Rest Service Failure. Unable to get status Connection refused,
GGSTU-60001: Unable to deploy as rest api service failed, and
GGSTU-60002: Unable to deploy as rest api service failed. java.net.ConnectException: Connection refused.
Bug 23224813 - Oracle GoldenGate Studio does not display any error while deleting assigned SQL Server or MYSQL database connection
Oracle GoldenGate Studio does not display an error when you try to delete a SQL Server or MySQL database connection that is already assigned to Deployment profile from Resources Navigator. The resource is not deleted.
Bug 23196883 - Oracle GoldenGate Studio does not generate default parameters when the instance database type is changed
When you create an Oracle GoldenGate instance with the Oracle database type, Oracle GoldenGate Studio generates the parameter file properly. However, when database type has been changed to some other database type, like SQL Server, Oracle GoldenGate Studio does not generate default parameter file for the changed Oracle GoldenGate instance database type.
You can workaround this by changing the database type in the Oracle GoldenGate Instance Resource dialog and dragging and dropping that resource into the diagram again. The Properties Inspector is then refreshed and the proper files will be generated.
Bug 22906453 - MSSQL remote capture should show a warning message
No warning message is displayed if you select the Target only, Hub, Target, and Hub Only templates without
The Deployment History tab is not populated.
The Deployment Profile wizard does not allow you to deselect the enable initial load option. However, you can disable the initial load prior to deployment by going to the Deployment Profile Overview subtab (next to Deployment View subtab), select Deployment Configuration, and then deselect all initial loads or just the initial loads for specific replication paths.
For online deployments, the
GLOBALS file with the checkpoint table name must be in place before deployment or the initial load, classic or coordinated Replicat will fail to be added. This does not affect integrated Replicat/apply.
Initial load for redeployments will load all tables, new and existing alike. It will not load only new tables.
It is possible that changes to diagrams are not reflected in the user interface. If this occurs simply select Save, then close and reopen the tab.
If you select a column as a key in the Key Column Property Inspector for the mapping editor and save it, it becomes permanent even if you deselect later.
Deleting an explicitly mapped column name from the Column Mapping Editor results in an internal name for that column name remaining in the parameter file.
The Oracle GoldenGate Studio repository should be UTF8 or Unicode if using multibyte table names.
Non-ASCII characters used for Oracle GoldenGate connection names sometimes throws an error when attempting to do an online deployment.
Export and Import utilities cannot be used with multibyte characters.
The Filter Table option for the database connection in the Global Resource Library does not work with multibyte table names.
If conflicting parameters are set, such as
start with BEGIN
timestamp and CSN, it is not detected and both options are present in the parameter file.
In the Global Resource Library, if a database is associated with a deployment profile, then you cannot change the database connection name.
In this initial release, only Oracle Database source and targets have been certified.
When generating the Oracle GoldenGate files locally the ZIP file is corrupted. However, the unzipped versions of the files are written out correctly.
After importing a project, solution or mapping, you may need to use the refresh button before it is shown in the page.
The Oracle GoldenGate Product Documentation Libraries are found at
Additional Oracle GoldenGate information, including best practices, articles, and solutions, is found at:
Use My Oracle Support to find knowledge solutions, workarounds, and other information that is reported by customers, partners, and Oracle employees. My Oracle Support also enables you to open a Service Request. If a patch is required to resolve a service request, you will receive instructions on how to download it from My Oracle Support.
If you purchased Oracle GoldenGate Studio and support through a distributor, contact your distributor instead of attempting to create a service request through My Oracle Support.
To view the Oracle GoldenGate Studio Knowledge Base, follow these steps:
Additional information about how to use this tab is obtained by clicking Help.
If you cannot find an answer to your question or problem in the Knowledge Base, you can open a support request ticket with Oracle Support by following these steps:
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at
Accessible Access to Oracle Support
Oracle customers who have purchased support have access to electronic support through My Oracle Support. For information, visit
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle® Fusion Middleware Release Notes for Oracle GoldenGate Studio, 12c (22.214.171.124.0)
Copyright © 2015, 2017, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.