Differences

This shows you the differences between two versions of the page.

--- oracle_goldengate_bigdata_install_config [2020/11/11 12:02] – andonovj
+++ oracle_goldengate_bigdata_install_config [2020/11/22 15:10] (current) – andonovj
@@ Line 2: / Line 2: @@
 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.
+{{:jmsarch.jpg?500|}}
 =====Installation=====
@@ Line 20: / Line 20: @@
 .....................................
 </Code>
+=====Configure Source=====
+The source is standard Oracle Golen Gate 12c and it just extract from a schema: oggsrc and send data to the replicat in a normal / standard way:
-=====Configuration=====
+<Code:bash|Configuration>
+GGSCI (edvmr1p0) 10> info all
-<Code:bash|Configure Oracle Golden Gate for Big Data>
+Program     Status      Group       Lag at Chkpt  Time Since Chkpt
-[oracle@edvmr1p0 oggtrg]$ ggsci
-Oracle GoldenGate Command Interpreter
+MANAGER     RUNNING
-Version 12.2.0.1.160823 OGGCORE_OGGADP.12.2.0.1.0_PLATFORMS_161019.1437
+EXTRACT     RUNNING     DPUMP       00:00:00      00:00:06
-Linux, x64, 64bit (optimized), Generic on Oct 19 2016 16:01:40
+EXTRACT     RUNNING     PRIEX       00:00:10      00:00:06
-Operating system character set identified as UTF-8.
-Copyright (C) 1995, 2016, Oracle and/or its affiliates. All rights reserved.
+GGSCI (edvmr1p0) 11> view param mgr
+PORT 7809
+DynamicPortList 20000-20099
+ACCESSRULE, PROG SERVER, ALLOW
+PurgeOldExtracts ./dirdat/*, UseCheckPoints, MinKeepHours 2
+Autostart Extract *
+AUTORESTART Extract *, WaitMinutes 1, Retries 3
-GGSCI (edvmr1p0) 1> create subdirs
-Creating subdirectories under current directory /u01/app/oggtrg
-Parameter files                /u01/app/oggtrg/dirprm: created
+GGSCI (edvmr1p0) 12> view param DPUMP
-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
+Extract dpump
+SETENV (ORACLE_SID='orcl')
+SETENV (ORACLE_HOME='/u01/app/oracle/product/12.1.0.2/db_1')
+UserIdAlias oggadmin
+rmthost remotehost, mgrport 7909
+rmttrail ./dirdat/dp
+Table oggsrc.*;
-GGSCI (edvmr1p0) 2> edit param mgr
+GGSCI (edvmr1p0) 13> view param PRIEX
+Extract priex
+SETENV (ORACLE_SID='orcl')
+SETENV (ORACLE_HOME='/u01/app/oracle/product/12.1.0.2/db_1')
+UserIdAlias oggadmin
+TranlogOptions IntegratedParams (max_sga_size 256)
+Exttrail ./dirdat/in
+LOGALLSUPCOLS
+UPDATERECORDFORMAT COMPACT
+GETUPDATEBEFORES
+Table oggsrc.*;
+</Code>
-GGSCI (edvmr1p0) 3> start mgr
+<Code:bash|Commands to be executed>
-Manager started.
+start mgr
+dblogin useridalias oggadmin
+register extract priex database
-GGSCI (edvmr1p0) 4> info all
+add extract priex, integrated tranlog, begin now
+add exttrail ./dirdat/in, extract priex, megabytes 10
-Program     Status      Group       Lag at Chkpt  Time Since Chkpt
+add extract dpump, exttrailsource ./dirdat/in
+add rmttrail ./dirdat/dp, extract dpump, megabytes 10
-MANAGER     RUNNING
+start priex
+start dpump
-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
 </Code>