Logminer Does Not Work On 2nd Node Of A 2-Node Rac With Continuous_mine Option. (Doc ID 759186.1)

Last updated on FEBRUARY 18, 2009

Applies to:

Oracle Server Enterprise Edition - Version: 10.2.0.4
This problem can occur on any platform.
Oracle Server - Enterprise Edition - Version: 10.2.0.4

Symptoms

-- Problem Statement:
Logminer stops sending data on a Logminer request when a 2-Node RAC fails over to the second node.
When the original node returns all data is retrieved. However, for a system depending on
up-to-the-minute data, this is not a workable solution.

An upgrade to Oracle 10.2.0.4 was applied to resolve <<bug 5503590>> .  It resolved the problem of Logminer hanging completely, but not the issue of it hanging on the second node.

Since continous_mine was being used, the workaround described in <<bug 5503590>> is not workable.


Cause

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 hundreds of Community platforms