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.
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.
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 220.127.116.11 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 18.104.22.168 or later (like 22.214.171.124) with compatible setting to 126.96.36.199 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 188.8.131.52.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 v184.108.40.206.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
3) Checkpoint table is not required for IR and ignored if one is used.
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