遇到一个问题,还请大家帮忙看下:
现有系统环境是源端aix6106,adg的环境oracle11g,目标端是linux mysql5.7 ,想做彼此之前的ogg同步,现在ogg的版本是12.1,源端创建extract以后,本地不生成tail文件,ggserr也无任何报错信息,想问问这个可能是什么问题呀
extract文件信息:
extract ext1
SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
SETENV (ORACLE_SID=*)
userid goldengate@,password *
TRANLOGOPTIONS MINEFROMACTIVEDG
exttrail /ogg/ogg_data/dirdat/ea
discardfile /ogg/ogg_data/dirrpt/dce1.dsc,append
fetchoptions fetchpkupdatecols
table test.test;
https://houseofbrick.com/replication-from-oracle-to-mysql-using-goldengate/
https://www.support.dbagenesis.com/post/oracle-to-mysql-replication-using-golden-gate
按照步骤认真检查一下,每一步是不是都对 ?
extract file 里面的信息是不是少了 rmthost ?
extract andy_ora
userid ggadmin, password ggadmin
rmthost mysql1, mgrport 7809 ← parameters for the mysql server
rmttask replicat, group initandy ← This group will be the same name as the replicat used to load the data in Golden Gate on the MySQL instance.
table andy.*;