Release Notes for Oracle GoldenGate Director
12c (12.1.2)
E50293-04
May 2019
This document contains the release notes for the Oracle GoldenGate Director 12c (12.1.2) release.
Topics:
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.
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.
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.
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.
The Oracle GoldenGate documentation library has been reorganized and improved as follows.
New library pages - the documentation library is now organized in a task-based structure to make it easier to locate information about the task or feature you need help with. The familiar listing by book is also available under the Books tab.
The Oracle GoldenGate Director Administrator's Guide is now named and can be accessed from the new Oracle GoldenGate library.
The Oracle GoldenGate Troubleshooting and Tuning Guide has been discontinued. Troubleshooting information (and other information) can be obtained by using My Oracle Support. See Getting Help with My Oracle Support for more information.
The performance tuning topics have been integrated into Administering Oracle GoldenGate for Windows and UNIX. You can also find performance-tuning help at My Oracle Support. See Getting Help with My Oracle Support for more information.
The Logdump instructions and command documentation has been incorporated into a new book named Logdump Reference for Oracle GoldenGate. The part number for release 12.1.2 is E41143-01.
The Oracle GoldenGate Installation and Setup Guide, now named Installing and Configuring Oracle GoldenGate for Oracle Database, contains initial setup information that has been expanded to include Oracle-specific configuration steps for classic and integrated modes of Extract and Replicat. This book should be used in conjunction with Administering Oracle GoldenGate for Windows and UNIX and Reference for Oracle GoldenGate for Windows and UNIX when installing, configuring, and running an Oracle GoldenGate environment.
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.
This section contains known issues that affect Oracle GoldenGate Director.
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.
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.
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.
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
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.
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.
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.
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.
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.
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.
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
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.
To view the Oracle GoldenGate Knowledge Base, follow these steps:
If you need help with My Oracle Support, click Help at the top of the application window.
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:
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-04
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
https://docs.oracle.com/en/middleware/goldengate/index.html
Additional Oracle GoldenGate information, including best practices, articles, and solutions, is found at:
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 type indicates placeholder variables for which you supply particular values, such as in the parameter statement: |
|
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: |
[ ] |
Brackets within syntax indicate an optional element. For example in this syntax, the |