GoldenGate配置(一)之单向复制配置(一)

2015-07-24 10:24:03 ? 作者: ? 浏览: 6

GoldenGate配置(一)之单向复制配置

环境:

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

单向复制配置

--环境变量里添加如下内容

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib

gc1:解压GoldenGate安装包

[oracle@gc1 ~]$ mkdir -p/u01/app/ogg

[oracle@gc1 ~]$ cd /u01/app/ogg

[oracle@gc1 ogg]$ ls

V18156-01-linux.zip

[oracle@gc1 ogg]$ unzipV18156-01-linux.zip

[oracle@gc1 ogg]$ tar -xvfggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar

gc2:解压GoldenGate安装包

[oracle@gc2 ~]$ mkdir -p/u01/app/ogg

[oracle@gc2 ~]$ cd /u01/app/ogg

[oracle@gc2 ogg]$ ls

V18156-01-linux.zip

[oracle@gc2 ogg]$ unzipV18156-01-linux.zip

[oracle@gc2 ogg]$ tar -xvfggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar

gc1:配置环境变量、建立相关子目录

[oracle@gc1 ~]$ vi .bash_profile

添加exportLD_LIBRARY_PATH=$ORACLE_HOME/lib

[oracle@gc1~]$ source .bash_profile

[oracle@gc1ogg]$ ./ggsci

OracleGoldenGate Command Interpreter for Oracle

Version10.4.0.19 Build 002

Linux, x86,32bit (optimized), Oracle 10 on Sep 17 2009 23:49:42?

Copyright (C)1995, 2009, Oracle and/or its affiliates. All rights reserved.

GGSCI (gc1)1> createsubdirs

Creatingsubdirectories under current directory /u01/app/ogg?

Parameterfiles /u01/app/ogg/dirprm: created

Reportfiles /u01/app/ogg/dirrpt: created

Checkpointfiles /u01/app/ogg/dirchk:created

Process statusfiles /u01/app/ogg/dirpcs:created

SQL scriptfiles /u01/app/ogg/dirsql:created

Databasedefinitions files /u01/app/ogg/dirdef: created

Extract datafiles /u01/app/ogg/dirdat:created

Temporaryfiles /u01/app/ogg/dirtmp:created

Veridatafiles /u01/app/ogg/dirver: created

Veridata Lockfiles /u01/app/ogg/dirver/lock: created

VeridataOut-Of-Sync files /u01/app/ogg/dirver/oos: created

VeridataOut-Of-Sync XML files /u01/app/ogg/dirver/oosxml: created

VeridataParameter files /u01/app/ogg/dirver/params: created

Veridata Reportfiles /u01/app/ogg/dirver/report: created

Veridata Statusfiles /u01/app/ogg/dirver/status: created

Veridata Tracefiles /u01/app/ogg/dirver/trace: created

Stdoutfiles /u01/app/ogg/dirout:created?

gc2:配置环境变量、建立相关子目录

[oracle@gc2 ~]$ vi .bash_profile

添加exportLD_LIBRARY_PATH=$ORACLE_HOME/lib

[oracle@gc2~]$ source .bash_profile

[oracle@gc2db_1]$ cd $ORACLE_HOME/lib

[oracle@gc2lib]$ ln -s libnnz11.so libnnz10.so

[oracle@gc2ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 10.4.0.19 Build 002

Linux, x86, 32bit (optimized), Oracle 10 on Sep17 2009 23:49:42?

Copyright (C) 1995, 2009, Oracle and/or itsaffiliates. All rights reserved.

GGSCI (gc2) 1> createsubdirs

Creating subdirectories under current directory/u01/app/ogg?

Parameter files /u01/app/ogg/dirprm: created

Report files /u01/app/ogg/dirrpt: created

Checkpoint files /u01/app/ogg/dirchk: created

Process status files /u01/app/ogg/dirpcs: created

SQL script files /u01/app/ogg/dirsql: created

Database definitions files /u01/app/ogg/dirdef: created

Extract data files /u01/app/ogg/dirdat: created

Temporary files /u01/app/ogg/dirtmp: created

Veridata

-->

评论

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