oracle linux ogg,Linux下单机OGG同步oracle11g

Linux下单机OGG同步oracle11g DB测试

(2013-12-13 10:49:44)

一、安装goldengate软件

1.测试环境：

OS: redhat 6 64bit

DB: oracle 11.2.0.3 64bit

查看OS和DB版本

[oracle@redhat6 ~]$ uname -a

Linux redhat6 2.6.32-131.0.15.el6.x86_64 #1 SMP Tue May 10 15:42:40 EDT 2011 x86_64 x86_64x86_64 GNU/Linux

SQL> select * from v$version where rownum=1;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

1.2.安装OGG

[oracle@redhat6 ~]$ cd /u01/ogg

[oracle@redhat6 ogg]$unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

[oracle@redhat6 ogg]$ tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar

1.3.添加环境变量

[oracle@redhat6 ogg]$ vi /home/oracle/.bash_profile

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export LD_LIBRARY_PATH

export PATH=/u01/ogg:$PATH

export GGATE=/u01/ogg

1.4.使用ggsci工具创建目录

[oracle@redhat6 ogg]$ ./ggsci