设为首页 加入收藏

TOP

GoldenGate配置(四)之veridata配置(三)
2014-11-24 07:31:21 来源: 作者: 【 】 浏览:10
Tags:GoldenGate 配置 veridata
tatus: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

首页 上一页 1 2 3 4 下一页 尾页 3/4/4
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇【机房收费系统】数据库设计 下一篇NoSQL-Column-HBase数据模型

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·在 Redis 中如何查看 (2025-12-26 03:19:03)
·Redis在实际应用中, (2025-12-26 03:19:01)
·Redis配置中`require (2025-12-26 03:18:58)
·Asus Armoury Crate (2025-12-26 02:52:33)
·WindowsFX (LinuxFX) (2025-12-26 02:52:30)