After Shutdown of 9.2.0.8 Capture Database Streams no LCRs are Enqueued (Doc ID 603857.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Symptoms

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product.  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner. 

Streams Capture is not enqueuing the messages after a database restart whereas it was working fine when initially setup.

After the database is restarted, the capture is failing to enqueue the messages and we see the
following in the capture trace:

***ENQ AQ queue STRMADMIN.STREAMS_QUEUE
knlqenq: correlation id is STREAMS$0$5531693777$
***ENQ in AQ queue STRMADMIN.STREAMS_QUEUE had no recipients - discarded
knlccmt

which  is equivalent to an ORA-24033 error being reported on enqueue.

The buffered queue is not initialised as a result.

The database characterset is UTF8 and the national characterset is also UTF8.

Changes

Cause

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