先决条件
1. Oracle database 11g已安装,
2. Oracle GoldenGate 11g for Linux已安装3. Oracle Data Integrator已安装在windows上
环境介绍
Oracle Linux 64 bit 6.4 (IP: 192.168.1.109),hosts both database and GoldenGate.
Oracle Database: 11.2.0.3 64 bit
Oracle GoldenGate 11.2.1.0.1 for Linux 64bit and Oracle 11g
OGG source directory: /home/oracle/ogg_src
OGG staging directory: /home/oracle/ogg
Source table: cust_dw_dev.src_city
Staging table: gg_demo_stage.city
ODI 11g installed on Windows 7 64bit – IP:192.168.1.154, master and work repository have been created.
数据库环境配置
For demonstration purposes, source, staging, target tables are in the same database.
Source Schema and Table
Login192.168.1.109 as oracle/oracle
sqlplus “/as sysdba”
create user cust_dw_dev identified by a123456;
grant dba to cust_dw_dev;
create user odi_tmp identified by a123456;
grant dba to odi_tmp;
con