ERROR OGG-01224 Oracle GoldenGate Capture for Oracle, p_lion.prm: Address already in use.

发布时间 2023-09-15 09:43:58作者: 蚌壳里夜有多长

我的ogg版本

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 11g on Apr 15 2018 21:16:09
Operating system character set identified as UTF-8.

报错信息

2023-09-04T20:28:59.960+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, p_vehf.prm:  PROCESS ABENDING.
2023-09-14T22:03:07.780+0800  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, p_lion.prm:  Address already in use.
2023-09-14T22:03:07.800+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, p_lion.prm:  PROCESS ABENDING.
2023-09-14T22:03:22.358+0800  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, p_cred.prm:  Address already in use.
2023-09-14T22:03:22.364+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, p_cred.prm:  PROCESS ABENDING.

这个报错是对12.3版本ogg新加功能

这是由于使用端口扫描软件会影响OGG。当Oracle GoldenGate进程在其端口上接收到不是来自另一个OGG进程的通信时,它会将其解释为攻击,并立即停止以防止对产品的任何入侵。这个新功能是ogg12.3新功能

这是定位了Bug 28011195  - Port scans cause extract / replicat abend with OGG-1224 Address already in use

可以mos搜索bug号来下载one-off补丁进行apply

我的版本补丁号是Patch 30703128: PATCH FOR MLR30547022: Linux x86-64: Oracle11g: OGG 12.3.0.1.4