参数ENABLE_GOLDENGATE_REPLICATION
来源:互联网 发布:ubuntu 系统剪贴板 编辑:程序博客网 时间:2024/06/07 07:27
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);
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);
阅读全文
0 0
- 参数ENABLE_GOLDENGATE_REPLICATION
- ORACLE_关于OGG参数.ENABLE_GOLDENGATE_REPLICATION
- .ENABLE_GOLDENGATE_REPLICATION
- $参数
- 参数++
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 命令行参数,程序参数
- 解决 win10 pycurl安装出错 Command "python setup.py egg_info" failed with error code 10
- RocketMQ实战(三)
- csdn,关注物联网 答案
- 小试Ubuntu-Server
- eclipse 创建模拟器 出现 "No system images installed for this target" 问题
- 参数ENABLE_GOLDENGATE_REPLICATION
- gerrit集成gitweb
- elasticsearch基础知识
- 继承
- 炒现饭之友盟推送的简单实现
- Maven Tomcat7 插件部署Java Web应用
- CAD .NET v12发布,提高GDI+可视化速度并可导入AutoCAD®DWG 2018
- 进程通信之管道
- html5新增api(持续更新)