GoldentGateOracletoOracle初始化详解(一)

一、安装GoldenGate[源端，目标端]

    1、创建ogg目录
    [root@source ~]# mkdir /DBSoft/ogg
    [root@source ~]# cd /DBSoft/ogg/

    2、解压缩ogg安装介质
    [root@source ogg]# unzip /root/OGG_v11_for_ora11g_linux64.zip
    Archive: /root/OGG_v11_for_ora11g_linux64.zip
      inflating: ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
      inflating: OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf
      inflating: README.txt

    3、可以看到介质包含一个tar包，pdf文件以及一个readme
    [root@source ogg]# ll
    total 201016
    -rw-rw---- 1 root root 205096960 Jul 29 2010 ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
    -rwxrwxr-x 1 root root 500964 Aug 6 2010 OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf
    -rwxrwxr-x 1 root root 26726 Aug 3 2010 README.txt

    4、修改ogg目录所属组为oinstall及所属用户为oracle
    [root@source ogg]# cd ..
    [root@source DBSoft]# ll
    total 32
    drwxr-x--- 3 oracle oinstall 4096 Sep 2 22:40 admin
    drwxr-xr-x 6 oracle oinstall 4096 Sep 2 22:44 cfgtoollogs
    drwxr-xr-x 3 oracle oinstall 4096 Sep 2 22:38 checkpoints
    drwxrwxr-x 11 oracle oinstall 4096 Sep 2 22:39 diag
    drwxr-x--- 4 oracle oinstall 4096 Sep 2 22:41 fast_recovery_area
    drwxr-xr-x 2 oracle oinstall 4096 Sep 3 10:27 ogg
    drwxrwx--- 5 oracle oinstall 4096 Sep 2 22:39 oraInventory
    drwxr-xr-x 3 oracle oinstall 4096 Sep 2 22:32 product

    [root@source DBSoft]# chown -R oracle:oinstall ogg/
    [root@source DBSoft]# su - oracle

    5、再次进入ogg目录，解压缩ogg主程序文件
    [oracle@source ~]$ cd /DBSoft/ogg/
    [oracle@source ogg]$ ll
    total 201016
    -rw-rw---- 1 oracle oinstall 205096960 Jul 29 2010 ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
    -rwxrwxr-x 1 oracle oinstall 500964 Aug 6 2010 OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf
    -rwxrwxr-x 1 oracle oinstall 26726 





Aug 3 2010 README.txt

    #正在解压缩
    [oracle@source ogg]$ tar -xvf ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
    bcpfmt.tpl
    bcrypt.txt
    chkpt_ora_create.sql
    cobgen
    convchk
    db2cntl.tpl
    ddl_access.tpl
    ddl_cleartrace.sql
    ddlcob
    ddl_db2_os390.tpl
    ddl_db2.tpl
    ddl_ddl2file.sql
    ddl_disable.sql
    ddl_enable.sql
    ddlgen
    ddl_informix.tpl
    ddl_mss.tpl
    ddl_mysql.tpl
    ddl_nopurgeRecyclebin.sql
    ddl_nssql.tpl
    ddl_ora10.sql
    ddl_ora10upCommon.sql
    ddl_ora11.sql
    ddl_ora9.sql
    ddl_oracle.tpl
    ddl_pin.sql
    ddl_purgeRecyclebin.sql
    ddl_remove.sql
    ddl_session1.sql
    ddl_session.sql
    ddl_setup.sql
    ddl_sqlmx.tpl
    ddl_status.sql
    ddl_staymetadata_off.sql
    ddl_staymetadata_on.sql
    ddl_sybase.tpl
    ddl_tandem.tpl
    ddl_tracelevel.sql
    ddl_trace_off.sql
    ddl_trace_on.sql
    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
    emsclnt
    extract
    freeBSD.txt
    ggMessage.dat
    ggsci
    help.txt
    keygen
    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
    params.sql
    replicat
    reverse
    role_setup.sql
    server
    sqlldr.tpl
    tcperrs
    UserExitExamples/
    UserExitExamples/ExitDemo_lobs/
    UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS
    UserExitExamples/ExitDemo_lobs/readme.txt
    UserExitExamples/ExitDemo_lobs/exitdemo_lob.c
    UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX
    UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX
    UserExitExamples/Exi