oracle goldengate安装

1、ftp工具上传ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip分别到source和target服务器

[oracle@localhost mnt]$ ll

total 87100

-rw-r--r--. 1 root root 89186858 Nov 24 2015 ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

2、分别root登录source DB服务器和target DB服务器

创建安装目录:

[oracle@localhost ~]$ mkdir -p /u01/app/ogg

[oracle@localhost ~]$ cd /u01/app/ogg/

解压安装介质:

[oracle@localhost ogg]$ unzip /mnt/ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

Archive: /mnt/ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

inflating: fbo_ggs_Linux_x64_ora11g_64bit.tar

inflating: OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf

inflating: Oracle GoldenGate 11.2.1.0.1 README.txt

inflating: Oracle GoldenGate 11.2.1.0.1 README.doc

[oracle@localhost ogg]$ mkdir 112101

[oracle@localhost ogg]$ cd 112101/

[oracle@localhost 112101]$ ll

total 0

解压文件:

[oracle@localhost 112101]$ tar -xvf ../fbo_ggs_Linux_x64_ora11g_64bit.tar

UserExitExamples/

UserExitExamples/ExitDemo_more_recs/

UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX

UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS

UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX

UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX

UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj

UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c

UserExitExamples/ExitDemo_more_recs/readme.txt

UserExitExamples/ExitDemo_passthru/

UserExitExamples/ExitDemo_passthru/exitdemo_passthru.c

UserExitExamples/ExitDemo_passthru/exitdemopassthru.vcproj

UserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUX

UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX

UserExitExamples/ExitDemo_passthru/Makefile_passthru.HP_OSS

UserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUX

UserExitExamples/ExitDemo_passthru/readme.txt

UserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARIS

UserExitExamples/ExitDemo_lobs/

UserExitExamples/ExitDemo_lobs/exitdemo_lob.c

UserExitExamples/ExitDemo_lobs/Makefile_lob.HPUX

UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS

UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX

UserExitExamples/ExitDemo_lobs/exitdemo_lob.vcproj

UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX

UserExitExamples/ExitDemo_lobs/readme.txt

UserExitExamples/ExitDemo_pk_befores/

UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIX

UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUX

UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.c

UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUX

UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcproj

UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARIS

UserExitExamples/ExitDemo_pk_befores/readme.txt

UserExitExamples/ExitDemo/

UserExitExamples/ExitDemo/exitdemo.vcproj

UserExitExamples/ExitDemo/Makefile_exit_demo.SOLARIS

UserExitExamples/ExitDemo/Makefile_exit_demo.HP_OSS

UserExitExamples/ExitDemo/exitdemo.c

UserExitExamples/ExitDemo/Makefile_exit_demo.LINUX

UserExitExamples/ExitDemo/exitdemo_utf16.c

UserExitExamples/ExitDemo/Makefile_exit_demo.HPUX

UserExitExamples/ExitDemo/Makefile_exit_demo.AIX

UserExitExamples/ExitDemo/readme.txt

bcpfmt.tpl

bcrypt.txt

cfg/

cfg/password.properties

cfg/MPMetadataSchema.xsd

cfg/jps-config-jse.xml

cfg/ProfileConfig.xml

cfg/mpmetadata.xml

cfg/Config.properties

chkpt_ora_create.sql

cobgen

convchk

db2cntl.tpl

ddl_cleartrace.sql

ddl_ddl2file.sql

ddl_disable.sql

ddl_enable.sql

ddl_filter.sql

ddl_nopurgeRecyclebin.sql

ddl_ora10.sql

ddl_ora10upCommon.sql

ddl_ora11.sql

ddl_ora9.sql

ddl_pin.sql

ddl_purgeRecyclebin.sql

ddl_remove.sql

ddl_session.sql

ddl_session1.sql

ddl_setup.sql

ddl_status.sql

ddl_staymetadata_off.sql

ddl_staymetadata_on.sql

ddl_trace_off.sql

ddl_trace_on.sql

ddl_tracelevel.sql

ddlcob

defgen

demo_more_ora_create.sql

demo_more_ora_insert.sql

demo_ora_create.sql

demo_ora_insert.sql

demo_ora_lob_create.sql

demo_ora_misc.sql

demo_ora_pk_befores_create.sql

demo_ora_pk_befores_insert.sql

demo_ora_pk_befores_updates.sql

dirjar/

dirjar/xmlparserv2.jar

dirjar/fmw_audit.jar

dirjar/jps-internal.jar

dirjar/org.springframework.jdbc-3.0.0.RELEASE.jar

dirjar/org.springframework.context-3.0.0.RELEASE.jar

dirjar/jps-upgrade.jar

dirjar/oraclepki.jar

dirjar/org.springframework.transaction-3.0.0.RELEASE.jar

dirjar/xstream-1.3.jar

dirjar/jsr250-api-1.0.jar

dirjar/org.springframework.beans-3.0.0.RELEASE.jar

dirjar/ldapjclnt11.jar

dirjar/spring-security-cas-client-3.0.1.RELEASE.jar

dirjar/jps-manifest.jar

dirjar/org.springframework.aspects-3.0.0.RELEASE.jar

dirjar/identityutils.jar

dirjar/org.springframework.aop-3.0.0.RELEASE.jar

dirjar/jacc-spi.jar

dirjar/jmxremote_optional-1.0-b02.jar

dirjar/slf4j-log4j12-1.4.3.jar

dirjar/jps-api.jar

dirjar/slf4j-api-1.4.3.jar

dirjar/identitystore.jar

dirjar/jps-unsupported-api.jar

dirjar/osdt_xmlsec.jar

dirjar/org.springframework.orm-3.0.0.RELEASE.jar

dirjar/jagent.jar

dirjar/commons-codec-1.3.jar

dirjar/jps-ee.jar

dirjar/spring-security-taglibs-3.0.1.RELEASE.jar

dirjar/log4j-1.2.15.jar

dirjar/osdt_core.jar

dirjar/spring-security-acl-3.0.1.RELEASE.jar

dirjar/xpp3_min-1.1.4c.jar

dirjar/spring-security-web-3.0.1.RELEASE.jar

dirjar/spring-security-core-3.0.1.RELEASE.jar

dirjar/spring-security-config-3.0.1.RELEASE.jar

dirjar/jps-mbeans.jar

dirjar/org.springframework.test-3.0.0.RELEASE.jar

dirjar/jdmkrt-1.0-b02.jar

dirjar/jps-common.jar

dirjar/org.springframework.web-3.0.0.RELEASE.jar

dirjar/jps-patching.jar

dirjar/jps-wls.jar

dirjar/commons-logging-1.0.4.jar

dirjar/org.springframework.expression-3.0.0.RELEASE.jar

dirjar/org.springframework.instrument-3.0.0.RELEASE.jar

dirjar/monitor-common.jar

dirjar/osdt_cert.jar

dirjar/org.springframework.asm-3.0.0.RELEASE.jar

dirjar/org.springframework.context.support-3.0.0.RELEASE.jar

dirjar/org.springframework.core-3.0.0.RELEASE.jar

dirprm/

dirprm/jagent.prm

emsclnt

extract

freeBSD.txt

ggMessage.dat

ggcmd

ggsci

help.txt

jagent.sh

keygen

libantlr3c.so

libdb-5.2.so

libgglog.so

libggrepo.so

libicudata.so.38

libicui18n.so.38

libicuuc.so.38

libxerces-c.so.28

libxml2.txt

logdump

marker_remove.sql

marker_setup.sql

marker_status.sql

mgr

notices.txt

oggerr

params.sql

prvtclkm.plb

pw_agent_util.sh

remove_seq.sql

replicat

retrace

reverse

role_setup.sql

sequence.sql

server

sqlldr.tpl

tcperrs

ucharset.h

ulg.sql

usrdecs.h

zlib.txt

3、配置环境变量

[oracle@localhost 112101]$ vim ~/.bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

alias sqlplus="rlwrap sqlplus"

alias rman="rlwrap rman"

PATH=$PATH:$HOME/bin

export PATH

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_HOSTNAME=localhost.localdomain

export ORACLE_SID=orcl

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

export GG_HOME=/u01/app/ogg/112101

export PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH:$GG_HOME

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

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export LANG=en_US

export NLS_LANG=american_america.AL32UTF8

export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

保存退出并生效环境变量:

[oracle@localhost 112101]$ source ~/.bash_profile

4、初始化创建子目录

[oracle@localhost 112101]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

GGSCI (localhost.localdomain) 1> create subdirs

Creating subdirectories under current directory /u01/app/ogg/112101

Parameter files /u01/app/ogg/112101/dirprm: already exists

Report files /u01/app/ogg/112101/dirrpt: created

Checkpoint files /u01/app/ogg/112101/dirchk: created

Process status files /u01/app/ogg/112101/dirpcs: created

SQL script files /u01/app/ogg/112101/dirsql: created

Database definitions files /u01/app/ogg/112101/dirdef: created

Extract data files /u01/app/ogg/112101/dirdat: created

Temporary files /u01/app/ogg/112101/dirtmp: created

Stdout files /u01/app/ogg/112101/dirout: created

至此,GG安装完成,source DB和target DB仅需要进行如上操作。

上一篇:CCAction、CCFiniteTimeAction、CCSpeed、CCFollow


下一篇:java版spring cloud+spring boot 社交电子商务平台(九)使用Swagger2构建强大的RESTful API文档(1)