博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
GoldenGate组态(四)它veridata组态
阅读量:5868 次
发布时间:2019-06-19

本文共 9804 字,大约阅读时间需要 32 分钟。

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启动。例如以下图所看到的

#xhost +

图形化配置

--图形界面执行./GoldenGate_Veridata_redhatAS40_x86_v3006_002.sh

username:veridata

password: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

 

username:veridata

password: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的配置完毕

版权声明:本文博客原创文章。博客,未经同意,不得转载。

你可能感兴趣的文章
Maximizing Battery Life
查看>>
ActiveMQ(10):ActiveMQ的静态网络链接
查看>>
多线程编程(2) - 从 CreateThread 说起
查看>>
给在生产环境下给php安装apc加速扩展脚本
查看>>
ini 文件操作记要(1): 使用 TIniFile
查看>>
再学 GDI+[33]: TGPPen - 画笔的几何变换 - SetTransform
查看>>
我的友情链接
查看>>
c#对字符串的各种操作
查看>>
jstat命令详解
查看>>
as3.0 切分位图
查看>>
Oracle维护命令合集
查看>>
zabbix监控部署
查看>>
关于Tomcat下项目中文名在Windows和Linux下编码混乱问题解决
查看>>
Android 系统 root 破解原理分析
查看>>
iptables模板
查看>>
关于redux-saga中take使用方法
查看>>
SVN部署(一)
查看>>
RabbitMQ3.6.3集群搭建+HAProxy1.6做负载均衡
查看>>
内容营销11金规
查看>>
成大事必备的9种心态
查看>>