状况:
OGG replicat进程abend了,查看report显示如下问题:
2016-11-01 16:11:47 ERROR OGG-01820 Could not enable workspace
解决方案:
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
exec dbms_goldengate_auth.grant_admin_privilege(OGGADMIN,'*',TRUE);
错误描述:
OGG-01820: Could not enable workspace
Cause: An attempt to handle transient duplicates in an update statement failed.
Action: Restart Replicat. If the problem persists, grant privileges to the Replicat
user by running the dbms_goldengate_auth.grant_admin_privilege procedure.
Also resolve any associated errors, such as OCI session errors
关于Procedure的解释:
上述Procedure的语法Syntax
DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE(
grantee IN VARCHAR2,
privilege_type IN VARCHAR2 DEFAULT '*',
grant_select_privileges IN BOOLEAN DEFAULT TRUE,
do_grants IN BOOLEAN DEFAULT TRUE,
file_name IN VARCHAR2 DEFAULT NULL,
directory_name IN VARCHAR2 DEFAULT NULL
grant_optional_privileges IN VARCHAR2 DEFAULT NULL,
container IN VARCHAR2 DEFAULT 'CURRENT');
grantee --被授权的OGG管理用户
privilege_type –-有三个选项值CAPTURE APPLY 和*
Specifying * grants the minimum privileges required by the
user to administer Oracle GoldenGate integrated extract and
Oracle GoldenGate integrated replicat
grant_select_privileges 设置为TRUE
关于ENABLE_GOLDENGATE_REPLICATION 参数的解释,12c默认为true,11.2.0.4版本默认是false
该参数从11.2.0.4才开始有
参考:
【1】Doc ID 1568417.1
【2】http://blog.sina.com.cn/s/blog_8317516b0101c762.html
【3】PL/SQL Packages and Types Reference 12c Release 1 (12.1)
【4】Reference 12c Release 1 (12.1)
【5】GoldenGate For Windows and UNIX Error Messages Guide 11g Release 2