GoldenGate配置（四）之veridata配置

程序员文章站 2024-02-01 12:37:04

...

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配置

环境：

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

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

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