有时候,Extract进程启动失败,一直处于STOP状态,具体如下所示:

这个时候,可以去看看OGG的日志:

可以看到,报错内容是:

OGG-00303 Oracle GoldenGate Capture for Oracle, EORA.prm: Unable to connect to database using user ggs. Ensure that the necessary privileges are granted to the user.
Operation not supported because enable_goldengate_replication is not set to true.

根据报错,设置数据库参数:enable_goldengate_replication:

然后,再次在GGSCI中,启动Extract:

可以看到没有问题了。

Extract运行起来后,会拉起一个新的窗口:

至此,文首的问题已经被解决了。


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

隐藏
变装