1.下载介质:
下载相应的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
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
--成功进入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 ,例如:
GGSCI (ora11g) 2> help create subdirs
CREATE SUBDIRS
Use CREATE SUBDIRS when installing Oracle GoldenGate. This command
creates the default directories within the Oracle GoldenGate home
directory. Use CREATE SUBDIRS before any other configuration tasks.
Syntax:
CREATE SUBDIRS
如果要查看一下当前进程信息:
GGSCI (ora11g) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29602308/viewspace-1150405/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29602308/viewspace-1150405/