Item |
Source System |
Target System |
Platform |
OEL5.4 |
OEL5.4 |
Hostname |
gc1 |
oraclelinux54.cuug.net |
Database |
Oracle 10.2.0.5 |
Oracle 11.2.0.3 |
Character Set |
Zhs16gbk |
Zhs16gbk |
ORACLE_SID |
PROD |
TDB112 |
Listener Name/Port |
LISTENER/1521 |
LISTENER/1521 |
Goldengate User |
ogg |
ogg |
确保两个数据库的字符集一致,防止传输出现乱码
Install Goldengate 11g on Linux--------------------------------------------------------------------
1.1Create install directory and unzip downloaded file on both system
For source system(gc2):
[oracle@gc1:/home/oracle]$mkdir -p /u01/app/ogg
[oracle@gc1:/home/oracle]$cp V18156-01-linux.zip /u01/app/ogg
[oracle@gc1:/home/oracle]$cd /u01/app/ogg
[oracle@gc1:/u01/app/ogg]$unzip V18156-01-linux.zip
[oracle@gc1:/u01/app/ogg]$tar -xvf ggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar
For target system(oraclelinux54.cuug.net):
[oracle@oraclelinux54.cuug.net:/u01]$mkdir -p /u01/app/ogg
[oracle@oraclelinux54.cuug.net:/home/oracle]$cp V18156-01-linux.zip /u01/app/ogg
[oracle@oraclelinux54.cuug.net:/home/oracle]$cd /u01/app/ogg
[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$unzip V18156-01-linux.zip
[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$tar -xvf ggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar
1.2Create sub working directories for Goldengate
For both Source system and Target system:
[oracle@~]$ vi .bash_profile
export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
[oracle@oraclelinux54.cuug.net:/home/oracle]$cd /u01/app/ogg
[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$./ggsci
./ggsci: error while loading shared libraries: libnnz10.so: cannot open shared object file: No such file or directory
[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$cd $ORACLE_HOME/lib
[oracle@oraclelinux54.cuug.net:/u01/app/oracle/product/11.2.0/dbhome_1/lib]$ ln -s libnnz11.so libnnz10.so //建立一个链接,让 libnnz10.so指向libnnz11.so
[oracle@oraclelinux54.cuug.net:/u01/app/oracle/product/11.2.0/dbhome_1/lib]$cd /u01/app/ogg
[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.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 (oraclelinux54.cuug.net) 1> create subdirs //在当前路径下创建
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 files /u01/app/ogg/dirver: created
Veridata Lock files /u01/app/ogg/dirver/lock: created
Veridata Out-Of-Sync files /u01/app/ogg/dirver/oos: created
Veridata Out-Of-Sync XML files /u01/app/ogg/dirver/oosxml: created
Veridata Parameter files /u01/app/ogg/dirver/params: created
Veridata Report files /u01/app/ogg/dirver/report: created
Veridata Status files /u01/app/ogg/dirver/status: created
Veridata Trace files /u01/app/ogg/dirver/trace: created
Stdout files /u01/app/ogg/dirout: created
Above directories are created for following purpose:
Name |
Purpose |
dirchk |
Checkpoint files |
dirdat |
GoldenGate trails |
dirdef |
Data definition files |
dirprm |
Parameter files |
dirpcs |
Process status files |
dirrpt |
Report files |
dirsql |
SQL script files |
dirtmp |
Temporary files |
Introduction to the Command Interface---------------------------------------------------------
View HELP summary for all commands
GGSCI> HELP
GGSCI> HELP ALL
View HELP summary for a COMMAND/ENTITY
GGSCI> HELP ADD EXTRACT
GGSCI> HELP ADD EXTTRAIL