首页 > 代码库 > OGG遇到相关问题汇总
OGG遇到相关问题汇总
OGG初始化加载数据时遇到的问题
1.target端拒绝source端访问 2016-12-13 14:31:03 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host [192.168.0.100]:51825 (START REPLICAT RINIG1 CPU -1 PRI -1 PARAMS ). 2016-12-13 14:31:03 WARNING OGG-00936 Oracle GoldenGate Manager for Oracle, mgr.prm: Access denied (request from 192.168.0.100, rule #0). 解决方案:在target端的mgr.prm中 添加访问主机IP : ACCESSRULE, PROG *, IPADDR 192.168.*.*, ALLOW2.权限问题 2016-12-13 15:44:00 WARNING OGG-01194 Oracle GoldenGate Capture for Oracle, EINIG1.prm: EXTRACT task RINIG1 abended : OCI Error executing single row select (status = 4060-ORA-04060: insufficient privileges to execute DBMS_STREAMS.SET_TAG ORA-06512: at "SYS.DBMS_STREAMS", line 16 ORA-06512: at line 1), SQL<BEGIN dbms_streams.set_tag(:1); END;>. 先赋予dba权限,稳定后再将权限回收3.参数设置 2016-12-13 15:50:18 WARNING OGG-01194 Oracle GoldenGate Capture for Oracle, EINIG1.prm: EXTRACT task RINIG1 abended : Operation not supported because enable_goldengate_replication is not set to true. 2016-12-13 15:50:18 ERROR OGG-01203 Oracle GoldenGate Capture for Oracle, EINIG1.prm: EXTRACT abending. 2016-12-13 15:50:18 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, EINIG1.prm: PROCESS ABENDING. 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. ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
wind下平台禁止自动弹出日志窗口
1.在wind 2008平台,手动启动mgr和extract进程时,会自动弹出日志窗口。手动关闭该日志窗口后,其进程会自动被停掉。为系统稳定运行,需禁止该日志窗口自动弹出,禁止方法即将ogg添加到wind的服务中。将GG安装为windows服务步骤: .把category.dll和ggsmsg.dll两个DLL文件复制到system32下面。 .在GG目录下输入 install addservice
OGG遇到相关问题汇总
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。