GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Have disabled automatic split/merge in 11.2, yet see strange entry in alert log

edited Mar 28, 2013 10:22AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Hello, Community.

For many years I have been successfully using Oracle Streams with 10.2 for an application involving N-way multi-master replication. 

More recently I have been working with 11.2.  I am aware of the split/merge solution offered in 11.2, but do not wish to use the feature at this time.  I have, hopefully, disabled the feature by setting the following parameter on my capture process.

      DBMS_CAPTURE_ADM.SET_PARAMETER(
        capture_name => 'STREAMS_CAPTURE',
        parameter    => 'split_threshold',
        value        => 'INFINITE');

Great.

While browsing the alert log on a normally operating system, I have twice seen an unexpected entry.

Wed Mar 06 02:53:18 2013
dbms_streams_auto_int.submit_split_merge_streams_job(): exception, sql code = -1405, error message: ORA-01405: fetched column value is NULL

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center