Oracle® GoldenGate
11g Release 1 Patch Set 1 (11.1.1.1.2)
Release Notes
E22504-01
2011
Oracle GoldenGate for Windows and UNIX Release Notes 11g Release 1 Patch Set 1 (11.1.1.1.2)
2
Copyright © 2008, 2009, 2010, 2011 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.
Oracle GoldenGate for Windows and UNIX Release Notes 11g Release 1 Patch Set 1 (11.1.1.1.2)
3
Contents
New Features in 11.1.1.1 .................................................................................................... 5
Database-specific enhancements ................................................................................................. 5
Oracle ...................................................................................................................................... 5
MySQL ................................................................................................................................... 7
Sybase ..................................................................................................................................... 7
General enhancements ................................................................................................................ 8
New Features in 11.1.1.0 .................................................................................................... 9
New supported databases ............................................................................................................ 9
Database-specific enhancements ................................................................................................. 9
DB2 z/OS ................................................................................................................................ 9
MySQL ................................................................................................................................... 9
Oracle ...................................................................................................................................... 9
SQL Server ........................................................................................................................... 11
Sybase ................................................................................................................................... 12
Other enhancements .................................................................................................................. 12
General .................................................................................................................................. 12
New Parameters .................................................................................................................... 12
New Commands ........................................................................................................................ 13
Deprecated/Discontinued Parameters or Features in 11.1.1.1 .......................................... 14
ALTER TABLE MOVE TABLESPACE ................................................................................. 14
[NO]CHECKSEQUENCEVALUES ........................................................................................ 14
DDLOPTIONS NOEXPLICITSCHEMAMAPPING .............................................................. 14
TRANLOGOPTIONS UNPRIVILEGED ................................................................................ 14
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY (Oracle 11.2 and later only) 14
stdout ......................................................................................................................................... 14
Deprecated/Discontinued Parameters or Features in 11.1.1.0.0 ....................................... 14
SQL Server 2000 and 2005 ....................................................................................................... 15
VARWIDTHNCHAR ............................................................................................................... 15
TRANLOGOPTIONS CONVERTUCS2CLOB ...................................................................... 15
USETHREADS / NOUSETHREADS ...................................................................................... 15
DDLGEN .................................................................................................................................. 15
Documentation Addendum ............................................................................................... 15
Oracle GoldenGate for Windows and UNIX Release Notes 11g Release 1 Patch Set 1 (11.1.1.1.2)
4
Documentation Errata ....................................................................................................... 16
Installation and Upgrades ................................................................................................. 17
Corrected Problems ........................................................................................................... 17
Version 11.1.1.1.2 – 28 October 2011 ...................................................................................... 17
Version 11.1.1.1.1 – 30 August 2011 ....................................................................................... 18
Version 11.1.1.1.0 – 21 April 2011 ........................................................................................... 19
Getting help with My Oracle Support ............................................................................... 20
Oracle GoldenGate for Windows and UNIX Release Notes 11g Release 1 Patch Set 1 (11.1.1.1.2)
5
New Features in 11.1.1.1
Database-specific enhancements
Oracle
•
Oracle GoldenGate now supports the capture of direct-load INSERTs for Oracle
versions 9iR2, 10gR1, and 10gR2 and later. Supplemental logging must be enabled,
and the database must be in archive log mode. The affected tables cannot contain
LOBs if the database is 9iR2 or 10gR1, but LOBs are supported for later versions.
The following direct-load methods are supported.
•
/*+ APPEND */ hint
•
/*+ PARALLEL */ hint (Non-RAC only)
•
SQLLDR with DIRECT=TRUE
•
Oracle GoldenGate now supports the delivery of data to EHCC-compressed tables in
Oracle Exadata. Capture from EHCC-compressed tables is not supported. In order for
Replicat to apply data so that it is compressed with EHCC compression, you must use
the INSERTAPPEND parameter for Replicat, which causes Replicat to use an
APPEND hint for inserts. See the Oracle GoldenGate Windows and UNIX Reference
Guide.
•
Oracle TIMESTAMP WITH TIME ZONE with TZR (time zone region) is now
supported fully for replication from a source Oracle database to another Oracle
database, or to a non-Oracle database. To use this support, you must use one of two
new TRANLOGOPTIONS options, depending on the database type and whether
conversion is required. These options are INCLUDEREGIONID and
INCLUDEREGIONIDWITHOFFSET. For more information, see the Oracle
GoldenGate Windows and UNIX Reference Guide.
•
Oracle Transparent Data Encryption (TDE) at the column and tablespace level are
now supported. To support these features, a new dbms_internal_cklm.plb package is
installed in the Oracle GoldenGate installation directory, and a new
DECRYPTPASSWORD option was added to the DBOPTIONS parameter. Specific
setup procedures must be followed by the Oracle Security Officer and the Oracle
GoldenGate Administrator, and database patches are required. For more information,
see the Oracle GoldenGate for Oracle Installation and Setup Guide.
•
The Extract process by default now uses a new log reader mechanism that enables the
parsing of log data to be performed by a producer thread at the same time as
additional data is being read from the redo log files by a reader thread. The reading of
more data while current data is being parsed is known as the “read-ahead”
mechanism. This new feature reduces I/O latency, especially in the case where there
is I/O contention on the redo log device.
•
The default Replicat commit method has changed to take advantage of the Oracle
asynchronous COMMIT feature whenever a checkpoint table is being used. When
applying a transaction to the Oracle target, Replicat includes the NOWAIT option in
the COMMIT statement. This improves performance by allowing Replicat to
continue processing immediately after applying the COMMIT, while the database
engine logs the transaction in the background. You can disable the default
asynchronous COMMIT behavior by using the DBOPTIONS parameter with the new
