Management Pack for Oracle® GoldenGate

Release Notes for Oracle GoldenGate Director

12c (12.1.2)

E50293-03

October 2017

This document contains the release notes for the Oracle GoldenGate Director 12c (12.1.2) release.

Topics:

Topics:

1.1 End of Life Support

Oracle GoldenGate Director is a multi-tiered, client-server, application that enables the configuration and management of Oracle GoldenGate instances from a remote client. The Oracle GoldenGate Director 12c (12.1.2) October 2017 release is the terminal release, which includes important bug fixes. Oracle GoldenGate Director will not support Oracle GoldenGate 12c (12.3.0.1) and later. For more information, see the details about the release at http://docs.oracle.com/goldengate/c1230/gg-winux/index.html.

Oracle will not release any further patch set or bundle patches after the Oracle GoldenGate Director 12c (12.1.2) October 2017 release, although Oracle will honor the current support policy obligations as per the Oracle Lifetime Support Policy.

Oracle released Oracle GoldenGate Studio in December 2016 and it is a replacement product for Oracle GoldenGate Director. Oracle GoldenGate Studio is the design and deployment tool with an easy-to-use, rich user interface. Best practice wizards, with templates and auto-mapping, make real-time data integration easier to deploy throughout your enterprise. Oracle GoldenGate Studio allows development, quality assurance, and production teams to be on the same page ensuring continuity. All changes and history are stored securely in a central database repository.

Oracle GoldenGate Studio provides most of the functionality included in Oracle GoldenGate Director. In addition, it provides the capabilities to design replication environments logically without knowing the GoldenGate details. Several different topologies (Unidirectional, Bidirectional, Hub and Spoke, Consolidation, and Broadcast) are supported so that you can easily evolve solutions to support your changing business needs. You can drag and drop mapping objects and share mappings across solutions. Projects help you achieve design reusability and save effort.

Oracle GoldenGate Studio manages complex enterprise-level replication environments and supports all of the Oracle GoldenGate parameters. Oracle GoldenGate Studio supports all of the latest versions of Oracle GoldenGate. For monitoring, Oracle GoldenGate Studio provides adequate monitoring support to manage the development life cycle while you are engaged in designing, and maintaining your replication environments. With the Oracle GoldenGate Studio 12c (12.2.1.3.0) release, you can reverse engineer your Oracle GoldenGate environments into the Oracle GoldenGate Studio product to help migrate from Oracle GoldenGate Director.

Oracle GoldenGate Studio is part of the Oracle GoldenGate Foundation Suite, which includes Oracle GoldenGate Monitor, Oracle GoldenGate Enterprise Manager Plug-In, and Oracle GoldenGate Veridata. You can do net-net migration, and upon approval, can apply the cost of the Oracle GoldenGate Management Pack towards the purchase of Oracle GoldenGate Foundation Suite.

1.2 License Keys

The 'pw' file is no longer needed to use Oracle GoldenGate Director. Once you have upgraded to version 11.1.1+, you can safely remove this file from the installation directory.

1.3 Availability

Oracle GoldenGate Director is compatible with versions of the Oracle GoldenGate software that are covered under the current Oracle GoldenGate support policy. To find out which Oracle GoldenGate builds are available for a specific combination of database version and operating system, log onto http://support.oracle.com and select the Certifications tab. For assistance, click Tips for Finding Certifications.An email and password are required to enter this site.

1.4 New Features in Oracle GoldenGate Director 12.1.2

New parameters were introduced in the core Oracle GoldenGate 12.1.2 product and are supported in this version of Oracle GoldenGate Director.

Multi-byte support has also been implemented as of Oracle GoldenGate 11.2 and is supported in Oracle GoldenGate Director 12.1.2 via UTF8 only. See the Oracle GoldenGate release notes for more information on specific parameters.

Support for WebLogic Server 12c (12.1.1, 12.1.2, 12.1.3) has been added. The JRE must be at least version 6 (1.6.x) if using WebLogic Server 11g, and must be at least version 1.6.0_20 or 1.7 if using WebLogic Server 12c. See Management Pack for Oracle GoldenGate Administering Oracle GoldenGate Director.

For Oracle Database, Oracle GoldenGate Director can now connect to an Oracle service name, as well as to an Oracle SID.

1.5 Documentation Addendum

There is no documentation addendum for this release.

1.6 Documentation Changes

The Oracle GoldenGate documentation library has been reorganized and improved as follows.

1.7 Installation and Upgrades

The installation file downloaded from Oracle is not compressed using gzip — instead it is a standard .zip file. To uncompress the download, please use the following methods:

  • Windows - Use winzip or another method that can support files with the .zip extension.

  • UNIX / Linux - Use the unzip command utility to uncompress the downloaded file.

  • Mainframe - Use the unzip command utility to uncompress the downloaded file.

If you do not have any of these utilities on the server, you can download them from Oracle's website at http://updates.oracle.com/unzips/unzips.html.

For full upgrade instructions, see Oracle GoldenGate Director Administrator's Guide.

1.8 Known Issues

This section contains known issues that affect Oracle GoldenGate Director.

Topics:

1.8.1 General Issues

  • Oracle GoldenGate Director only supports UTF-8 format. Oracle GoldenGate Director does not support other character sets so some characters could display incorrectly.

  • DB2 z/OS support is introduced in Oracle GoldenGate release 11g (11.2.1.0.3). Refer to Bug 13861016.

  • Before the Oracle GoldenGate 11g (11.2.1.0.2) release, list tables is not supported for tables not owned by the current user. Refer to Bug 13885563.

  • If SSL Mode Login is enabled, an exception is generated instead of a clear message that explains the condition.

  • An exception occurs when accessing the database to create a DEFGEN file or to display a list of tables (SHOW TABLES) if the database contains a table that has a special character that is not supported. The expected result is to generate a clear message that explains the condition.

  • Oracle GoldenGate Director requires the installation of Oracle GoldenGate release 11g (11.2.1.0.3) and higher.

  • The Param check button in the Param File Editor is not available by design.

1.8.2 Supported Process Types

Only processes that are typically defined in GGSCI can be configured, monitored and controlled with Oracle GoldenGate Director. Standalone processes and programs such as DDLGEN, MEASFLS, MEASRPT, and TRIGGEN that are run from the operating system's command line cannot be created or monitored with Oracle GoldenGate Director.

On Windows, UNIX, and NonStop, only the following can be configured, monitored, and controlled with Oracle GoldenGate Director:

  • Extract

  • Replicat

  • Manager

  • trails (local and remote)

  • files (local and remote)

  • Extract and Replicat tasks

On Nonstop, Logger processes can be monitored and controlled, but they must be configured or changed by using GGSCI and the LOGPARM file, not through the Oracle GoldenGate Director Client.

1.8.3 Unable to Start Oracle GoldenGate Director

If you have changed the default properties in the boot.properties file, when you start the server domain it may cause an Oracle WebLogic Server security error similar to the following:

<Sep 11, 2017 2:06:08 AM PDT> <Notice> <Security> <BEA-090082> <Security initializing using security realm ggRealm.>
<Sep 11, 2017 2:06:08 AM PDT> <Critical> <Security> <BEA-090402> 
<Authentication denied: Boot identity not valid. The user name or password or both from the boot identity file (boot.properties) is not valid. The boot identity may have been changed since the boot identity file was created. Please edit and update the boot identity file with the proper values of username and password. The first time the updated boot identity file is used to start the server, these new values are encrypted.>
<Sep 11, 2017 2:06:08 AM PDT> <Critical> <WebLogicServer> <BEA-000386>

This depends on the WLS_USER and WLS_PW that is set. If this error occurs, you can delete the Director_server_install_dir\domain\servers\localhost\security\boot.properties file, and then enter the username and password manually on start of the Oracle GoldenGate Director Server domain. 

1.8.4 Macros

Oracle GoldenGate Director does not support macros that are defined within a parameter file. Oracle GoldenGate Director does support macros that are referenced externally with the INCLUDE parameter. Oracle GoldenGate Director cannot process the parameter file if the macro defines the following parameters:

  • EXTRACT

  • REPLICAT

  • RMTHOST

  • RMTTRAIL

  • RMTFILE

  • RMTBATCH

  • EXTFILE

  • EXTTRAIL

  • SOURCEDB

  • USERID

  • TABLE

  • MAP

  • COLMAP

1.8.5 DEFGEN Utility

The built-in DEFGEN utility in Oracle GoldenGate Director creates definitions files with all-default settings. To customize definitions output, the command-line version of DEFGEN must be used.

1.8.6 Oracle GoldenGate Director GGSCI

The built-in GGSCI window in Oracle GoldenGate Director does not support the following Oracle GoldenGate commands. These commands must be issued from GGSCI on the Oracle GoldenGate host.

  • All database commands, including DBLOGIN

  • VERSION

  • FC

  • HISTORY

  • !

  • SHELL

  • EDIT PARAMS

  • EXIT

  • RESTART

  • ADD TRACETABLE

Oracle GoldenGate Director has no interface for adding an Oracle GoldenGate TRACETABLE to the Oracle database, nor can one be created from the built-in GGSCI interface in Oracle GoldenGate Director. The ADD TRACETABLE command (and all other database commands) require database login with DBLOGIN, so a local GGSCI session on the Oracle GoldenGate host must be used.

1.8.7 Output Format Parameters

Oracle GoldenGate Director does not support a single Capture object writing to multiple files in different formats using FORMATASCII, FORMATSQL, and FORMATXML. The format parameters can only be applied globally by inserting them into the Capture object. To obtain the same data in different formats, a Capture object must be defined for each format.

In addition, Oracle GoldenGate Director cannot process existing Capture objects that are configured with multiple format parameters. This can cause unexpected behavior if the existing objects are saved using Oracle GoldenGate Director.

1.8.8 Multiple Oracle GoldenGate Instances on One Host

A Delivery process from one Oracle GoldenGate instance on a host cannot be configured through Oracle GoldenGate Director to read a trail written by a Capture process from a different Oracle GoldenGate instance on the same machine. This configuration can be created through GGSCI, but it will not be displayed correctly in Oracle GoldenGate Director. No line will be shown connecting the processes.

1.8.9 Log Display

If you are using a version of Oracle GoldenGate core prior to 11.1.1.0.6 there have been intermittent problems displaying logs on the Oracle GoldenGate Director Desktop and Activity Console. A change was made to the core in Oracle GoldenGate 11.1.1.0.6 to fix this issue.

1.8.10 SQL Server Extract

Oracle GoldenGate Director cannot generate absolute paths for RMTTRAIL on Windows platforms because SQL Server Extract is unable to fetch and write the data in trail file.

You can workaround this issue by using the ggsci ALTER EXTRACT command to modify RMTTRAIL in your Extract parameter file with the absolute path. 

1.9 Corrected Problems

For questions on specific bugs or ticket numbers, please consult Oracle Customer Support. SR is the Oracle Support SR number, and BugDB is the bug identification number.

Version 12.1.2.0.0 ­— October 2013

Initial Release

1.10 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 and support through a distributor, contact your distributor instead of attempting to create a service request through My Oracle Support.

Topics:

1.10.1 Using the Oracle GoldenGate Knowledge Base

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

  1. Go to http://support.oracle.com.
  2. Select your language and then log in with your email and Oracle password.
  3. Click the Knowledge tab.
  4. Under Select a Product Line, type the name “Management Pack for Oracle GoldenGate." As an alternative, you can select from the drop-down list or use the Browse link to select Middleware, then Data Integration, then GoldenGate, then Management Pack for Oracle GoldenGate.
  5. Under Task, select the type of query you want to make, such as Troubleshoot.
  6. Under Version, select the version of Oracle GoldenGate Director that you are using.
  7. Under Enter Search Terms, type a search keyword or multiple keywords to focus the query.

If you need help with My Oracle Support, click Help at the top of the application window.

1.10.2 Creating an Oracle GoldenGate Support Case

If you cannot find an answer to your question or problem in the Knowledge Base, you can open a support case with Oracle Support by following these steps:

  1. Go to http://support.oracle.com.
  2. Select your language and then log in with your email and Oracle password.
  3. Click the Service Requests tab.
  4. Click Create SR.
  5. Complete the form, referring to the Help at the top of the application window if necessary.

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


Management Pack for Oracle GoldenGate Release Notes for Oracle GoldenGate Director, 12c (12.1.2)

E50293-03

Copyright © 2013, 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.

This guide is intended for installers, database administrators, and system administrators who are installing, configuring and running Oracle GoldenGate.

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.

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

The following text conventions are used in this document:

Convention Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, such as "From the File menu, select Save." Boldface also is used for terms defined in text or in the glossary.

italic

italic

Italic type indicates placeholder variables for which you supply particular values, such as in the parameter statement: TABLE table_name. Italic type also is used for book titles and emphasis.

monospace

MONOSPACE

Monospace type indicates code components such as user exits and scripts; the names of files and database objects; URL paths; and input and output text that appears on the screen. Uppercase monospace type is generally used to represent the names of Oracle GoldenGate parameters, commands, and user-configurable functions, as well as SQL commands and keywords.

UPPERCASE

Uppercase in the regular text font indicates the name of a utility unless the name is intended to be a specific case.

{ }

Braces within syntax enclose a set of options that are separated by pipe symbols, one of which must be selected, for example: {option1 | option2 | option3}.

[ ]

Brackets within syntax indicate an optional element. For example in this syntax, the SAVE clause is optional: CLEANUP REPLICAT group_name [, SAVE count]. Multiple options within an optional element are separated by a pipe symbol, for example: [option1 | option2].