当前位置:操作系统 > Unix/Linux >>

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> 
  
  可以执行了。
  
3. 进入ggsci 用create subdirs创建目录
   建议进入$ORACLE_BASE/ogg11目录:
  [oracle@dd1 ~]$ cd $ORACLE_BASE/ogg11
  [oracle@dd1 ogg11]$ 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> create subdirs
  
  Creating subdirectories under current directory /data/oracle/ogg11
  
  Parameter files                /data/oracle/ogg11/dirprm: created
  Report files                   /data/oracle/ogg11/dirrpt: created
  Checkpoint files               /data/oracle/ogg11/dirchk: created
  Process status files           /data/oracle/ogg11/dirpcs: created
  SQL script files               /data/oracle/ogg11/dirsql: created
  Database definitions files     /data/oracle/ogg11/dirdef: created
  Extract data files             /data/oracle/ogg11/dirdat: created
  Temporary files                /data/oracle/ogg11/dirtmp: created
  Veridata files                 /data/oracle/ogg11/dirver: created
  Veridata Lock files            /data/oracle/ogg11/dirver/lock: created
  Veridata Out-Of-Sync files     /data/oracle/ogg11/dirver/oos: created
  Veridata Out-Of-Sync XML files /data/oracle/ogg11/dirver/oosxml: created
  Veridata Parameter files       /data/oracle/ogg11/dirver/params: created
  Veridata Report files          /data/oracle/ogg11/dirver/report: created
  Veridata Status files          /data/oracle/ogg11/dirver/status: created
  Veridata Trace files           /data/oracle/ogg11/dirver/trace: created
  Stdout files                   /data/oracle/ogg11/dirout: created
  
  GGSCI (dd1) 2> exit
  
  GoldenGate安装完成,以上配置安装两个节点都要执行。
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,