Differences

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

--- oracle_goldengate_bigdata_install_config [2020/11/11 12:15] – [Add Replicat] 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:
-====Configure Manager====
+<Code:bash|Configuration>
+GGSCI (edvmr1p0) 10> info all
-<Code:bash|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
+EXTRACT     RUNNING     DPUMP       00:00:00      00:00:06
+EXTRACT     RUNNING     PRIEX       00:00:10      00:00:06
-GGSCI (edvmr1p0) 5> view param mgr
+GGSCI (edvmr1p0) 11> view param mgr
-Port 7909
+PORT 7809
-DynamicPortList 20100-20199
+DynamicPortList 20000-20099
-PurgeOldExtracts ./dirdat/pe*, UseCheckPoints, MinKeepHours 2
+ACCESSRULE, PROG SERVER, ALLOW
-Autostart Replicat R*
+PurgeOldExtracts ./dirdat/*, UseCheckPoints, MinKeepHours 2
-AUTORESTART Replicat *, WaitMinutes 1, Retries 3
+Autostart Extract *
-</Code>
+AUTORESTART Extract *, WaitMinutes 1, Retries 3
-====Configure Replicat====
-<Code:bash |Add Replicat>
-GGSCI (edvmr1p0) 3> edit param jmsrep
-REPLICAT JMSREP
+GGSCI (edvmr1p0) 12> view param DPUMP
-getEnv (JAVA_HOME)
-getEnv (LD_LIBRARY_PATH)
-getEnv (PATH)
-TARGETDB LIBFILE libggjava.so SET
-property=dirprm/jmsrep.properties
-MAP oggsrc.*, TARGET oggsrc.*;
+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) 4> add replicat jmsrep, exttrail ./dirdat/dp
-REPLICAT added.
-</Code>
-Create the Java Adapter Properties file: jmsrep.properties
+GGSCI (edvmr1p0) 13> view param PRIEX
-<Code:bash|Edit jmsrep.properties>
+Extract priex
-vi /u01/app/oggtrg/dirprm/jmsrep.properties
+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>
-gg.handlerlist=jms
+start mgr
-## JNDI settings
+dblogin useridalias oggadmin
-java.naming.provider.url=tcp://localhost:61616
+register extract priex database
-java.naming.factory.initial=org.apache.activemq.jndi.ActiveMQIni
+add extract priex, integrated tranlog, begin now
-tialContextFactory
+add exttrail ./dirdat/in, extract priex, megabytes 10
-##
+add extract dpump, exttrailsource ./dirdat/in
-gg.handler.jms.type=jms
+add rmttrail ./dirdat/dp, extract dpump, megabytes 10
-gg.handler.jms.destinationType=queue
+start priex
-gg.handler.jms.destination=dynamicQueues/ggdemo.queueA
+start dpump
-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>