GoldenGate组态(四)它veridata组态
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 Set |
ZHS16GBK |
ZHS16GBK |
ORACLE_SID |
PROD |
EMREP |
Listener Name/Port |
LISTENER/1521 |
LISTENER/1521 |
Goldengate User |
ogg |
ogg |
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启动。例如以下图所看到的
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
#xhost +
图形化配置
--图形界面执行./GoldenGate_Veridata_redhatAS40_x86_v3006_002.sh
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
username:veridata
password:oracle
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
[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
username:veridata
password:oracle
网页登陆:http://192.168.17.116:8830
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
gc2:
SQL>create user veridata identified by veridata;
User created.
SQL>grant dba to veridata;
Grant succeeded.
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
注意:此处可加入profile配置(此文未加入)。可用于将结果加入到profile文件里。
--如上图点击“RunJob”后,待job执行完成后,例如以下查看结果:
watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaHVhbmd5YW5sb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">
--至此。对于veridata的配置完毕
版权声明:本文博客原创文章。博客,未经同意,不得转载。
最新文章
- my first go
- postgresql运维
- iOS Error
- android Error occurred during initialization of VM Could not reserve enough space for object heap Could not create the Java virtual machine.
- Win7家庭版开启Administrator管理员帐户的方法
- UWP入门一 7天酒店客户端源码及说明
- PHP第一课笔记
- iOS 自动布局过程
- AIX误删除LV后如何进行现场保护和数据恢复工作
- CheckForIllegalCrossThreadCalls = false
- Linux信号实践(5) --时间与定时器
- Linux Logwatch的学习总结
- gitlab备份
- vue element-ui 绑定@keyup事件无效
- logging模块--日志文件
- RequireJS跨域加载html模版后被转成JS问题分析及解决
- BZOJ3499 : PA2009 Quasi-template
- PyQt5学习笔记14----初识pyqt多线程操作
- Nunit与Vs 2012配合使用
- vb6 使用msxml2.serverxmlhttp 请求HTTP