Differences

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

--- oracle_goldengate_bigdata_install_config [2020/11/11 11:57] – created 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 19: / Line 19: @@
 AdapterExamples/
 .....................................
+</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:
+<Code:bash|Configuration>
+GGSCI (edvmr1p0) 10> info all
+Program     Status      Group       Lag at Chkpt  Time Since Chkpt
+MANAGER     RUNNING
+EXTRACT     RUNNING     DPUMP       00:00:00      00:00:06
+EXTRACT     RUNNING     PRIEX       00:00:10      00:00:06
+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) 12> view param DPUMP
+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) 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>
+<Code:bash|Commands to be executed>
+start mgr
+dblogin useridalias oggadmin
+register extract priex database
+add extract priex, integrated tranlog, begin now
+add exttrail ./dirdat/in, extract priex, megabytes 10
+add extract dpump, exttrailsource ./dirdat/in
+add rmttrail ./dirdat/dp, extract dpump, megabytes 10
+start priex
+start dpump
 </Code>