天萃荷净
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