Oracle GoldenGate OGG-01223 错误 本帖最后由 moyung2012 于 2014-10-30 13:31:06 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 不是防火墙的问题,关了iptables还是行。 百度了一下,原因写得都差不错源端和目标端edit params mgr里面的端口号不一致造成的 错误信息太少ggserr中的错误应该不只有这一条如果是连接失败,那么应该会是pump进程失败,找找该进程对应的discard文件 2014-10-30 15:46:43 INFO OGG-01815 Virtual Memory Facilities for: COM anon alloc: mmap(MAP_ANON) anon free: munmap file alloc: mmap(MAP_SHARED) file free: munmap target directories: /opt/ogg/dirtmp.CACHEMGR virtual memory values (may have been adjusted)CACHESIZE: 64GCACHEPAGEOUTSIZE (normal): 8MPROCESS VM AVAIL FROM OS (min): 128GCACHESIZEMAX (strict force to disk): 96GOpened trail file /opt/ogg/dirdat/lo000001 at 2014-10-30 15:46:432014-10-30 15:46:43 INFO OGG-01014 Positioning with begin time: Oct 30, 2014 3:46:17 PM, starting record time: Oct 30, 2014 3:01:57 PM at extseqno 1, extrba 1035.2014-10-30 15:47:13 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 10.0.67.10:7809.2014-10-30 15:47:53 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 10.0.67.10:7809.2014-10-30 15:48:35 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 10.0.67.10:7809.2014-10-30 15:49:15 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 10.0.67.10:7809.2014-10-30 15:49:55 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 10.0.67.10:7809.2014-10-30 15:50:35 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 10.0.67.10:7809.2014-10-30 15:51:15 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoin 目标端67.10上有这么一段错误2014-10-30 15:52:13 ERROR OGG-01963 Oracle GoldenGate Collector for Sybase: Network address and service translation call getaddrinfo failed with error (return code = -3, errno = 3, Temporary failure in name resolution).2014-10-30 15:52:13 ERROR OGG-01668 Oracle GoldenGate Collector for Sybase: PROCESS ABENDING.但我检查一下hostname没问,hosts文件也对SYTBpos -----------------------------------------127.0.0.1 SYTBpos localhost.localdomain localhost4 localhost4.localdomain4::1 SYTBpos localhost.localdomain localhost6 localhost6.localdomain6 问题找到了hosts文件重建之后,重启了networkingmanager与network服务,就正常了,谢谢大家,结贴了。 为日期字段建立索引后 查询的结束日期为什么要加1 四舍五入算法差值如何计算 关于乱码的替换方法! 请教,如何给用户权限,限制只能访问某个表? 一个数据库导出的问题 一个困扰多时的问题了,实在没有办法解决,请版主和各位高手相助啊! 救命!windows2000或xp下的ORACLE数据库启动问题 急需ORACLE8性能测试工具!!!! 我在使用plsql 的execute immediate的时候,总是发现下面的问题 oracle 存储过程中使用execute immediate 创建 临时表 databaselink 问题,求大虾指教 神奇的oracle语句,谁能告诉我这是怎么回事???
源端和目标端edit params mgr里面的端口号不一致造成的
ggserr中的错误应该不只有这一条
如果是连接失败,那么应该会是pump进程失败,找找该进程对应的discard文件
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/opt/ogg/dirtmp.CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 64G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G
Opened trail file /opt/ogg/dirdat/lo000001 at 2014-10-30 15:46:432014-10-30 15:46:43 INFO OGG-01014 Positioning with begin time: Oct 30, 2014 3:46:17 PM, starting record time: Oct 30, 2014 3:01:57 PM at extseqno 1, extrba 1035.2014-10-30 15:47:13 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 10.0.67.10:7809.2014-10-30 15:47:53 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 10.0.67.10:7809.2014-10-30 15:48:35 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 10.0.67.10:7809.2014-10-30 15:49:15 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 10.0.67.10:7809.2014-10-30 15:49:55 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 10.0.67.10:7809.2014-10-30 15:50:35 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 10.0.67.10:7809.2014-10-30 15:51:15 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoin
2014-10-30 15:52:13 ERROR OGG-01668 Oracle GoldenGate Collector for Sybase: PROCESS ABENDING.但我检查一下hostname没问,hosts文件也对SYTBpos -----------------------------------------127.0.0.1 SYTBpos localhost.localdomain localhost4 localhost4.localdomain4
::1 SYTBpos localhost.localdomain localhost6 localhost6.localdomain6
hosts文件重建之后,重启了networkingmanager与network服务,就正常了,谢谢大家,结贴了。