Oracle 19C OGG基礎運維-09OGG-15121錯誤

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"，共同學習，共同成長！！！