一、环境
CentOS6.9,Oracle12C,OGG18.1.0.0 for Oracle1.
二、问题
启动OGG的Extract进程,状态为STOPPED:
查看 ggserr.log日志:
more $GG_HOME/ggserr.log
错误信息为:
Operation not supported because enable_goldengate_replication is not set to true
三、解决方法
原因是Oracle的ENABLE_GOLDENGATE_REPLICATION参数未启用,将其启用即可。
参数ENABLE_GOLDENGATE_REPLICATION说明:
To better track GoldenGate product license, a new database init parameter, ENABLE_GOLDENGATE_REPLICATION, is introduced in Oracle 11.2.0.4 and 12.1.0.2 and up.
For Oracle DB versions 11.2.0.4 and 12.1.0.2 there will be a new init.ora parameter called ENABLE_GOLDENGATE_REPLICATION. In order for some of the Oracle GoldenGate functionality to work, this parameter must be set to true. It will enable access to the TDE/TSE integration with classic extract, Integrated Capture, Integrated Apply, DBLOGREADER functionality, replicat functionality like suppression of triggers and deferring referential constrains, and other integration points.
为了更好的使用OGG,只有设置了该参数为true,才能使用OGG的一些功能。
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE;
完毕。