If you see the following message at the end of ADD TRANDATA command in ggsci:
GGSCI (myserver.mydomain.com as gg@testdb01) 8> ADD TRANDATA SCOTT.EMP 2018-10-25 11:59:35 INFO OGG-15132 Logging of supplemental redo data enabled for table SCOTT.EMP. 2018-10-25 11:59:35 INFO OGG-15133 TRANDATA for scheduling columns has been added on table SCOTT.EMP. 2018-10-25 11:59:35 INFO OGG-15135 TRANDATA for instantiation CSN has been added on table SCOTT.EMP. 2018-10-25 11:59:35 ERROR OGG-10470 Error encountered during gathering support information on table SCOTT.EMP. ERROR: OCI Error ORA (status = 942-ORA-00942: table or view does not exist)
You need to grant access to the dictionary for your golden gate databaser user. In my case:
GRANT SELECT ANY DICTIONARY TO GG;
From now on, any attempt to add supplemental logging for tables will end without errors, like this:
2018-10-26 13:01:41 INFO OGG-10471 ***** Oracle Goldengate support information on table SCOTT.EMP. ***** Oracle Goldengate support native capture on table SCOTT.EMP. Oracle Goldengate marked following column as key columns on table SCOTT.EMP: EMP_ID.
No comments:
Post a Comment