OGG-01820 Could not enable workspace
来源:互联网 发布:宝软网java软件下载 编辑:程序博客网 时间:2024/05/18 10:09
背景介绍
环境为:源端:windows 2012 64位 oracle 11.2.0.4,目标端:windows 2008 64位 oracle 11.2.0.4,在启用目标端数据同步时候报OGG-01820 Could not enable workspace,错误。
问题分析
在启动OGG的replicat进程的时候,提示如下错误
通过查找资料,说是cachemgr参数cachedirectory选项包含一个或多个重复的条目。并且是oracle11.2.0.4版本会出现的一个问题。
根据网上查找的解决方式是:
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION= TRUE SCOPE=BOTH;
execdbms_goldengate_auth.grant_admin_privilege('gguser','*',TRUE);
说明: ENABLE_GOLDENGATE_REPLICATION 参数是在11.2.0.4和12.1.0.2以后才出现。其目的是为了更好的监视你使用OGG,所以把gg绑定到DB中,只有设置了改参数为true,才能使用OGG的一些功能。
当设置了ENABLE_GOLDENGATE_REPLICATION= TRUE以后对操作GG的用户还要设置权限,所以就需要执行 execdbms_goldengate_auth.grant_admin_privilege('gguser','*',TRUE);
如果没有执行以上两步的语句,就会提示:
ERROR OGG-01820 Could not enableworkspace.
ERROR OGG-01668 PROCESS ABENDING.
- ERROR OGG-01820 Could not enable workspace
- OGG-01820 Could not enable workspace
- configure: error: *** Could not enable any backends.
- OGG-00446 ERROR: Could not find archived log
- Maven-->Enable Workspace Resolution
- OGG-00952 Could not delete rows from ogg.GGS_MARKER, no database specified.
- ogg数据同步停止OGG-00446 Could not find archived log for sequence
- Could not open workspace file project.xcworkspace/contents.xcworkspacedata
- 打开workspace时报错:could not launch the application because the associated workspace is currently in use
- 打开一个VC工程提示"Not all of the windows in the workspace could be opened."
- 打开一个VC工程提示"Not all of the windows in the workspace could be opened."
- VC中的Not all of the Windows in the workspace could be open提示
- could not launch thie product because the associated workspace is currently
- Aptana Studio 打开报 Could not launch the product the specified workspace cannot becarated.
- could not launch thie product because the associated workspace is currently
- Could not delete F:/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/platfor
- Eclipse报错Could not write metadata for '/RemoteSystemsTempFiles'.D:\Program Files\eclipse\workspace\.
- Eclipse报错Could not write metadata for '/RemoteSystemsTempFiles'.D:\Program Files\eclipse\workspace\.
- undefined reference to '__ctype_get_mb_cur_max'——libxerces-c
- javascript 自动补全
- oracle中distinct用法
- (OK) 编译libiconv-1.14(静态库)—CentOS 7— android-ndk
- Android Activity中点击EditText以外的位置软键盘收起
- OGG-01820 Could not enable workspace
- nm命令与符号说明
- yaml在python上的应用
- (OK) 编译xerces-c-3.1.2(动态库)—CentOS 7— android-ndk
- 基于ObjC的轻量级Promise库——RWPromiseKit
- Console命令 来调试js
- JDBC连接Apache Drill
- Android—adb shell—/system/bin/sh: ./executer: No such file or directory
- 第五周项目2.2-游戏中的角色类