首页 » GoldenGate » Ogg 12.3 PROCESS ABENDING with “OGG-01224 Address already in use”

Ogg 12.3 PROCESS ABENDING with “OGG-01224 Address already in use”

  • 2020/01/19
  • GoldenGate
  • 804 views
  • Ogg 12.3 PROCESS ABENDING with “OGG-01224 Address already in use”已关闭评论

Oracle 12.2 GoldenGate(ogg) 进程突然全部PROCESS ABENDING,MGR中配置了autostart，自动启动后恢复正常，但错误日志中出现了OGG-01224 Address already in use。

Oracle GoldenGate Command Interpreter for Oracle
Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Apr 16 2018 00:53:30
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.

— show ggserr.log

2020-01-19T14:11:42.769+0800  INFO    OGG-02756  Oracle GoldenGate Capture for Oracle, dep1.prm:  The definition for table GGADMIN.GG_HEARTBEAT is obtained from the trail file.
2020-01-19T14:11:42.839+0800  INFO    OGG-02756  Oracle GoldenGate Capture for Oracle, dep1.prm:  The definition for table GGADMIN.GG_HEARTBEAT_SEED is obtained from the trail file.
2020-01-19T14:11:57.456+0800  WARNING OGG-01223  Oracle GoldenGate Manager for Oracle, mgr.prm:  Connection reset by peer.
2020-01-19T14:12:06.683+0800  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, d2_xxxxb.prm:  .
2020-01-19T14:12:13.435+0800  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, ext2.prm:  .
2020-01-19T14:12:14.985+0800  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, ext1.prm:  .
2020-01-19T14:12:22.695+0800  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, d2_xxxx.prm:  .
2020-01-19T14:12:24.002+0800  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, d2_xxxxd.prm:  .
2020-01-19T14:12:25.978+0800  INFO    OGG-01971  Oracle GoldenGate Capture for Oracle, ext1.prm:  The previous message, 'WARNING OGG-01223', repeated 1 times.
2020-01-19T14:12:25.978+0800  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, ext1.prm:  Address already in use.
2020-01-19T14:12:26.029+0800  INFO    OGG-01971  Oracle GoldenGate Capture for Oracle, d2_xxxxd.prm:  The previous message, 'WARNING OGG-01223', repeated 1 times.
2020-01-19T14:12:26.037+0800  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, d2_xxxxd.prm:  Address already in use.
2020-01-19T14:12:26.037+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, d2_xxxxd.prm:  PROCESS ABENDING.
2020-01-19T14:12:26.121+0800  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, dep1.prm:  .
2020-01-19T14:12:26.260+0800  INFO    OGG-01971  Oracle GoldenGate Capture for Oracle, d2_xxxxa.prm:  The previous message, 'WARNING OGG-01223', repeated 1 times.
2020-01-19T14:12:26.411+0800  INFO    OGG-01971  Oracle GoldenGate Capture for Oracle, ext2.prm:  The previous message, 'WARNING OGG-01223', repeated 1 times.
2020-01-19T14:12:26.411+0800  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, ext2.prm:  Address already in use.
2020-01-19T14:12:26.721+0800  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, d2_xxxxc.prm:  .
2020-01-19T14:12:26.723+0800  INFO    OGG-01971  Oracle GoldenGate Capture for Oracle, d2_xxxx.prm:  The previous message, 'WARNING OGG-01223', repeated 1 times.
2020-01-19T14:12:26.723+0800  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, d2_xxxx.prm:  Address already in use.
2020-01-19T14:12:26.723+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, d2_xxxx.prm:  PROCESS ABENDING.
2020-01-19T14:12:26.804+0800  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, d2_im.prm:  .
2020-01-19T14:12:26.830+0800  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, d2_im.prm:  Address already in use.
2020-01-19T14:12:26.830+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, d2_im.prm:  PROCESS ABENDING.
2020-01-19T14:12:26.850+0800  INFO    OGG-01971  Oracle GoldenGate Delivery for Oracle, r1.prm:  The previous message, 'WARNING OGG-01223', repeated 1 times.
2020-01-19T14:12:26.868+0800  INFO    OGG-01971  Oracle GoldenGate Capture for Oracle, d2_xxxxb.prm:  The previous message, 'WARNING OGG-01223', repeated 1 times.
2020-01-19T14:12:26.868+0800  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, d2_xxxxb.prm:  Address already in use.
2020-01-19T14:12:26.868+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, d2_xxxxb.prm:  PROCESS ABENDING.
2020-01-19T14:12:27.005+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ext2.prm:  PROCESS ABENDING.
2020-01-19T14:12:27.056+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ext1.prm:  PROCESS ABENDING.
2020-01-19T14:12:57.969+0800  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT D2_SMS starting.

安全部门使用端口扫描软件会影响OGG进程。 当该进程在端口上收到来自非Oracle GoldenGate进程的通信时，OGG会解释为攻击，并将立即abend进程以防止对该产品的任何入侵。

可以通知安全部门避免OGG的端口扫描，但往往不可能，在OGG12.3版本以前不存在该问题，在12.2中是以另外一种通知方式，可以参考我之前的BLOG《 OGG-01022 Unknown N bytes message received & OGG-01223 Connection reset by peer》, Oracle 已确认为 OGG BUG.
Bug 28011195 – Port scans cause extract / replicat abend with OGG-1224 Address already in use.

需要下载安装对应的版本补丁解决问题，如当前我们的版本Version 12.3.0.1.4
Patch 28225926: Patch for BLR 28011195: Linux x84-64: Oracle 12c: OGG 12.3.0.1.4

打赏

对不起，这篇文章暂时关闭评论。

上一篇：

下一篇：