mysql同步oracle ogg,记一次安装mysql到oracle ogg同步的问题汇总

问题1：

GGSCI (cs-db) 1> dblogin SOURCEDB mydb@133.37.126.38:3306, USERID ggs, PASSWORD "oracle"

2019-03-05 15:49:50  WARNING OGG-00769  MySQL Login failed: . SQL error (2059). Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory.

ERROR: Failed to connect to MySQL database engine for HOST 133.37.126.38, DATABASE mydb, USER ggs, PORT 3306.

mysql登陆成功，ogg登陆失败

#更新密码(mysql_native_password模式)

ALTER USER 'ggs'@'%' IDENTIFIED WITH mysql_native_password BY 'oracle';

问题2：

GGSCI (cs-db DBLOGIN as ggs) 9> start mgr

Process creation error: Cannot find executable file './mgr'

没有进入ogg根目录 start mgr导致

问题3：mysql没有集成模式,oracle 12c pdb必须使用集成模式

GGSCI (cs-db) 7> ADD EXTRACT extmy,integrated tranlog, begin now

ERROR: Invalid parameter specified for ADD EXTRACT.

问题4：extinit启动报错

WARNING OGG-01194  EXTRACT task repinimy abended : Source wildcard specification JAM.my.* includes a catalog name, but the source table name mydb.t1 does not include a catalog name.

不能写SOURCECATALOG JAM

正确写法如下：

MAP my.*,target jam.lzl.*;

问题5：

2019-03-06 16:15:17  WARNING OGG-02760  ASSUMETARGETDEFS is ignored because trail file  contains table definitions.

2019-03-06 15:53:40  WARNING OGG-02761  Source definitions file, /oracle/soft/ogg/dirdef/defmydb.p, is ignored because trail file  contains table definitions.

问题6：ogg18不支持mysql8.0