My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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 <> .  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 <> is not workable.


Cause

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.