GoldenGate单向表DML同步

GoldenGate单向表DML同步

实验环境：
 

  node1:
  RedHat 5.5  Oracle 11.0.2.3  host:192.168.130.168
  goldengate: fbo_ggs_Linux_x64_ora11g_64bit.zip
 
  node2:
  redhat 5.5  oracle 11.0.2.3  host:192.168.130.171
  goldengate: fbo_ggs_Linux_x64_ora11g_64bit.zip
 

1. 解压goldengate软件
 
  下载地址：http://www.oracle.com/technetwork/middleware/goldengate/overview/index.html
 
  [root@dd1 soft]# ll
  total 90588
  drwxrwxrwx 8 root root    4096 Apr  7 17:19 database
  -rw-r--r-- 1 root root 92502371 Oct 29 21:05 fbo_ggs_Linux_x64_ora11g_64bit.zip
  -rwxr-xr-x 1 root root  251438 Apr  8 17:40 rlwrap-0.37.tar.gz
 
  [root@dd1 soft]# unzip fbo_ggs_Linux_x64_ora11g_64bit.zip
  Archive:  fbo_ggs_Linux_x64_ora11g_64bit.zip
    inflating: fbo_ggs_Linux_x64_ora11g_64bit.tar 
    inflating: OGG_WinUnix_Rel_Notes_11.1.1.1.2.pdf 
    inflating: Oracle_GoldenGate_11.1.1.1_README.txt
   
  解压至oracle base目录下
  [root@dd1 soft]# chmod 777 fbo_ggs_Linux_x64_ora11g_64bit.tar
  [root@dd1 soft]# su - oracle
  [root@dd1 soft]# mkdir /data/oracle/ogg11
  [oracle@dd1 ~]$ tar -xvf /opt/soft/fbo_ggs_Linux_x64_ora11g_64bit.tar -C /data/oracle/ogg11/
 
 
 
2. 配置环境变量：
    配置前bash_profile文件内容：
  [oracle@dd1 ~]$ cat .bash_profile
  # .bash_profile
 
  # Get the aliases and functions
  if [ -f ~/.bashrc ]; then
          . ~/.bashrc
  fi
 
  # User specific environment and startup programs
 
  PATH=$PATH:$HOME/bin
 
  export PATH
 
  export ORACLE_BASE=/data/oracle
  export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
  PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
  export ORACLE_SID=test1
  export PATH
 
  alias sqlplus="rlwrap sqlplus"
  alias rman="rlwrap rman"
 
  配置后：
  [oracle@dd1 ~]$ vi .bash_profile
 
  # .bash_profile
 
  # Get the aliases and functions
  if [ -f ~/.bashrc ]; then
          . ~/.bashrc
  fi
 
  # User specific environment and startup programs
 
  PATH=$PATH:$HOME/bin
 
  export PATH
 
  export ORACLE_BASE=/data/oracle
  export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
  export LD_LIBRARY_PATH=$ORACLE_BASE/ogg11 ###
  PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin:$ORACLE_BASE/ogg11 ###
  export ORACLE_SID=test1
  export PATH
 
  alias sqlplus="rlwrap sqlplus"
  alias rman="rlwrap rman"
  alias rman="rlwrap ggsci" ###
 
  [oracle@dd1 ~]$ source .bash_profile
 
  测试ggsci命令是否可用：
  [oracle@dd1 ~]$ ggsci
  ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory
 
  根据上面的报错，在bash_profile里添加$ORACLE_HOME/lib：
  export LD_LIBRARY_PATH=$ORACLE_BASE/ogg11:$ORACLE_HOME/lib
 
  [oracle@dd1 ~]$ source .bash_profile
  [oracle@dd1 ~]$ ggsci
 
  Oracle GoldenGate Command Interpreter for Oracle
  Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
  Linux, x64, 64bit (optimized), Oracle 11g on Oct  4 2011 23:49:46
 
  Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
 
 
 
  GGSCI (dd1) 1>
 
  可以执行了。