###########################################OGG源端#########################################
oracle版本: Version 11.2.0.4.0
OGG版本:Version 12.1.2.1.0
系统版本: Red Hat Enterprise Linux Server release 7.3
---ogg环境变量
export GG_HOME=/home/oracle/ogg12
export PATH=$JAVA_HOME/bin:$GG_HOME:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$GG_HOME:$ORACLE_HOME/lib:/lib:/usr/lib:$GG_ADAPTER_HOME
---ogg
--静默安装12ogg/11g解压安装
./runInstaller -silent -responseFile /home/oracle/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
---开启ogg参数/附加日志
alter system set enable_goldengate_replication=true;
alter database add supplemental log data;
ALTER SYSTEM ARCHIVE LOG CURRENT;
---表空间/用户/授权
create tablespace ogg datafile '/u01/app/oracle/oradata/orcl/ogg01.dbf' size 5g;
create user ogg identified by ogg default tablespace ogg;
alter user ogg quota unlimited on ogg;
GRANT CONNECT TO ogg;
GRANT CREATE SESSION TO ogg;
GRANT ALTER SESSION TO ogg;
GRANT RESOURCE TO ogg;
GRANT SELECT ANY DICTIONARY TO ogg;
GRANT SELECT ANY TABLE TO ogg;
GRANT FLASHBACK ANY TABLE TO ogg;
GRANT ALTER ANY TABLE TO ogg;
---创建测试表
create table test as select * from v$logfile;
---ogg配置
进入ogg,创建subdirs
cd /home/oracle/ogg12
./ggsci