GoldenGate Notes

Oracle GoldenGate Release Notes for 12c (12.2.0.1)

Master Note – Oracle GoldenGate (Doc ID 1298817.1)

Main Note – Oracle GoldenGate – Installation (Doc ID 1304564.1)

OGG-01031 There is a problem in network communication. Reply received is Output file is not in any allowed output directories. (Doc ID 2095284.1)

Add to GLOBALS: ALLOWOUTPUTDIR /u01/ggtrail/

GGSCHEMA ggs_user
CHECKPOINTTABLE ggs_user.GGS_CHECKPOINT

ALLOWOUTPUTDIR /u01/ggtrail/

Process Abends : OGG-00919 Error in COLMAP clause referring to : @GETENV(“GGHEADER”…. (Doc ID 1635935.1)

1. Replace double quote with single quote.

Change reference is GETENV statement to use single quotes rather than double quotes, as example is :

@GETENV('GGHEADER','BEFOREAFTERINDICATOR')

2. Specify NOUSEANSISQLQUOTES in GLOBALS parameter.

The default is now USEANSISQLQUOTES.

USEANSISQLQUOTES

When capturing and mapping object names, such as table names, 
Oracle GoldenGate always recognizes double-quoted strings 
as case-sensitive object names, regardless of whether 
USEANSISQLQUOTES or NOUSEANSISQLQUOTES is specified.

With USEANSISQLQUOTES enabled, Oracle GoldenGate 
treats a string within double quotes as a case-sensitive column name, 
and it treats a string within single quotes as a literal.

GoldenGate 12c Integrated EXTRACT: How To EXCLUDEUSER (Doc ID 2008420.1)

When using Integrated EXTRACT, EXCLUDEUSER is currently not supported. 
We have a enhancement request tracked via Bug 21891811

OGG DDL Trigger Is not required in 11.2.0.4 or later with 12c Integrated capture extract (Doc ID 1911243.1)

To capture DDL from redo directly (without using DDL trigger),

1. RDBMS should be 11.2.0.4 or later (like 12.1.0.1) with compatible setting to 11.2.0.4 or later. 
2. OGG version should be 12c or later.

In downstream capture extract setup, the source DB must meet above rdbms requirement. 

DDL parameters are same as before.

How to Identify If Integrated Extract ( IE/ Integrated Captured) Is Using “Light Weight” Capture (v2) or v1 Protocol/ Mode (Doc ID 1509748.1)

There is a known data integrity issue with 11.2.1.0.4 on big endian systems (AIX, HPUX, SOLARIS) when using the V2 mode and is tracked in following bug

Bug 15919205 – A TRIGGER CAUSED INTEGRATED CAPTURE EXTRACT TO CAPTURE 2 INSERTS FOR 1 INSERT
The bug has been fixed in OGG v11.2.1.0.5 and higher.

OGG Triggerless Integrated Extract Abends With Error on DDL Trigger related tables when DDL is enabled (Doc ID 1604243.1)

Add to Extract TRANLOGOPTION _LCRCAPTUREPROTOCOL V2

Integrated Replicat checkpoint information and explanation. (Doc ID 1952630.1)

3) Checkpoint table is not required for IR and ignored if one is used.

OGG Replicat executes the trigger even with SUPPRESSTRIGGERS enabled (Doc ID 1428494.1)

Does OGG 11.2.1 Integrated Capture Work with Oracle Database Standard Edition? (Doc ID 1431938.1)

GoldenGate 12c Integrated EXTRACT: How To EXCLUDEUSER (Doc ID 2008420.1)

Implementing RDA for Oracle GoldenGate Data collection (Doc ID 1362838.1)

Download the appropriate module to an RDA directory and unzip it:
unzip *.zip
Change to the created rda directory:
cd rda
ls
Verify the install:
./rda.sh -cv
Setup Collection Parameters for OGG only:
./rda.sh -S OGG
Execute RDA collection capture:
./rda.sh -v