Differences

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

--- oracle_goldengate_bigdata_install_config [2020/11/11 13:43] – [Overview] 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 |}}
+{{:jmsarch.jpg?500|}}
 =====Installation=====
@@ Line 50: / Line 50: @@
 SETENV (ORACLE_HOME='/u01/app/oracle/product/12.1.0.2/db_1')
 UserIdAlias oggadmin
-rmthost localhost, mgrport 7909
+rmthost remotehost, mgrport 7909
 rmttrail ./dirdat/dp
 Table oggsrc.*;
@@ Line 69: / Line 69: @@
 </Code>
+<Code:bash|Commands to be executed>
-=====Configure Destination=====
+start mgr
-The destination will accept the data from the source (standard Oracle Golden Gate) and send it to ActiveMQ via Java Handler
+dblogin useridalias oggadmin
+register extract priex database
-====Configure Manager====
+add extract priex, integrated tranlog, begin now
+add exttrail ./dirdat/in, extract priex, megabytes 10
-<Code:bash|Configure Oracle Golden Gate for Big Data>
+add extract dpump, exttrailsource ./dirdat/in
-[oracle@edvmr1p0 oggtrg]$ ggsci
+add rmttrail ./dirdat/dp, extract dpump, megabytes 10
+start priex
-Oracle GoldenGate Command Interpreter
+start dpump
-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
 </Code>
-====Configure Replicat====
-<Code:bash |Add Replicat>
-GGSCI (edvmr1p0) 3> edit param jmsrep
-REPLICAT JMSREP
-getEnv (JAVA_HOME)
-getEnv (LD_LIBRARY_PATH)
-getEnv (PATH)
-TARGETDB LIBFILE libggjava.so SET property=dirprm/jmsrep.properties
-MAP oggsrc.*, TARGET oggsrc.*;
-GGSCI (edvmr1p0) 4> add replicat jmsrep, exttrail ./dirdat/dp
-REPLICAT added.
-</Code>
-Create the Java Adapter Properties file: jmsrep.properties
-<Code:bash|Edit jmsrep.properties>
-vi /u01/app/oggtrg/dirprm/jmsrep.properties
-##
-gg.handlerlist=jms
-## JNDI settings
-java.naming.provider.url=tcp://localhost:61616
-java.naming.factory.initial=org.apache.activemq.jndi.ActiveMQInitialContextFactory
-##
-gg.handler.jms.type=jms
-gg.handler.jms.destinationType=queue
-gg.handler.jms.destination=dynamicQueues/ggdemo.queueA
-gg.handler.jms.connectionFactory=ConnectionFactory
-gg.handler.jms.mode=op
-gg.handler.jms.format=xml2
-gg.log.level=debug
-gg.log=log4j
-goldengate.userexit.timestamp=utc
-goldengate.userexit.nochkpt=true
-jvm.bootoptions=-Djava.class.path=.:ggjava/ggjava.jar:dirprm:/opt/activemq/activemq-all-5.14.3.jar:/opt/activemq/lib/optional/log4j-1.2.17.jar:/opt/activemq/lib/optional/slf4j-log4j12-1.7.13.jar -Dlog4j.configuration=log4j.properties -Xmx512m -Xmx64m
-:wq
-</Code>