Oracle® Fusion Middleware

Release Notes for Oracle GoldenGate Studio

12c (12.2.1.3.0)

E83997-01

August 2017

This document describes the new features, major changes, and the known issues for the 12c (12.2.1.3.0) release of Oracle GoldenGate Studio. It includes the following sections:

- New and Changed Features

- Prerequisites and Installation

- Corrected Problems

- Known Issues

- Related Information

- Getting Help with My Oracle Support

- Documentation Accessibility

1.1 New and Changed Features

This section outlines the new features that are being introduced in the release, features that have been enhanced, and changes to existing features.

1.1.1 Release 12.2.1.3.0

- 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.

- The REPERROR parameter with the TRANSABORT option is not supported.

1.1.2 Release 12.2.1.2.6

- Support for Big Data System andTeradata as target database.

- Support for DB2 z/OS as source and target database.

- Support for 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.

1.1.3 Release 12.2.1.2.0

No new features were added in the 12.2.1.2.0 release.

1.1.4 Release 12.2.1.1.0

- Support for heterogeneous database. In the current release Oracle, SQLServer, and MySQL are supported as source and target database.

1.1.5 Release 12.2.1.0.0— Initial Release

Initial release.

1.2 Prerequisites and Installation

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

http://docs.oracle.com/goldengate/c1221/gg-winux/index.html

1.3 Corrected Problems

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.

1.3.1 Release 12.2.1.3.0

No bugs required correcting in this release.

1.3.2 Release 12.2.1.2.6

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.

1.3.3 Release 12.2.1.2.0

No new bugs were added in the 12.2.1.2.0 release.

1.3.4 Release 12.2.1.1.0

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.

1.3.5 Release 12.2.1.0.0 — Initial Release

Initial release.

1.4 Known Issues

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:

1.4.1 Release 12.2.1.3.0

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.

1.4.2 Release 12.2.1.2.6

Bug 24911786 - Error status is not updated in Oracle Data Pump tab

In 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 state

When 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.

1.4.3 Release 12.2.1.2.0

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.

1.4.4 Release 12.2.1.1.0

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.

1.4.5 Release 12.2.1.0.0— Initial Release

- 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.

1.5 Related Information

The Oracle GoldenGate Product Documentation Libraries are found at

Oracle GoldenGate

Oracle GoldenGate Application Adapters

Oracle GoldenGate for Big Data

Oracle GoldenGate Plug-in for EMCC

Oracle GoldenGate Monitor

Oracle GoldenGate for HP NonStop (Guardian)

Oracle GoldenGate Veridata

Oracle GoldenGate Studio

Additional Oracle GoldenGate information, including best practices, articles, and solutions, is found at:

Oracle GoldenGate A-Team Chronicles

1.6 Getting Help with My Oracle Support

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.

1.6.1 Viewing the Oracle GoldenGate Studio Knowledge Base

To view the Oracle GoldenGate Studio Knowledge Base, follow these steps:

1. Browse to the My Oracle Support web site at http://support.oracle.com.

2. Select your language and then log in with your email and Oracle password.

3. Click the Knowledge tab.

4. In the Select a product or product line field, enter GoldenGate Studio, and then select an Oracle GoldenGate product from the context-sensitive list to narrow your results. (You may have to wait a few seconds for this list to appear).

5. In the Enter search terms field, enter a search keyword or multiple keywords to focus the query.

Additional information about how to use this tab is obtained by clicking Help.

1.6.2 Creating an Oracle GoldenGate Studio Support Request Ticket

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:

1. Browse to the My Oracle Support web site at http://support.oracle.com.

2. Select your language, and then sign in with your credentials. If you have not done so, you will have to register to use this web site.

3. Click the Service Requests tab.

4. Click Create SR.

5. Use the Create Service Request wizard to complete and submit your SR. Additional information about how to use this tab is obtained by clicking Help.

1.7 Documentation Accessibility

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.

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 (12.2.1.3.0)

E83997-01

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.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2018, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

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.

Warranty Disclaimer

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.

Restricted Rights Notice

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.

Hazardous Applications Notice

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.

Trademark Notice

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.

Third-Party Content, Products, and Services Disclaimer

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.

Pre-General Availability Draft Documentation Notice

If this document is in public or private pre-General Availability status:

This documentation is in pre-General Availability status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Pre-General Availability Draft Documentation Notice

If this document is in private pre-General Availability status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your pre-General Availability trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

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.