OGG 12.3 Extract Abends With Error OGG-01224 Address Already In Use
Information in this document applies to any platform.
2019-03-20T21:16:44.571+0000 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, EXTC00.prm: .
2019-03-20T21:16:44.581+0000 ERROR OGG-01224 Oracle GoldenGate Capture for Oracle, EXTC00.prm: Address already in use.
2019-03-20T21:16:44.582+0000 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, EXTC00.prm: PROCESS ABENDING.
Bug 28011195 - Port scans cause extract / replicat abend with OGG-1224 Address already in use
APPLIES TO:
Oracle GoldenGate - Version 12.3.0.1.0 and laterInformation in this document applies to any platform.
SYMPTOMS
On : 12.3.0.1.0 version, 1 - Oracle DB backend
OGG 12.3 Extract abends with "Address already in use."
We have set up OGG12.3 in microservices architecture. The extract abends randomly with below error message:
OGG 12.3 Extract abends with "Address already in use."
We have set up OGG12.3 in microservices architecture. The extract abends randomly with below error message:
2019-03-20T21:16:44.571+0000 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, EXTC00.prm: .
2019-03-20T21:16:44.581+0000 ERROR OGG-01224 Oracle GoldenGate Capture for Oracle, EXTC00.prm: Address already in use.
2019-03-20T21:16:44.582+0000 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, EXTC00.prm: PROCESS ABENDING.
CAUSE
Using the port scanning software will impact OGG. When an Oracle GoldenGate process receives communication on its port that is not from another OGG process, it will interpret this as an attack and will immediately abend to prevent any intrusion into the product.
This was reported via below bug :
Bug 28011195 - Port scans cause extract / replicat abend with OGG-1224 Address already in use
This issue doesn't exist in prior versions than GG 12.3
SOLUTION
As a workaround, you can ask your network team to disable the port scanning software or exclude these ports from scanning, if possible.
As a fix, please apply the patch suitable for your configuration (DB/OS) for bug 28011195
For Oracle 12c database on Linux 64 platform, below patch is available on My oracle support:
Patch 28203147: Patch for BLR 28011195: Linux x86-64: Oracle 12c: OGG 12.3.0.1.2
If you don't see patch available for your configuration, please consult Oracle support to get one-off patch.
No comments:
Post a Comment