时间：2021-07-01 10:21:17 帮助过：30人阅读
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
环境：
|
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 Set |
ZHS16GBK |
ZHS16GBK |
|
ORACLE_SID |
PROD |
EMREP |
|
Listener Name/Port |
LISTENER/1521 |
LISTENER/1521 |
|
Goldengate User |
ogg |
ogg |
[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
[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
[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
[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
[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
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的配置完成