您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

GoldenGate单向表DML同步

2024/11/8 14:18:34发布27次查看
实验环境: node1: redhat 5.5 oracle 11.0.2.3 host:192.168.130.168 goldengate: fbo_ggs_linux_x64_ora11g_64bit.zi
实验环境:
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软件
下载地址:
[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>
可以执行了。
该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product