报错:源端推送进程异常挂起。
RMTTRAIL E:\app\Administrator\product\11.2.0\ogg\dirdat\gk
DISCARDFILE E:\app\Administrator\product\11.2.0\ogg\dirrpt\gk_ext.dsc, APPEND, MEGABYTES 100
DISCARDROLLOVER AT 19:00
REPORTROLLOVER AT 19:00
REPORTCOUNT EVERY 2 HOURS, RATE
table ggk.*;
sequence ggk.*;
table sxk.*;
sequence sxk.*;
2019-12-18 16:57:38 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
E:\app\Administrator\product\11.2.0\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
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Database Language and Character Set:
NLS_LANG = “AMERICAN_AMERICA.ZHS16GBK”
NLS_LANGUAGE = “AMERICAN”
NLS_TERRITORY = “AMERICA”
NLS_CHARACTERSET = “ZHS16GBK”
2019-12-18 16:57:45 WARNING OGG-01223 TCP/IP error 10054 (远程主机强迫关闭了一个现有的连接。).
2019-12-18 16:57:53 WARNING OGG-01223 TCP/IP error 10054 (远程主机强迫关闭了一个现有的连接。).
2019-12-18 16:58:01 WARNING OGG-01223 TCP/IP error 10054 (远程主机强迫关闭了一个现有的连接。).
2019-12-18 16:58:10 WARNING OGG-01223 TCP/IP error 10054 (远程主机强迫关闭了一个现有的连接。).
2019-12-18 16:58:18 WARNING OGG-01223 TCP/IP error 10054 (远程主机强迫关闭了一个现有的连接。).
2019-12-18 16:58:26 WARNING OGG-01223 TCP/IP error 10054 (远程主机强迫关闭了一个现有的连接。).
2019-12-18 16:58:35 WARNING OGG-01223 TCP/IP error 10054 (远程主机强迫关闭了一个现有的连接。).
2019-12-18 16:58:43 WARNING OGG-01223 TCP/IP error 10054 (远程主机强迫关闭了一个现有的连接。).
2019-12-18 16:58:51 WARNING OGG-01223 TCP/IP error 10054 (远程主机强迫关闭了一个现有的连接。).
Source Context :
SourceModule : [er.extrout]
SourceID : [er/extrout.c]
SourceFunction : [tcp_send_data]
SourceLine : [1352]
ThreadBacktrace : [10] elements
: [E:\app\Administrator\product\11.2.0\ogg\gglog.dll(??1CContextItem@@UEAA@XZ+0x313f) [0x00000001801075AF]]
: [E:\app\Administrator\product\11.2.0\ogg\gglog.dll(?_MSG_ERR_TCP_GENERIC@@YAPEAVCMessage@@PEAVCSourceContext@@PEBDW4MessageDisposition@CMessageFactory@@@Z+0xd3) [0x00000001800A65D3]]
: [E:\app\Administrator\product\11.2.0\ogg\extract.exe(<11.2.0\ogg\extract.exe) [0x000000014003FEF9]]
: [E:\app\Administrator\product\11.2.0\ogg\extract.exe(<11.2.0\ogg\extract.exe) [0x0000000140040D5A]]
: [E:\app\Administrator\product\11.2.0\ogg\extract.exe(<11.2.0\ogg\extract.exe) [0x000000014006CBD3]]
: [E:\app\Administrator\product\11.2.0\ogg\extract.exe(<11.2.0\ogg\extract.exe) [0x0000000140069F39]]
: [E:\app\Administrator\product\11.2.0\ogg\extract.exe(shutdownMonitoring+0x1bea9) [0x00000001400E58A9]]
: [E:\app\Administrator\product\11.2.0\ogg\extract.exe(CommonLexerNewSSD+0x1d730) [0x000000014040A120]]
: [C:\Windows\system32\KERNEL32.DLL(BaseThreadInitThunk+0x22) [0x00007FFAF5F913F2]]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x34) [0x00007FFAF61B54F4]]
2019-12-18 16:59:00 ERROR OGG-01224 TCP/IP error 10054 (远程主机强迫关闭了一个现有的连接。); retries exceeded.
2019-12-18 16:59:00 ERROR OGG-01668 PROCESS ABENDING.
解决:推送异常应着重排查目标端,经排查,目标端服务器开启了防火墙并没有放行相关端口。添加入站规则后,问题解决,push进程running.