Release Notes for Oracle GoldenGate Studio
12c (12.2.1.2.0)
E77904-01
October 2016
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 heterogeneous database. In the current release Oracle, SQLServer, and 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 dirtmp directory, 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 23234498 - Manage secondary truncation point option always appends with tranlogoptions
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 DDL and INSERTAPPEND parameters for MySQL tables
An issue where the mapping displayed invalid parameters like DDL and 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 11.2.0.4
An issue where the properties screen does not show an option for Integrated Extract or Integrated Replicat with Oracle Database 11.2.0.4 was fixed. The Integrated Replicat and Integrated Extract are enabled for Oracle Database 11g database. You should use these features with Oracle Database 11.2.0.4 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 12.1.2.0.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 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 archivedlogonly mode.
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
Oracle GoldenGate Application Adapters
Oracle GoldenGate for Big Data
Oracle GoldenGate Plug-in for EMCC
Oracle GoldenGate for HP NonStop (Guardian)
Additional Oracle GoldenGate information, including best practices, articles, and solutions, is found at:
The Oracle GoldenGate Product Documentation Libraries are found at
Oracle GoldenGate Application Adapters
Oracle GoldenGate for Big Data
Oracle GoldenGate Plug-in for EMCC
Oracle GoldenGate for HP NonStop (Guardian)
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.
Note:
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:
http://support.oracle.com.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:
http://support.oracle.com.For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that 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 (12.2.1.2.0)
E77904-01
Copyright © 2015, 2016, 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.