My Oracle Support Banner

Goldengate Extract Is Not Processing Records On MS SQL on window cluster system (Doc ID 2399607.1)

Last updated on MAY 18, 2018

Applies to:

Oracle GoldenGate - Version 12.3.0.1.3 and later
Information in this document applies to any platform.

Goal

when ogg installed in window cluster system on remote node, ogg extract will not know if the cluster internal issue. 

Here is a case 1:

Source SQL Server databases are on windows cluster (Availability Group) with 3 node local & 1 node remote. when there is network connection issue between local & remote site which caused remote node in Availability Group (AG) to be offline. So SQL Server database was not able to synchronize all databases in AG in sync, which stopped internal log reader from reading transaction logs.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.