Home >Database >Mysql Tutorial >GG链路过多端口不足导致的报错OGG-01223

GG链路过多端口不足导致的报错OGG-01223

WBOY
WBOYOriginal
2016-06-07 16:04:461626browse

如果我们GG同步链路在增多,就有可能出现这个报错,在日志中能体现。 2014-05-20 13:32:38 WARNING OGG-01223 TCP/IP error 111 (Connection refused).2014-05-20 13:33:19 WARNING OGG-01223 TCP/IP error 111 (Connection refused).2014-05-20 13:34:00 WAR

如果我们GG同步链路在增多,就有可能出现这个报错,在日志中能体现。
2014-05-20 13:32:38 WARNING OGG-01223 TCP/IP error 111 (Connection refused). 2014-05-20 13:33:19 WARNING OGG-01223 TCP/IP error 111 (Connection refused). 2014-05-20 13:34:00 WARNING OGG-01223 TCP/IP error 111 (Connection refused). 2014-05-20 13:34:41 WARNING OGG-01223 TCP/IP error 111 (Connection refused). 2014-05-20 13:35:22 WARNING OGG-01223 TCP/IP error 111 (Connection refused). 2014-05-20 13:36:03 WARNING OGG-01223 TCP/IP error 111 (Connection refused). 2014-05-20 13:36:44 WARNING OGG-01223 TCP/IP error 111 (Connection refused).

包括初始initload也出现这个,这是因为mgr进程参数分配的端口不够多,一个extract data pump进程就得占用一个端口的。 我原来是7810-7820,但是链路已经超过10个,就出问题了。 后来改成7810-7910,解决。
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:数据仓库的构件Next article:session