sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 产品DBA > Oracle GG >

案例:Oracle goldedgate常见错误汇总 OGG-01031 OGG-00769 OGG-01033

时间:2016-05-28 23:18   来源:Oracle研究中心   作者:惜分飞   点击:

天萃荷净

Oracle Goldengate环境常见OGG-01031 OGG-00769 OGG-01033错误以及解决办法

1.ERROR OGG-01031

There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file “/opt/OGG/dirdat/AIR/EXTTRAIL/U9000005″ (error 11, Resource temporarily unavailable)).
重新启动一次

2.WARNING OGG-00769

mysql_refresh() failed, falling back to default key. SQL error (1227). Access denied; you need the RELOAD privilege for this operation.
mysql用户权限问题

3.ERROR OGG-01033

There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Remote file used is /opt/OGG/dirdat/rl000003, reply received is Unable to lock file “/opt/OGG/dirdat/rl000003″ (error 13, Permission denied). Lock currently held by process id (PID) 14409)
原因:网络或者目标段路径不正常,访问到目标端目录失败导致
在目标端kill -9 14409
或者等待2小时,自动系统自动重启目标端进程

ERROR OGG-01033 Oracle GoldenGate Capture for Oracle, p-xz.prm: There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Remote file used is /opt/OGG/dirdat/XunZhi/EXTFILE/U1000000, reply received is Could not create /opt/OGG/dirdat/XunZhi/EXTFILE/U1000000).
检查远程的目录是否和datapump中的远程目录是否一致

 


--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之案例:Oracle goldedgate常见错误汇总 OGG-01031 OGG-00769 OGG-01033

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/238.html

Oracle研究中心

关键词:

Oracle goldedgate

goldedgate常见错误汇总OGG-01031 OGG-00769 OGG-01033

OGG-01031

OGG-00769