Oracle® GoldenGate
11g Release 2 (11.2.1.0.1)
Release Notes
E27298-01
Copyright © 2012 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 software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the
following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government
customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and
agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the
restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government
contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500
Oracle Parkway, Redwood City, CA 94065.
This software 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 which may create a risk of personal injury.
If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and
other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by
use of this software in dangerous applications.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
This software and documentation may provide access to or information on 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. 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.
Contents
New Features in 11.2.1 ............................................................................................................................... 4
Database-specific enhancements ................................................................................................. 4
DB2 z/OS ................................................................................................................................. 4
MySQL .................................................................................................................................... 4
Oracle ....................................................................................................................................... 4
SQL Server .............................................................................................................................. 4
Sybase ...................................................................................................................................... 4
Other enhancements .................................................................................................................................... 5
General ......................................................................................................................................... 5
Column Conversion Functions ................................................................................................ 6
User Exits ................................................................................................................................ 6
Parameters .................................................................................................................................... 8
Commands ................................................................................................................................... 9
Utilities....................................................................................................................................... 11
Documentation enhancements and corrections ........................................................................................ 12
Deprecated parameters and commands..................................................................................................... 12
Documentation Addendum ....................................................................................................................... 12
Documentation Errata ............................................................................................................................... 13
Installation and Upgrades ......................................................................................................................... 14
Corrected Problems .................................................................................................................................. 14
Version 11.2.1.0.1 – 7 May 2012 ............................................................................................. 14
Version 11.2.1.0.0 – 9 Feb 2012 ............................................................................................... 15
Getting help with My Oracle Support ...................................................................................................... 16
New Features in 11.2.1
Database-specific enhancements
DB2 z/OS
The default character conversion for Extract on z/OS has been changed. In version 11.2 and later, column
data from any ASCII-encoded tables will be converted to EBCDIC by default. Prior to version 11.2, the
default was that no conversion would be done. Also, as of version 11.2, character conversion is no longer
supported in Extract data pumps. This includes the conversion of the input trail data as well as the trail
data that is output from a data pump.
MySQL
The following are now supported for MySQL:
• WARNLONGTRANS parameter
• SEND EXTRACT command with FORCETRANS, SHOWTRANS, and SKIPTRANS
Oracle
Extract can now be used in integrated capture mode with an Oracle database. Extract integrates with an
Oracle database log mining server to receive change data from that server in the form of logical change
records (LCR). Extract can be configured to capture from a local or downstream mining database.
Because integrated capture is fully integrated with the database, no additional setup is required to work
with Oracle RAC, ASM, and TDE. In addition, it supports more data and storage types as compared to
classic capture, and the support is more transparent. Additional benefits apply. See also the Parameters
and Commands sections. Integrated capture can be used to capture changes from Oracle RDBMS
versions starting with 11.2.0.3 with the 11.2.0.3 Database specific bundle patch for Integrated Extract
11.2.x (Doc ID 1411356.1). It can also be used to capture changes from Oracle versions starting with
10.2.0.4 in a downstream mining deployment.
Extract can still be configured to capture directly from the redo logs for any supported Oracle version.
This configuration is now called classic capture mode. In this mode, Extract integrates with Oracle
RMAN to manage log retention. The only change to this feature is that ADD EXTRACT no longer
automatically enables log retention. You must first issue DBLOGIN, then REGISTER EXTRACT with
the LOGRETENTION option. To disable log retention, you must first issue DBLOGIN, then
UNREGISTER EXTRACT with the LOGRETENTION option. Log retention continues to be the default,
and an error is generated if REGISTER EXTRACT is not issued before ADD EXTRACT. All other
functionality remains the same.
SQL Server
The following are now supported for SQL Server:
• WARNLONGTRANS parameter
• SEND EXTRACT command with FORCETRANS, SHOWTRANS, and SKIPTRANS
Sybase
The following are now supported for Sybase:
• WARNLONGTRANS parameter
• SEND EXTRACT command with FORCETRANS, SHOWTRANS, and SKIPTRANS
Other enhancements
General
• GoldenGate now supports Advanced Encryption Security (AES) in commands and parameters to
support the encryption of passwords, trails, and data transfer across TCP/IP. BLOWFISH encryption
is still available but recommended only for backward compatibility.
• GoldenGate now supports up to 5,000 concurrent Extract and Replicat processes per instance of
Manager.
• The default trail size was increased to 100 MB
• GoldenGate now provides built-in conflict detection and resolution routines to support bi-directional
and multi-master configurations. New parameters are provided to capture before images from the
transaction log, to specify columns for which the before image is used in the Replicat WHERE
clause, and to specify conflict types, resolutions, and column groups. Records that generate a conflict
are automatically sent to an exceptions MAP statement if one exists, without the need for
REPERROR to be set to EXCEPTION. See the Parameters section for new parameters that support
CDR.
• GoldenGate is enhanced to support the globalization of data and object names. This support is as
follows:
o Oracle GoldenGate processes catalog, schema, table and column names in their native
language as determined by the character set encoding of the source and target databases. This
processing is extended to the parameter files and command interpreter, where they are
processed according to the operating system locale. These objects appear in their native
language format throughout the client interface, on the console, and in files.
o The Oracle GoldenGate apply process (Replicat) supports the conversion of data from one
character set to another when the data is contained in character column types. Character-set
conversion support is limited to column-to-column mapping as performed with the COLMAP
or USEDEFAULTS clauses of a TABLE or MAP statement. It is not supported by the
column-conversion functions, by SQLEXEC, or by the TOKENS feature.
o Oracle GoldenGate supports text input and output in the default character set of the host
operating system for the following: Console, command-line input and output,
FORMATASCII, FORMATSQL, FORMATXML parameters, text files such as parameter
files, data-definitions files, error log, process reports, discard files, and other human-readable
files that are used by Oracle GoldenGate users to configure, run, and monitor the Oracle
GoldenGate environment.
• GoldenGate is now case aware and performs case-sensitive comparisons if the database is case-
sensitive or if the database uses double quotes to enforce case-sensitivity. If the system or database is
case-insensitive, Oracle GoldenGate converts case-insensitive names to the case in which they are
stored when required for mapping purposes. See the Oracle GoldenGate documentation for more
information about specifying case-sensitive object names in parameter files.