My Oracle Support Banner

AQ Messages Not Changing Status from DELAY to READY Or READY to PROCESSED In RAC Databases (Doc ID 2879519.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.14.0.0.0 and later
Information in this document applies to any platform.

Symptoms

If a consumed message stays in READY state or a message in DELAY status has already exceeded its wait time and has not moved to READY, this may be the problem discussed here.

The problem may happen with any user queue as well as it has been noted to happen with Oracle E-Business Suite queues, such as the Workflow Deferred Activities from WF_DEFERRED_QUEUE_M.

Changes

 Using AQ in RAC.

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!

In this Document
Symptoms
Changes
Cause
Solution
References


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