oracle rptdate,Oracle GoldenDate安装

首先到下载Oracle GoldenGate安装文件，注意在edelivery下载的时候查找GoldenGate时要选择“Oracle

Fusion Middleware”，然后选择好平台及对应的版本：

下载好GoldenDate软件后，安装过程是非常的简单，你可以就在oracle用户下安装，也可以创建一个专有用户来安装，假如，我们创建一个ogg的操作系统用户来安装GoldenDate，那么首先要设置好ogg的用户环境变量，你可以直接将oracle用户的环境变量copy过来使用：

export

ORACLE_BASE=/u01/app/oracle

export

ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

export

ORACLE_SID=source

export

ORACLE_PATH=$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin

export

PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin

export

PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

export

PATH=${PATH}:$ORACLE_BASE/common/oracle/bin

export

TNS_ADMIN=$ORACLE_HOME/network/admin

export TEMP=/tmp

export TMPDIR=/tmp

export

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

设置好环境变量后，确认LD_LIBRARY_PATH环境变量设置正确，到gg的安装目录下，通常是~/ggs/目录下运行ldd ggsci命令检查之：

[ogg@source ggs]$ ldd ggsci

libdl.so.2 => /lib64/libdl.so.2

(0x00000038d1d00000)

libicui18n.so.38 => ./libicui18n.so.38

(0x0000002a9556c000)

libicuuc.so.38 => ./libicuuc.so.38

(0x0000002a958cc000)

libicudata.so.38 =>

./libicudata.so.38 (0x0000002a95c05000)

libpthread.so.0 =>

/lib64/tls/libpthread.so.0 (0x00000038d1f00000)

libnnz10.so =>

/u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so (0x0000002a968dc000)

libclntsh.so.10.1 =>

/u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1 (0x0000002a96d7c000)

libstdc++.so.6 =>

/usr/lib64/libstdc++.so.6 (0x00000038d8600000)

libm.so.6 => /lib64/tls/libm.so.6

(0x00000038d1b00000)

libgcc_s.so.1 =>

/lib64/libgcc_s.so.1 (0x00000038d8200000)

libc.so.6 => /lib64/tls/libc.so.6

(0x00000038d1800000)

/lib64/ld-linux-x86-64.so.2 (0x00000038d1400000)

libnsl.so.1 => /lib64/libnsl.so.1

(0x00000038d9400000)

如上返回结果表示环境变量设置没有任何问题！接下来需要登录GoldenGate命令环境创建必要的子目录，进入GG命令环境的命令就是ggsci：

[ogg@source ggs]$ ./ggsci

Oracle GoldenGate Command

Interpreter for Oracle

Version 10.4.0.19 Build 002

Linux, x64, 64bit (optimized),

Oracle 10 on Sep 22 2009 14:18:08

Copyright (C) 1995, 2009,

Oracle and/or its affiliates.All rights

reserved.

--使用create subdirs名称创建gg需要使用的子目录

GGSCI (source) 1>create subdirs

Creating subdirectories under

current directory /ggs

Parameter files/ggs/dirprm: created

Report files/ggs/dirrpt: created

Checkpoint files/ggs/dirchk: created

Process status files/ggs/dirpcs: created

SQL script files/ggs/dirsql: created

Database definitions files/ggs/dirdef: created

Extract data files/ggs/dirdat: created

Temporary files/ggs/dirtmp: created

Veridata files/ggs/dirver: created

Veridata Lock files/ggs/dirver/lock: created

Veridata Out-Of-Sync files/ggs/dirver/oos: created

Veridata Out-Of-Sync XML files

/ggs/dirver/oosxml: created

Veridata Parameter files/ggs/dirver/params: created

Veridata Report files/ggs/dirver/report: created

Veridata Status files/ggs/dirver/status: created

Veridata Trace files/ggs/dirver/trace: created

Stdout files/ggs/dirout: created

GGSCI (source) 2> exit

[ogg@source ggs]$

这样Oracle GoldenGate就安装好了！简单吧？接下来我将会介绍如何使用它们！记住，GG只不过是一个工具，就像你安装ms office一样简单，但怎么使用好它还是要好好琢磨琢磨嘀