OGG-01820 Could not enable workspace

状况:

     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才开始有

image

参考:

【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

原文地址:https://www.cnblogs.com/guilingyang/p/6020142.html