参数ENABLE_GOLDENGATE_REPLICATION

jiawang

APPLIES TO:




Oracle GoldenGate - Version 11.2.0.0.0 and later
Information in this document applies to any platform.
PURPOSE




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.
这个参数在11.2.0.4和12.1.0.2以后才出现,而且这个参数是在源端和目标端同时设定该参数。
DETAILS




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，所以把gg绑定到DB中，只有设置了改参数为true,才能使用OGG的一些功能。




So, in order to use OGG, on Oracle 11.2.0.4, or Oracle 12.1.0.2+, you will need to issue the following command through SQL*Plus.




ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;




This only needs to be done once, and in a RAC environment, will take effect on all instances.   It can be done without bouncing the database instance, and you’ll want to use SCOPE=BOTH or update the init.ora file to ensure that when the database is bounced, the setting remains in effect.




If this parameter is not set and/or missing privileges (exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE ( '' ); exec DBMS_XSTREAM_AUTH.GRANT_ADMIN_PRIVILEGE ( '' );), you may get an Oracle error, ORA-26947 or ORA-26945 when attempting to use any of the GoldenGate functionality.




Here is the complete text of the oracle error (as shown from orerr utility)




26947, 00000, "Oracle GoldenGate replication is not enabled."
// *Cause: The 'enable_goldengate_replication' parameter was not set to 'true'.
// *Action: Set the 'enable_goldengate_replication' parameter to 'true'
//           and retry the operation.
//          Oracle GoldenGate license is needed to use this parameter.   




To correct, grant privileges to the Replicat Oracle DB user by running the dbms_goldengate_auth.grant_admin_privilege procedure.




ie:




exec dbms_goldengate_auth.grant_admin_privilege('gguser','*',TRUE);

jiawang

验证参数修改是否成功：
SELECT enable_goldengate_replication FROM v$parameter WHERE name = 'enable_goldengate_replication';
若返回值为 TRUE，则说明参数已成功设置。