一、源端配置
1.开启数据库允许REPLICATION的参数
alter system set ENABLE_GOLDENGATE_REPLICATION=true
2.创建表空间、创建管理用户、赋予权限(sqlplus)
create tablespace SSP datafile '/u01/app/oracle/12/oradata/orcl/ssp.dbf' size 50M autoextend on next 50M maxsize unlimited;create temporary tablespace SSP_TMP tempfile '/u01/app/oracle/12/oradata/orcl/ssp_tmp.dbf' size 10m autoextend on next 10m maxsize unlimited;
create user ogg identified by "ogg" default tablespace SSP temporary tablespace SSP_TMP account unlock;
ALTER USER ogg QUOTA UNLIMITED ON SSP ;
grant connect,resource,select any table to ogg;
赋予ogg用户管理以Oracle GoldenGate的管理权限
3、开启数据库的SUPPLEMENTAL LOG DATA功能
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DAT