gg初体验之安装

在官网上下载软件，oracle将软件归类到中间件那里。

1.解压缩

[oracle@bre1 gg]$ unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip Archive:  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@bre1 gg]$ tar xvf fbo_ggs_Linux_x64_ora11g_64bit.tar UserExitExamples/UserExitExamples/ExitDemo_more_recs/UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUXUserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARISUserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUXUserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIXUserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcprojUserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.cUserExitExamples/ExitDemo_more_recs/readme.txtUserExitExamples/ExitDemo_passthru/UserExitExamples/ExitDemo_passthru/exitdemo_passthru.cUserExitExamples/ExitDemo_passthru/exitdemopassthru.vcprojUserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUXUserExitExamples/ExitDemo_passthru/Makefile_passthru.AIXUserExitExamples/ExitDemo_passthru/Makefile_passthru.HP_OSSUserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUXUserExitExamples/ExitDemo_passthru/readme.txtUserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARISUserExitExamples/ExitDemo_lobs/UserExitExamples/ExitDemo_lobs/exitdemo_lob.cUserExitExamples/ExitDemo_lobs/Makefile_lob.HPUXUserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARISUserExitExamples/ExitDemo_lobs/Makefile_lob.AIXUserExitExamples/ExitDemo_lobs/exitdemo_lob.vcprojUserExitExamples/ExitDemo_lobs/Makefile_lob.LINUXUserExitExamples/ExitDemo_lobs/readme.txtUserExitExamples/ExitDemo_pk_befores/UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIXUserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUXUserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.cUserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUXUserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcprojUserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARISUserExitExamples/ExitDemo_pk_befores/readme.txtUserExitExamples/ExitDemo/UserExitExamples/ExitDemo/exitdemo.vcprojUserExitExamples/ExitDemo/Makefile_exit_demo.SOLARISUserExitExamples/ExitDemo/Makefile_exit_demo.HP_OSSUserExitExamples/ExitDemo/exitdemo.cUserExitExamples/ExitDemo/Makefile_exit_demo.LINUXUserExitExamples/ExitDemo/exitdemo_utf16.cUserExitExamples/ExitDemo/Makefile_exit_demo.HPUXUserExitExamples/ExitDemo/Makefile_exit_demo.AIXUserExitExamples/ExitDemo/readme.txtbcpfmt.tplbcrypt.txtcfg/cfg/password.propertiescfg/MPMetadataSchema.xsdcfg/jps-config-jse.xmlcfg/ProfileConfig.xmlcfg/mpmetadata.xmlcfg/Config.propertieschkpt_ora_create.sqlcobgenconvchkdb2cntl.tplddl_cleartrace.sqlddl_ddl2file.sqlddl_disable.sqlddl_enable.sqlddl_filter.sqlddl_nopurgeRecyclebin.sqlddl_ora10.sqlddl_ora10upCommon.sqlddl_ora11.sqlddl_ora9.sqlddl_pin.sqlddl_purgeRecyclebin.sqlddl_remove.sqlddl_session.sqlddl_session1.sqlddl_setup.sqlddl_status.sqlddl_staymetadata_off.sqlddl_staymetadata_on.sqlddl_trace_off.sqlddl_trace_on.sqlddl_tracelevel.sqlddlcobdefgendemo_more_ora_create.sqldemo_more_ora_insert.sqldemo_ora_create.sqldemo_ora_insert.sqldemo_ora_lob_create.sqldemo_ora_misc.sqldemo_ora_pk_befores_create.sqldemo_ora_pk_befores_insert.sqldemo_ora_pk_befores_updates.sqldirjar/dirjar/xmlparserv2.jardirjar/fmw_audit.jardirjar/jps-internal.jardirjar/org.springframework.jdbc-3.0.0.RELEASE.jardirjar/org.springframework.context-3.0.0.RELEASE.jardirjar/jps-upgrade.jardirjar/oraclepki.jardirjar/org.springframework.transaction-3.0.0.RELEASE.jardirjar/xstream-1.3.jardirjar/jsr250-api-1.0.jardirjar/org.springframework.beans-3.0.0.RELEASE.jardirjar/ldapjclnt11.jardirjar/spring-security-cas-client-3.0.1.RELEASE.jardirjar/jps-manifest.jardirjar/org.springframework.aspects-3.0.0.RELEASE.jardirjar/identityutils.jardirjar/org.springframework.aop-3.0.0.RELEASE.jardirjar/jacc-spi.jardirjar/jmxremote_optional-1.0-b02.jardirjar/slf4j-log4j12-1.4.3.jardirjar/jps-api.jardirjar/slf4j-api-1.4.3.jardirjar/identitystore.jardirjar/jps-unsupported-api.jardirjar/osdt_xmlsec.jardirjar/org.springframework.orm-3.0.0.RELEASE.jardirjar/jagent.jardirjar/commons-codec-1.3.jardirjar/jps-ee.jardirjar/spring-security-taglibs-3.0.1.RELEASE.jardirjar/log4j-1.2.15.jardirjar/osdt_core.jardirjar/spring-security-acl-3.0.1.RELEASE.jardirjar/xpp3_min-1.1.4c.jardirjar/spring-security-web-3.0.1.RELEASE.jardirjar/spring-security-core-3.0.1.RELEASE.jardirjar/spring-security-config-3.0.1.RELEASE.jardirjar/jps-mbeans.jardirjar/org.springframework.test-3.0.0.RELEASE.jardirjar/jdmkrt-1.0-b02.jardirjar/jps-common.jardirjar/org.springframework.web-3.0.0.RELEASE.jardirjar/jps-patching.jardirjar/jps-wls.jardirjar/commons-logging-1.0.4.jardirjar/org.springframework.expression-3.0.0.RELEASE.jardirjar/org.springframework.instrument-3.0.0.RELEASE.jardirjar/monitor-common.jardirjar/osdt_cert.jardirjar/org.springframework.asm-3.0.0.RELEASE.jardirjar/org.springframework.context.support-3.0.0.RELEASE.jardirjar/org.springframework.core-3.0.0.RELEASE.jardirprm/dirprm/jagent.prmemsclntextractfreeBSD.txtggMessage.datggcmdggscihelp.txtjagent.shkeygenlibantlr3c.solibdb-5.2.solibgglog.solibggrepo.solibicudata.so.38libicui18n.so.38libicuuc.so.38libxerces-c.so.28libxml2.txtlogdumpmarker_remove.sqlmarker_setup.sqlmarker_status.sqlmgrnotices.txtoggerrparams.sqlprvtclkm.plbpw_agent_util.shremove_seq.sqlreplicatretracereverserole_setup.sqlsequence.sqlserversqlldr.tpltcperrsucharset.hulg.sqlusrdecs.hzlib.txt

2.修改环境变量

[oracle@bre1 gg]$ ./ggsci./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory[oracle@bre1 gg]$ vi /home/oracle/.bash_profileexport PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin:$GRID_HOME/bin:/ggexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/gg/[oracle@bre1 gg]$ source /home/oracle/.bash_profile 

3.创建目录结构

[oracle@bre1 gg]$ ggsciOracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.GGSCI (bre1) 1> create subdirsCreating subdirectories under current directory /ggParameter files                /gg/dirprm: already existsReport files                   /gg/dirrpt: createdCheckpoint files               /gg/dirchk: createdProcess status files           /gg/dirpcs: createdSQL script files               /gg/dirsql: createdDatabase definitions files     /gg/dirdef: createdExtract data files             /gg/dirdat: createdTemporary files                /gg/dirtmp: createdStdout files                   /gg/dirout: createdGGSCI (bre1) 2> exit

4.修改数据库为归档，打开附加日志，创建gg用户并授权

[oracle@bre1 gg]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 23 22:35:00 2014Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> archive log list;Database log mode       No Archive ModeAutomatic archival       DisabledArchive destination       USE_DB_RECOVERY_FILE_DESTOldest online log sequence     13Current log sequence       15SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup mountORACLE instance started.Total System Global Area  835104768 bytesFixed Size    2257840 bytesVariable Size  494931024 bytesDatabase Buffers  331350016 bytesRedo Buffers    6565888 bytesDatabase mounted.SQL> alter database archivelog;Database altered.SQL> alter system set log_archive_dest_1='location=/arch' scope=both;System altered.SQL> alter database open;SQL> Alter database add supplemental log data;Database altered.SQL> alter database force logging;Database altered.SQL> create user ggs identified by ggs ;User created.grant connect,resource,unlimited tablespace to ggs;grant execute on utl_file to ggs;grant select any dictionary,select any table to ggs;grant alter any table to ggs;grant flashback any table to ggs;Grant succeeded.SQL> Grant succeeded.SQL> Grant succeeded.SQL> Grant succeeded.SQL> Grant succeeded.SQL> grant execute on DBMS_FLASHBACK to ggs;Grant succeeded.

目标端安装和源端基本一样，只是目标端需要赋予ggs为DBA权限。