GoldenGate Pump Porcess: TCP/IP error 110 (Connection timed out)的問題解決
場景是這樣的:
源端SOURCE處於內網,目標端TARGET處於DMZ區域,之前已申請開通了源端訪問目標端的7809埠,配置PUMP後,PUMP程式一直無法正常工作:
WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, P2IPLAN.prm: TCP/IP error 110 (Connection timed out).
從源端PING目標端,也能PING通,使用telnet測試7809埠,也能順利連線上:
$ telnet X.X.X.X 7809
Trying X.X.X.X ...
Connected to X.X.X.X (X.X.X.X).
Escape character is '^]'.
Connection closed by foreign host.
但是PUMP程式就是無法連線到目標端!
在確保PUMP的各項配置正確後,使用tcpdump來抓取網路包:
在源端執行:tcpdump -v host
經過一段時間的跟蹤,發現:
。。。
14:28:25.836419 IP (tos 0x0, ttl 64, id 24609, offset 0, flags [DF], proto: TCP (6), length: 60)
SOURCE.53922 > TARGET.7819: S, cksum 0x6026 (correct), 2731187048:2731187048(0) win 5840
。。。
15:05:07.276469 IP (tos 0x0, ttl 61, id 48226, offset 0, flags [DF], proto: TCP (6), length: 52)
SOURCE.57845 > TARGET.7810: ., cksum 0xb486 (correct), ack 400 win 46
PUMP程式訪問的並不是7809埠!每次啟動程式訪問的埠是有變化的,7810、7819。。。,檢視官方文件[Oracle GoldenGate Windows and UNIX Administrator’s Guide],在P20-P21的Maintaining ports for remote connections through firewalls一節中說明了
在有防火牆的網路中,需要開通額外的埠,並使用DYNAMICPORTLIST引數,指定埠範圍。問題已經找到,那就實踐看看,重新申請開通了源端訪問目標端的7809-7830埠,並修改目標端MANAGER程式的引數,加上:
。。。
DYNAMICPORTLIST 7809-7830
。。。
重新啟動MANAGER和PUMP程式,一切OK了!Enjoy!
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/13885898/viewspace-1651406/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 1 Million TCP Connection 問題解決TCP
- oozie.action.hadoop.LauncherException: IO error Connection timed out: no further informationHadoopExceptionErrorORM
- Putty或MobaXTerm無法連線VMware虛擬機器 報Network error: Connection timed out的解決方案虛擬機Error
- WARNING: inbound connection timed out (ORA-3136)連線超時問題
- 【Oracle】 inbound connection timed out (ORA-3136)Oracle
- sqlnet.log error - Operation timed outSQLError
- oracle OGG-01232 Receive TCP params error:TCP/IP error 232(connection reset)OracleTCPError
- Android-問題-obtainBuffer timed out (is the CPU pegged?)AndroidAI
- OGG 同步報錯 - TCP/IP error 111 (Connection refused)TCPError
- 執行systemctl status ssh返回“Failed to get properties: Connection timed out”AI
- Data Pump Import速度問題之解決過程Import
- goldengate關於pump程式的解釋Go
- OGG-01223 TCP/IP error 79 (Connection refused)TCPError
- 報錯(已解決)Command timed out after no timeout
- WARNING: inbound connection timed out (ORA-3136)錯誤分析
- ORA-3136錯誤分析——WARNING Inbound Connection Timed Out
- 【解決】io.lettuce.core.RedisCommandTimeoutException: Command timed outRedisException
- 解決 connect to host github.com port 22 operation timed outGithub
- FTP Connection refused error 解決辦法FTPError
- goldengate 複製程式 Database error 100 (retrieving bind info query)問題解決GoDatabaseError
- TCP/IP 協議相關的問題TCP協議
- java.net.SocketTimeoutException: Read timed out異常解決方法JavaException
- 解決yarn打包時出現“FATAL ERROR: Reached heap limit Allocation failed - JavaScript heap out of memory”的問題YarnErrorMITAIJavaScript
- mysql 主從同步 Error 'Out of range value for column的問題MySql主從同步Error
- 本地開發——TCP Proxy 解決 API 必須繫結 IP 白名單才能訪問的問題TCPAPI
- ascp: Failed to open TCP connection for SSH, exiting. Session Stop (Error: Failed to open TCP connection for SSH)AITCPSessionError
- Feign,HTTP連線超時問題SocketTimeoutException: Read timed outHTTPException
- java.sql.SQLRecoverableException: IO Error: Socket read timed out 排查歷程JavaSQLExceptionError
- CM agent 傳送heartbeat給CM server 不斷髮生 connection refused:timed outServer
- io.lettuce.core.RedisCommandTimeoutException: Command timed out 解決辦法RedisException
- ORA-27102: out of memory 問題解決方法
- 解決python MySQLdb import Error問題PythonMySqlImportError
- syntax error near unexpected token `問題的解決Error
- TCP通訊之經典問題解決TCP
- 【ERROR】ORA-27102: out of memory 解決方法Error
- GoldenGate Extract程式hang問題解決一例Go
- 怎麼解決網站限制IP的問題?網站
- 解決eclipse中出現Resource is out of sync with the file system問題Eclipse