设为首页 加入收藏

TOP

GoldentGateOracletoOracle初始化详解(一)
2015-07-24 11:25:48 来源: 作者: 【 】 浏览:9
Tags: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
首页 上一页 1 2 3 4 5 6 7 下一页 尾页 1/8/8
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇OracleOutline总结 下一篇Oracle锁4:系统锁

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·常用meta整理 | 菜鸟 (2025-12-25 01:21:52)
·SQL HAVING 子句:深 (2025-12-25 01:21:47)
·SQL CREATE INDEX 语 (2025-12-25 01:21:45)
·Shell 传递参数 (2025-12-25 00:50:45)
·Linux echo 命令 - (2025-12-25 00:50:43)