Oracle 19C OGG基础运维-09OGG-15121错误
问题:对表附加日志时报错OGG-15121
错误如下:
2020-04-10 20:37:19 ERROR OGG-15121 Error obtaining the list of tables for cjcpdb.cjc.t1 : Does not match any catalog name.
操作:
GGSCI (cjcos01) 27> dblogin userid c##ogg password oracle
Successfully logged into database CDB$ROOT.
GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 28> info trandata cjcpdb.cjc.t1
2020-04-10 20:37:19 ERROR OGG-15121 Error obtaining the list of tables for cjcpdb.cjc.t1 : Does not match any catalog name.
问题原因:
不能在CDB$ROOT容器下对PDB下表进行附加日志操作。
解决方案:
需要使用公共用户c##ogg登录到对应PDB下进行附加日志操作。
如下:
GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 29> dblogin userid c##ogg@cjcpdb password oracle
Successfully logged into database CJCPDB.
GGSCI (cjcos01 as c##ogg@cjcdb/CJCPDB) 30> info trandata cjcpdb.cjc.t1
2020-04-10 20:38:15 INFO OGG-10471 ***** Oracle Goldengate support information on table CJC.T1 *****
Oracle Goldengate support native capture on table CJC.T1.
Oracle Goldengate marked following column as key columns on table CJC.T1: ID, CNAME
No unique key is defined for table CJC.T1.
欢迎关注我的微信公众号"IT小Chen",共同学习,共同成长!!!