Oracle® GoldenGate Application Adapters

1.1 New Features for 12.1.2.1.2

This section describes the new features for release 12.1.2.1.2.

• Big data handlers

  The Big Data handlers now supports the Three-Part Table Name and Unified Trail Format features.

• Retrieval of GGS Tokens

  Use the new gg.includeggtokens=true property to retrieve GGS tokens from the data source. When tokens are available, use op.getToken(<ggstokenname>) to retrieve the value.

• Retrieval of All Available Tokens

  When gg.handler{handlername}.includeTokens=true, the handler will include all available user tokens (key value pairs) to the existing record. This will include the GGS tokens available for the corresponding record.

• Token Retrieval Options

  Use the following combinations of new token properties to retrieve these different tokens:

  This combination:	Will retrieve these tokens:
  gg.includeggtokens=false gg.handler.name.includeTokens=true	User Tokens
  gg.includeggtokens=true gg.handler.name.includeTokens=true	User and GG Tokens
  gg.includeggtokens=true (or false) gg.handler.name.includeTokens=false	No Tokens

  
  

1.2 New Features for 12.1.2.1.1

This section describes the new features for release 12.1.2.1.1.

• Java User Exit Reporting

  Running the Java user exit in PASSTHRU mode disables statistical reporting that allows report counts to be included in the Extract processing report. As of release 12.1.2.1.1, you can trigger the user exit to collect report count statistics and send them to Extract by setting a reporting interval for the newly documented gg.report.time property. Then, if Extract is configured to print a report or a request is sent with SEND REPORT, the user exit statistics will be included.

• Simplified Logging

  Logging now defaults to the built-in Java logging, java.util.logging (JUL). Optionally, java.util.logging can be changed to either log4j or logback.

  Defaults have been put in place for each of the three possible implementations to simplify the set-up needed for logging. Once the type of logging is identified, the user is not required to enter any properties.

  By default, log files are written to the dirrpt subdirectory of the Oracle GoldenGate Adapters installation directory. The format of the log file name varies, but all three implementations use the Extract group as part of the default name.

• Grouped Transactions

  Release 12.1.2.1.1 includes the option to limit transaction size based on the number of operations. See Section 2.1.1.1, "Transaction Grouping Properties" for details on the properties.

  When using the group transactions properties, gg.handler.name.mode property and gg.handler.name.format, must be set to one transaction per message (transaction mode).

• Unified Trail Format Support

  Release 12.1.2.1.1 supports the reading of trails that are in the unified trail format. This allows 12.1.x Oracle GoldenGate trails to be processed by the Oracle GoldenGate Adapters flat file writer or user exit. Support for writing unified trail format has been deferred to the next release.

• Three-Part Table Name Support

  Release 12.1.2.1.1 supports the reading of trails that are written with three-part table names (database.schema.table). Both the Java File Writer and Flat File Writer now support three-part table names.

2.1 New or Changed Properties for 12.1.2.1.1

The following properties have been added, changed, or documented for the 12.1.2.1.1 release.

3.1 Deprecated Properties for 12.1.2.1.1

This section lists the properties and property options that are deprecated for release 12.1.2.1.1.

4.1 Installation Instructions

The installation file downloaded from Oracle is not compressed using gzip; instead it is a standard zip file.

4.2 Upgrades

This section lists changes in the upgrade procedure for Oracle GoldenGate Adapters.

5.1 Tickets for Release 12.1.2.1.3 -- July 20, 2015

The following tickets have been implemented for the 12.1.2.1.3 Adapters.

Bug DB #21099203 - The v12.1.2 Java Adapter correctly includes tokens in the output, in transaction mode.

5.2 Tickets for Release 12.1.2.1.2 -- June 10, 2015

The following tickets have been implemented for the 12.1.2.1.2 Adapters.

Bug DB #20432399 - GoldenGate Big Data no longer abends with exception while processing Unified Trail Format trail files.

BugDB #21208201 - GoldenGate Adapter correctly reads 12c source definition files.

5.3 Tickets for Release 12.1.2.1.1 -- May 1, 2015

The following tickets have been implemented for the 12.1.2.1.1 Adapters.

BugDB #20041455 - Fixed a crash due to incorrect character set handling when userexit.utf8mode=true.

BugDB #19982656 - Implemented support to handle XMLTYPE columns.

BugDB #19611993 - Fixed a crash in Solaris x86_64 due to incompatible fast compilation done in the Adapter target.

BugDB #13888220 - Implemented support to handle GUID or unique identifier columns.

BugDB #20523498 - The behavior of handler metacols transaction indicator (op.getTxState), which was changed in 11.2.1.0.3, caused errors in GETENV. To fix this we are deprecating that behavior and reverting to the original behavior.

BugDB #19898067 - The Java rolling file handler has been fixed and works correctly on size, or time, or both.

BugDB #20731562 - Fixed an IllegalArguementException on the EventObject source during a rollback event.

BugDB #20657093 - Java user exit now correctly handles different charset data.

BugDB #20639793 - Oracle GoldenGate now issues an exception when the checkpoint by base process is ahead of the one in Java exit.

BugDB #20639752 - Oracle GoldenGate now issues an exception when using grouping with multiple handlers.

BugDB #20525694 - The Java File Writer and Flat File Writer now support the reading of trails that are written with three-part table names (database.schema.table).

BugDB #19607132 - The Java handler now supports physicalDestination property in order to obtain the queue or topic object from the ConnectionFactory API instead of the JNDI provider.

BugDB #18397579 - The Oracle GoldenGate JMS Adapter now correctly encodes characters for all Cyrillic characters.

The following tickets, implemented for Oracle GoldenGate core, affect the 12.1.2.1.1 release of the Adapters.

BugDB #19368122 - Oracle GoldenGate core fixed CLOB chunk retrieval logic, which affected large character object retrieved by the Adapter.

BugDB #17798874 - Oracle GoldenGate core fixed LOB chunk retrieval logic, which affected large object retrieval by the Adapter.

6.1 Issues for Release 12.1.2.1.3

The following are known issues for release 12.1.2.1.3 of the Oracle GoldenGate Application Adapters.

6.2 Issues for Release 12.1.2.1.2

The following are known issues for release 12.1.2.1.2 of the Oracle GoldenGate Application Adapters.

• JMS Capture may abend while parsing JMS messages that include three-part table names.

6.3 Issues for Release 12.1.2.1.1

The following are known issues for release 12.1.2.1.1 of the Oracle GoldenGate Application Adapters.

• When grouping transactions, the Java user exit may need to wait for additional operations to meet the minimum requirement to send the transaction. As the user exit waits, the Extract checkpoint moves on. If the program abends at this point, it is necessary to manually position the restart in order not to lose data. In this event, the report file and log file will print a message similar to "Alter Extract to SeqNo seq_no and RBA rba before restarting the Java Adapter."

• The underlying Extract (OGGCORE 12.1.2.1.1) now has logic to check out-of-order operations based on the sequence id of the captured records. When the process detects the out-of-order condition, it throws the error "ERROR OGG-04036 Positioning sequence ID is out of order." This can happen when the captured records in the JMS queue are coming from two (or more) different data sources, which means each data source will have its own sequence id generation potentially causing interleaved sequence ids. See BugDB #20390986 for more information

7.1 Documentation Changes for 12.1.2.1.1

Documentation for the Oracle GoldenGate Adapters has the following changes for release 12.1.2.1.1.

• New library pages - the documentation libraries are now organized into a task-based structure designed to make it easier to locate information about the task you are interested in.

• The Flat File and Java Adapter guides have been merged into one Administering Oracle GoldenGate Application Adapters guide. This guide is divided into three parts to cover flat file, Java message capture, and Java message delivery.

• Installation and upgrade have been separated out into separate guides.

• Book and chapter titles have been changed to be more task oriented. Each chapter now begins with a brief summary and a list of the topics included in the chapter. Each section begins with a brief summary.

• To improve the documentation for properties:

  • The variables that are part of property names are now included in the documentation. There is also an explanation of the use of variables in property names in section 1.3 of the Administering guide.

  • The property descriptions have been changed to include a syntax statement, or an example, or both.

  • The property syntax has been changed to better conform to Oracle standards by removing the curly brackets from variable names and instead denoting variables with italics.

  • An effort has been made to specify the default value for each property variable.

  • Multiple properties that were previously defined together using abbreviated names have been separated and/or changed to use complete names to allow for easier lookups.