Golden Gate入门指导:安装篇
来源:互联网 发布:手机网络掩码怎么设置 编辑:程序博客网 时间:2024/06/08 12:39
本次实验的安装环境:
OS →→ Red Hat Enterprize Linux 5.4
DB →→ Oracle 10g
OS →→ Red Hat Enterprize Linux 5.4
DB →→ Oracle 10g
GG →→ ogg112101_fbo_ggs_Linux_x86_ora10g_32bit
需要注意的是、数据库版本不同的话、Golden Gate也要选择相对应的版本
㈠ 首先,将安装文件解压缩至/u01/app/oracle/ggs
[oracle@Think vmshare]$ unzip ogg112101_fbo_ggs_Linux_x86_ora10g_32bit.zip -d /u01/app/oracle/ggs/[oracle@Think ggs]$ tar -xvof fbo_ggs_Linux_x86_ora10g_32bit.tar
㈡ 设置相应的环境变量,建议使用 oracle 用户安装
[oracle@Think ~]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1[oracle@Think ~]$ export PATH=$ORACLE_HOME/bin:/u01/app/oracle/ggs:$PATH[oracle@Think ~]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/app/oracle/ggs
㈢ 进入 GoldenGate 命令行模式,创建子 GoldenGate 的工作子目录
[oracle@Think ~]$ ggsciOracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux, x86, 32bit (optimized), Oracle 10g on Apr 23 2012 07:06:02Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.GGSCI (Think) 1> create subdirsCreating subdirectories under current directory /home/oracleParameter files /home/oracle/dirprm: createdReport files /home/oracle/dirrpt: createdCheckpoint files /home/oracle/dirchk: createdProcess status files /home/oracle/dirpcs: createdSQL script files /home/oracle/dirsql: createdDatabase definitions files /home/oracle/dirdef: createdExtract data files /home/oracle/dirdat: createdTemporary files /home/oracle/dirtmp: createdStdout files /home/oracle/dirout: created
㈣ 接下来、需要在Oracle数据库中创建一个专属用户,用于 GoldenGate Manager进程,Extract进程和Replicat进程
idle> conn / as sysdbaConnected.sys@ORCL> create tablespace ggs_data datafile size 80M;Tablespace created.sys@ORCL> create user ogg identified by ogg default tablespace ggs_data;User created.sys@ORCL> grant connect,resource to ogg;Grant succeeded.sys@ORCL> grant select any dictionary,select any table to ogg;Grant succeeded.sys@ORCL> grant create table to ogg;Grant succeeded.sys@ORCL> grant flashback any table to ogg;Grant succeeded.sys@ORCL> grant execute on dbms_flashback to ogg;Grant succeeded.sys@ORCL> grant execute on utl_file to ogg;Grant succeeded.
㈤ 确认我们刚才创建的ogg用户能够登入RDBMS
[oracle@Think ggs]$ ggsciOracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux, x86, 32bit (optimized), Oracle 10g on Apr 23 2012 07:06:02Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.GGSCI (Think) 1> DBLOGIN USERID ogg,PASSWORD oggSuccessfully logged into database.
㈥ 在数据库级别创建supplemental log、否则、唤醒Extract进程时会报错
sys@ORCL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;Database altered.sys@ORCL> select supplemental_log_data_min,supplemental_log_data_pk,supplemental_log_data_ui, 2 supplemental_log_data_fk,supplemental_log_data_all 3 from v$database;SUPPLEME SUP SUP SUP SUP-------- --- --- --- ---IMPLICIT NO NO NO YES
㈦ 实施过程中遇到的一个错误
GGSCI (Think) 1> DBLOGIN USERID ogg,PASSWORD oggCannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directoryCannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directoryAborted
需要在ggs的HOME目录下执行ggsci才OK,在其他位置执行会报错,找不到文件或是目录
- Golden Gate入门指导:安装篇
- Golden Gate入门指导:概念和体系结构篇
- Golden Gate 安装配置
- Golden Gate 安装
- Golden Gate
- Oracle Golden Gate 系列四 -- GG 安装 与 卸载 理论知识
- Oracle Golden Gate 系列四 -- GG 安装 与 卸载 理论知识
- golden gate 生产环境的安装部署之管理进程
- golden gate 生产环境的安装部署之加安全策略
- golden gate 生产环境的安装部署之抽取进程
- Oracle Golden Gate 简述
- Oracle Golden Gate
- oracle Golden Gate
- golden gate 错误集锦
- Oracle Golden Gate 发展史
- Oracle Golden Gate 简述
- Oracle Golden Gate 搭建
- golden-gate DDL
- Oracle常见错误汇总
- 不同操作系统中的行结束符
- Extjs4.0 之Ext.Class 属性详解 (alias/mixins /uses/requires/singleton等属性)
- deploy the war project
- 在外网访问内网电脑远程桌面的几种方式
- Golden Gate入门指导:安装篇
- 黑马程序员-内省、操作JavaBean工具类
- cocos2d-x中两种播放精灵动画的方式
- UBIFS Support
- 多线程的信号问题
- Linux多线程与信号
- ZOJ 2001 Adding Reversed Numbers
- hdu 1060 Leftmost Digit
- hdu2708