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

最新推荐文章于 2024-04-08 14:22:17 发布

weixin_39751195

最新推荐文章于 2024-04-08 14:22:17 发布

阅读量476

点赞数

文章标签： mysql同步oracle ogg

本文详细讲述了GGSCI(cs-db)中遇到的问题，包括MySQL登录失败、ogg startmgr执行错误、集成模式限制、ADDEXTRACT参数错误、源定义文件忽略及ogg不支持MySQL8.0。通过实例展示了如何修复这些问题，如密码更新、源表名规范和适配不同数据库版本。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

问题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