This is an old revision of the document!
Overview
Oracle Golden gate for Big data is a separate software than the standard Oracle Golden Gate, so you need to download it from the edelivery or the oracle site.
Installation
Unzip
[oracle@edvmr1p0 ~]$ mkdir /u01/app/oggtrg [oracle@edvmr1p0 ~]$ cd /u01/app/oggtrg [oracle@edvmr1p0 oggtrg]$ pwd /u01/app/oggtrg [oracle@edvmr1p0 oggtrg]$ unzip /stage/V839824-01.zip <- Unzip the binaries Archive: /stage/V839824-01.zip inflating: ggs_Adapters_Linux_x64.tar inflating: OGG_BigData_12.3.0.1.0_Release_Notes.pdf inflating: OGG_BigData_12.3.0.1_README.txt [oracle@edvmr1p0 oggtrg]$ tar xvf ggs_Adapters_Linux_x64.tar <- Unzip the handlers AdapterExamples/ .....................................
Configuration
Configure Oracle Golden Gate for Big Data
[oracle@edvmr1p0 oggtrg]$ ggsci Oracle GoldenGate Command Interpreter Version 12.2.0.1.160823 OGGCORE_OGGADP.12.2.0.1.0_PLATFORMS_161019.1437 Linux, x64, 64bit (optimized), Generic on Oct 19 2016 16:01:40 Operating system character set identified as UTF-8. Copyright (C) 1995, 2016, Oracle and/or its affiliates. All rights reserved. GGSCI (edvmr1p0) 1> create subdirs Creating subdirectories under current directory /u01/app/oggtrg Parameter files /u01/app/oggtrg/dirprm: created Report files /u01/app/oggtrg/dirrpt: created Checkpoint files /u01/app/oggtrg/dirchk: created Process status files /u01/app/oggtrg/dirpcs: created SQL script files /u01/app/oggtrg/dirsql: created Database definitions files /u01/app/oggtrg/dirdef: created Extract data files /u01/app/oggtrg/dirdat: created Temporary files /u01/app/oggtrg/dirtmp: created Credential store files /u01/app/oggtrg/dircrd: created Masterkey wallet files /u01/app/oggtrg/dirwlt: created Dump files /u01/app/oggtrg/dirdmp: created GGSCI (edvmr1p0) 2> edit param mgr GGSCI (edvmr1p0) 3> start mgr Manager started. GGSCI (edvmr1p0) 4> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING GGSCI (edvmr1p0) 5> view param mgr Port 7909 DynamicPortList 20100-20199 PurgeOldExtracts ./dirdat/pe*, UseCheckPoints, MinKeepHours 2 Autostart Replicat R* AUTORESTART Replicat *, WaitMinutes 1, Retries 3