1.下载介质：

http://edelivery.oracle.com

下载相应的media pack

2.解压缩：

将下好的介质，通过ftp工具传输到装有oracle的节点上，比如我放在了：/tmp目录下

然后在oracle用户下的$ORACLE_BASE下创一个目录：gg11

将/tmp下的gg介质用 unzip 和tar -xvof 等命令，解压缩到目录gg11下

3.修改环境变量（适用于linux和solaris平台）

[oracle@ora11g ~]$ vi .bash_profile

ORACLE_BASE=/u01

ORACLE_HOME=/u01/oracle

ORACLE_SID=orcl

PATH=$ORACLE_HOME/bin:$ORACLE_BASE/gg11:$PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_BASE/gg11:$LD_LIBRARY_PATH

export ORACLE_BASE ORACLE_HOME ORACLE_SID

export PATH LD_LIBRARY_PATH

保存退出后运行：. ./.bash_profile 命令，使之生效

4.安装软件

[oracle@ora11g gg11]$ env |grep LD (确定一下自己的环境变量是否生效)

OLDPWD=/home/oracle

LD_LIBRARY_PATH=/u01/oracle/lib:/u01/gg11:

[oracle@ora11g gg11]$ ggsci (最好在gg的安装目录下执行)

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21

--成功进入GGSCI界面--

GGSCI (ora11g) 1>create subdirs (安装很简单)

Creating subdirectories under current directory /u01/gg11

Parameter files /u01/gg11/dirprm: already exists

Report files /u01/gg11/dirrpt: created

Checkpoint files /u01/gg11/dirchk: created

Process status files /u01/gg11/dirpcs: created

SQL script files /u01/gg11/dirsql: created

Database definitions files /u01/gg11/dirdef: created

Extract data files /u01/gg11/dirdat: created

Temporary files /u01/gg11/dirtmp: created

Stdout files /u01/gg11/dirout: created

GGSCI (ora11g) 2> exit

[oracle@ora11g gg11]$ ll -ltr (查看下最新产生文件)

drwxrwxr-x 2 oracle oinstall 4096 Apr 27 15:18 dirtmp

drwxrwxr-x 2 oracle oinstall 4096 Apr 27 15:18 dirsql

drwxrwxr-x 2 oracle oinstall 4096 Apr 27 15:18 dirrpt

drwxrwxr-x 2 oracle oinstall 4096 Apr 27 15:18 dirpcs

drwxrwxr-x 2 oracle oinstall 4096 Apr 27 15:18 dirout

drwxrwxr-x 2 oracle oinstall 4096 Apr 27 15:18 dirdef

drwxrwxr-x 2 oracle oinstall 4096 Apr 27 15:18 dirdat

drwxrwxr-x 2 oracle oinstall 4096 Apr 27 15:18 dirchk

5.GGSCI的简单使用

help--查看ggsci命令使用总结

GGSCI (ora11g) 1> help ( ggsci中对大小写不敏感)

GGSCI Command Summary:

Object: Command: (第一列是对象，第二列是可施加于对象的命令)

SUBDIRS CREATE

ER INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP

EXTRACT ADD, ALTER, CLEANUP, DELETE, INFO, KILL,

LAG, REGISTER, SEND, START, STATS, STATUS, STOP

…… ……

如果要继续查看具体每个命令的意思，可以使用：HELP

ITPub博客

golden gate快速安装

最新文章