ORACLE里，关于OGG的ENABLE_GOLDENGATE_REPLICATION参数

王亮

APPLIESTO:

OracleGoldenGate - Version 11.2.0.0.0 and later

Informationin this document applies to any platform.

PURPOSE

Tobetter track GoldenGate product license, a new database init parameter, ENABLE_GOLDENGATE_REPLICATION, is introduced in Oracle 11.2.0.4 and12.1.0.2 and up.

这个参数在11.2.0.4和12.1.0.2版本以后出现。

DETAILS

ForOracle DB versions 11.2.0.4 and 12.1.0.2 there will be a new init.ora parametercalled ENABLE_GOLDENGATE_REPLICATION.  In order for some of the OracleGoldenGate functionality to work, this parameter must be set to true.  Itwill enable access to the TDE/TSE integration with classic extract, IntegratedCapture, Integrated Apply,  DBLOGREADER functionality, replicatfunctionality like suppression of triggers and deferring referentialconstrains, and other integration points.  

意思为了更好的使用OGG，所以把OGG绑定到DB中，只有设置了改参数为true,才能使用OGG的一些功能。

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

ALTERSYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;

Thisonly needs to be done once, and in a RAC environment, will take effect on allinstances.   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 thatwhen the database is bounced, the setting remains in effect.

以后对操作OGG的用户还需要进行设置权限。

Ifthis parameter is not set and/or missing privileges (execDBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE ( '' ); execDBMS_XSTREAM_AUTH.GRANT_ADMIN_PRIVILEGE ( '' );), you may get an Oracle error,ORA-26947 or ORA-26945 when attempting to use any of the GoldenGatefunctionality.

Hereis 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 theoperation.

//         Oracle GoldenGate licenseis needed to use this parameter.   

Tocorrect, grant privileges to the Replicat Oracle DB user by running thedbms_goldengate_auth.grant_admin_privilege procedure.

ie:

execdbms_goldengate_auth.grant_admin_privilege('gguser','*',TRUE);

如有报下面的错误，原因也是由于没设参数以及授予权限，可以通过上面两步解决。

OGGREPLICAT abend:

  ERROR  OGG-01820  Could not enable workspace.

  ERROR  OGG-01668  PROCESS ABENDING.