GoldenGate配置（四）之veridata配置 环境： Item Source System Target System Platform Red Hat Enterprise Linux Server release 5.4 Red Hat Enterprise Linux Server release 5.4 Hostname gc1 gc2 Database Oracle 10.2.0.1 Oracle 11.2.0.1 Character GoldenGate配置（四）之veridata配置
环境：
ItemSource SystemTarget SystemPlatformRed Hat EnterpriseLinux Server release 5.4Red Hat EnterpriseLinux Server release 5.4Hostnamegc1gc2DatabaseOracle 10.2.0.1Oracle 11.2.0.1Character SetZHS16GBKZHS16GBKORACLE_SIDPRODEMREPListener Name/PortLISTENER/1521LISTENER/1521Goldengate Useroggogg gc1：创建目录[root@gc1~]#cd /u01/app[root@gc1app]#ls ogg oracle[root@gc1app]#mkdir veridata[root@gc1app]#ls ogg oracle veridata[root@gc1app]#chown -R oracle:oinstall /u01/app/veridata[root@gc1app]#ls -ll total 12 drwxrwxr-x 13 oracle oinstall 4096 Jun 18 21:55ogg drwxr-xr-x 7 oracle oinstall 4096 Jun 13 01:04 oracle drwxr-xr-x 2 oracle oinstall 4096Jun 18 23:10 veridata gc2：创建目录[root@gc2~]#cd /u01/app[root@gc2app]#ls ogg oracle oraInventory[root@gc2app]#mkdir veridata[root@gc2app]#chown -R oracle:oinstall /u01/app/veridata[root@gc2app]#ls -ll total 16 drwxr-xr-x 13 oracle oinstall 4096 Jun 18 22:06ogg drwxr-xr-x 8 oracle oinstall 4096 Jan 23 19:14 oracle drwxrwx--- 5 oracle oinstall 4096 Jan 23 19:12 oraInventory drwxr-xr-x 2 oracle oinstall 4096Jun 18 23:12 veridata gc1：MGR配置[oracle@gc1~]$cd /u01/app/veridata[oracle@gc1veridata]$ls veridata-cagent.zip[oracle@gc1veridata]$unzip veridata-cagent.zip Archive: veridata-cagent.zip inflating:ggs_veridataAgent_redhatAS40_x86_ora10g_32bit_v3.0.0.2_001.tar[oracle@gc1veridata]$tar-xvf ggs_veridataAgent_redhatAS40_x86_ora10g_32bit_v3.0.0.2_001.tar veridata/ veridata/agent/ veridata/agent/bcrypt.txt veridata/agent/freeBSD.txt veridata/agent/ggMessage.dat veridata/agent/ggsci veridata/agent/help.txt veridata/agent/libicudata.so.38 veridata/agent/libicui18n.so.38 veridata/agent/libicuuc.so.38 veridata/agent/libxml2.txt veridata/agent/mgr veridata/agent/notices.txt veridata/agent/veriagt veridata/agent/zlib.txt[oracle@gc1veridata]$ls ggs_veridataAgent_redhatAS40_x86_ora10g_32bit_v3.0.0.2_001.tar veridata veridata-cagent.zip[oracle@gc1veridata]$cd veridata[oracle@gc1veridata]$ls agent[oracle@gc1veridata]$cd agent[oracle@gc1agent]$ls bcrypt.txt ggMessage.dat help.txt libicui18n.so.38 libxml2.txt notices.txt zlib.txt freeBSD.txt ggsci libicudata.so.38 libicuuc.so.38 mgr veriagt[oracle@gc1agent]$./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 10.4.0.19 Build 003 Linux, x86, 32bit (optimized), Oracle 10 on Sep20 2009 20:57:49 Copyright (C) 1995, 2009, Oracle and/or itsaffiliates. All rights reserved.
SCI(gc1) 1>create subdirs Creating subdirectories under current directory/u01/app/veridata/veridata/agent Parameter files /u01/app/veridata/veridata/agent/dirprm: created Report files /u01/app/veridata/veridata/agent/dirrpt: created Checkpoint files /u01/app/veridata/veridata/agent/dirchk: created Process status files /u01/app/veridata/veridata/agent/dirpcs: created SQL script files /u01/app/veridata/veridata/agent/dirsql: created Database definitions files /u01/app/veridata/veridata/agent/dirdef:created Extract data files /u01/app/veridata/veridata/agent/dirdat: created Temporary files /u01/app/veridata/veridata/agent/dirtmp:created Veridata files /u01/app/veridata/veridata/agent/dirver: created Veridata Lock files /u01/app/veridata/veridata/agent/dirver/lock: created Veridata Out-Of-Sync files /u01/app/veridata/veridata/agent/dirver/oos:created Veridata Out-Of-Sync XML files/u01/app/veridata/veridata/agent/dirver/oosxml: created Veridata Parameter files /u01/app/veridata/veridata/agent/dirver/params: created Veridata Report files /u01/app/veridata/veridata/agent/dirver/report:created Veridata Status files /u01/app/veridata/veridata/agent/dirver/status: created Veridata Trace files /u01/app/veridata/veridata/agent/dirver/trace: created Stdout files /u01/app/veridata/veridata/agent/dirout:created GGSCI(gc1) 2>EDIT PARAMS MGR --添加红色部分PORT 7788~"dirprm/mgr.prm" [New] 1L, 10C written GGSCI(gc1) 3>STARTMANAGER Manager started.
GGSCI(gc1) 4>info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING gc2：MGR配置[oracle@gc2app]$cd veridata/[oracle@gc2veridata]$ls veridata-cagent.zip[oracle@gc2veridata]$unzip veridata-cagent.zip Archive: veridata-cagent.zip inflating: ggs_veridataAgent_redhatAS40_x86_ora10g_32bit_v3.0.0.2_001.tar[oracle@gc2veridata]$tar -xvfggs_veridataAgent_redhatAS40_x86_ora10g_32bit_v3.0.0.2_001.tar veridata/ veridata/agent/ veridata/agent/bcrypt.txt veridata/agent/freeBSD.txt veridata/agent/ggMessage.dat veridata/agent/ggsci veridata/agent/help.txt veridata/agent/libicudata.so.38 veridata/agent/libicui18n.so.38 veridata/agent/libicuuc.so.38 veridata/agent/libxml2.txt veridata/agent/mgr veridata/agent/notices.txt veridata/agent/veriagt veridata/agent/zlib.txt[oracle@gc2veridata]$cd veridata/agent/[oracle@gc2agent]$ls bcrypt.txt ggMessage.dat help.txt libicui18n.so.38 libxml2.txt notices.txt zlib.txt freeBSD.txt ggsci libicudata.so.38 libicuuc.so.38 mgr veriagt[oracle@gc2agent]$./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 10.4.0.19 Build 003 Linux, x86, 32bit (optimized), Oracle 10 on Sep20 2009 20:57:49 Copyright (C) 1995, 2009, Oracle and/or itsaffiliates. All rights reserved.
GGSCI(gc2) 1>create subdirs Creating subdirectories under current directory/u01/app/veridata/veridata/agent Parameter files /u01/app/veridata/veridata/agent/dirprm: created Report files /u01/app/veridata/veridata/agent/dirrpt: created Checkpoint files /u01/app/veridata/veridata/agent/dirchk:created Process status files /u01/app/veridata/veridata/agent/dirpcs: created SQL script files /u01/app/veridata/veridata/agent/dirsql: created Database definitions files /u01/app/veridata/veridata/agent/dirdef:created Extract data files /u01/app/veridata/veridata/agent/dirdat: created Temporary files /u01/app/veridata/veridata/agent/dirtmp: created Veridata files /u01/app/veridata/veridata/agent/dirver:created Veridata Lock files /u01/app/veridata/veridata/agent/dirver/lock: created Veridata Out-Of-Sync files /u01/app/veridata/veridata/agent/dirver/oos: created Veridata Out-Of-Sync XML files/u01/app/veridata/veridata/agent/dirver/oosxml: created Veridata Parameter files /u01/app/veridata/veridata/agent/dirver/params: created Veridata Report files /u01/app/veridata/veridata/agent/dirver/report: created Veridata Status files /u01/app/veridata/veridata/agent/dirver/status:created Veridata Trace files /u01/app/veridata/veridata/agent/dirver/trace: created Stdout files /u01/app/veridata/veridata/agent/dirout: created GGSCI(gc2) 2>EDIT PARAMS MGR --添加红色内容PORT 7788~"dirprm/mgr.prm" [New] 1L, 10C written GGSCI(gc2) 3>START MANAGER Manager started.
GGSCI(gc2) 4>info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING gc1：server安装与配置[oracle@gc1veridata]$ls ggs_veridataAgent_redhatAS40_x86_ora10g_32bit_v3.0.0.2_001.tar veridata veridata-cagent.zip veridata-server.zip[oracle@gc1veridata]$unzip veridata-server.zip Archive: veridata-server.zip inflating: GoldenGate_Veridata_redhatAS40_x86_v3006_002.sh inflating: OGG_Veridata_Rel_Notes_3_0_0_6_002.pdf inflating: README.txt[oracle@gc1veridata]$ls -l total 414340-rwxr-x--- 1 oracle oinstall 30556160 Sep 29 2009ggs_veridataAgent_redhatAS40_x86_ora10g_32bit_v3.0.0.2_001.tar-rwxr-xr-x 1 oracle oinstall 190415253 Aug 6 2010GoldenGate_Veridata_redhatAS40_x86_v3006_002.sh-rwxrwxr-x 1 oracle oinstall 92348 Sep 14 2010 OGG_Veridata_Rel_Notes_3_0_0_6_002.pdf-rwxrwxr-x 1 oracle oinstall 9158 Mar 26 2010 README.txt drwxr-x--- 3 oracle oinstall 4096 Sep 21 2009 veridata-rw-r--r-- 1 oracle oinstall 12202562 Jun 18 23:20 veridata-cagent.zip-rw-r--r-- 1 oracle oinstall 190549579 Jun 1823:43 veridata-server.zip
gc1：
SQL>create user veridata identified by veridata;SQL>create role veridata_role;SQL>grant create session,create table,create view,createprocedure,create synonym to veridata_role;SQL>grant veridata_role to veridata;SQL>alter user veridata quota unlimited on users;SQL>grant dba to veridata;- - 打开xstart，如果提示要创建一个session name，就先给这个对话起个名，然后输入host，protocol选择sshcommand选择3 xterm（linux type 2）然后点run启动，如下图所示#xhost +图形化配置--图形界面运行./GoldenGate_Veridata_redhatAS40_x86_v3006_002.sh
用户名：
veridata
密码：
oracle[oracle@gc1 admin]$vi tnsnames.ora PROD =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST= 192.168.17.116)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = PROD)))[oracle@gc1 admin]$lsnrctl start--启动veridata服务[oracle@gc1 bin]$cd /home/oracle/Oracle_GoldenGate_Veridata/server/bin[oracle@gc1 bin]$./veridata_server.shstart[oracle@gc1 bin]$ps -ef|grep -iveridata oracle 4774 1 0 Jun18 ? 00:00:00 ./mgr PARAMFILE/u01/app/veridata/veridata/agent/dirprm/mgr.prm REPORTFILE/u01/app/veridata/veridata/agent/dirrpt/MGR.rpt PROCESSID MGR PORT 7809 oracle 9793 1 0 01:04 pts/2 00:00:00/home/oracle/Oracle_GoldenGate_Veridata/server/bin/veridata oracle 9814 4722 0 01:05 pts/2 00:00:00 grep -i veridata--启动veridata的web服务[oracle@gc1 bin]$cd/home/oracle/Oracle_GoldenGate_Veridata/web/bin[oracle@gc1 bin]$./veridata_web.shstart CATALINA_HOME:/home/oracle/Oracle_GoldenGate_Veridata/web JRE_HOME:/home/oracle/Oracle_GoldenGate_Veridata/jre JAVA_OPTS:-Xmx512m -Djava.awt.headless=true-Dveridata.log.dir=/home/oracle/Oracle_GoldenGate_Veridata/shared/logs UsingCATALINA_BASE: /home/oracle/Oracle_GoldenGate_Veridata/web UsingCATALINA_HOME: /home/oracle/Oracle_GoldenGate_Veridata/web UsingCATALINA_TMPDIR: /home/oracle/Oracle_GoldenGate_Veridata/web/temp UsingJRE_HOME: /home/oracle/Oracle_GoldenGate_Veridata/jre
用户名：
veridata
密码：
oracle
网页登陆：
http://192.168.17.116:8830
gc2：
SQL>create user veridata identified by veridata;User created.
SQL>grant dba to veridata;Grant succeeded.
注意：此处可添加profile配置（此文未添加），可用于将结果添加到profile文件中。
--如上图点击“RunJob”后，待job运行完毕后，如下查看结果：--至此，对于veridata的配置完成