ORA-25253 listen failed, queue is not enabled for dequeue (Doc ID 1402273.1)

Last updated on FEBRUARY 24, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
Information in this document applies to any platform.
Executable:BIS_RSG_PREP - BIS Request Set Generator Preparation Program
ConcurrentProgram:BIS_DBI_UPDATE_ALL - Request Set Daily Business Intelligence Update
Report:R1730 - Service Contract Renewal
Executable:OKCRAQE - Listener for Events Queue


Symptoms

An application fails with  ORA-25253 listen failed, %s.%s. queue is not enabled for dequeue

The error is supposed to print the queue name in place of %s.%s.  The following query would  give us the queues not enabled for dequeue.

 

Changes

A user or an application have manually stopped a queue.


Cause

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 hundreds of Community platforms