Wednesday, May 8, 2019

OGG 12.3 Extract Abends With ERROR OGG-01224 Address Already In Use

OGG 12.3 Extract Abends With Error OGG-01224 Address Already In Use 

APPLIES TO:

Oracle GoldenGate - Version 12.3.0.1.0 and later
Information 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:

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

How can I restore Cassandra snapshots?