My Oracle Support Banner

AQ Messages Not Changing WAIT State To READY After Delay Time Over RAC (Doc ID 2973458.1)

Last updated on DECEMBER 16, 2023

Applies to:

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

Symptoms

AQ Messages Not Changing WAIT State To READY After Delay Time Over

If we enqueue message from queue table non owner instance with delay, it goes to WAIT state and never change to READY sate, While when enqueue from node which owner of queue table, it is working.

Although we have applied patches for bugs 33812475, 33545698, 32598380 and bug 35264103

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
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.