OGG配置

ogg实现方式

①源端日志抽取进程抽取日志

②源端推送进程pump

③目的端复制文件到目标库

一、配置

平台 linux x86_64

oracle 11.2.0.4

二、配置OGG

1、配置网络互通

2、安装ogg

  ①创建目录/u01/app/ogg

  ②解压缩软件

     tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar -C /u01/app/ogg

3、修改环境变量：

      vi .bash_profile

      export LD_LIBRARY_PATH=$ORACLE_HOME/lib

     否则，运行ggsci时报如下错误：

     ./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

4、创建子目录：

    oracle:

       cd /u01/app/ogg

       ./ggsci

       GGSCI>create subdirs

       

5、创建用户ogg并授权，收回unlimited tablespace权限

   create user ogg identified by ogg;

   grant resource,connect to ogg;

   grant select any dictionary to ogg;

   (grant all on scott.emp1 to ogg;  //在scott创建了表之后赋予权限

    grant all on scott.dept1 to ogg;)

   revoke unlimited tablespace from ogg;

   alter user ogg quota unlimited on users;  //让用户ogg在users表空间上有权限

   

6、scott用户创建emp1和dept1表，加上约束（目标库上只要结构，没有数据）

源端：

create table emp1 as select * from emp;

create table dept1 as select * from dept;

alter table emp1 add constraints empno_pk primary key(empno);

alter table dept1 add constraints deptno_pk primary key(deptno);

alter table emp1 add constraints deptno_fk foreign key(deptno) references dept1(deptno);

目标端：

create table emp1 as select * from emp where 1=2;

create table dept1 as select * from dept where 1=2;

alter table emp1 add constraints empno_pk primary key(empno);

alter table dept1 add constraints deptno_pk primary key(deptno);

alter table emp1 add constraints deptno_fk