实验环境:
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>
可以执行了。
