Start oracle dequeue on startup

database oracle oracle-aq
Geln Yang picture Geln Yang · Mar 30, 2010 · Viewed 17.7k times · Source

I got the following error of Oracle,

ORA-25226: dequeue failed, queue string.string is not enabled for dequeue

And the following is the Cause and Action for it from the official document: 

Cause: The queue has not been enabled for dequeue.
Action: Enable the queue using START_QUEUE.

But this error occurs every time when restart the database, is there any configuration to set to start the dequeue on database startup?

thanks!

Answer

Matthew Watson picture Matthew Watson · Mar 30, 2010

What is the status of the queue in dba_queues

select owner,name,enqueue_enabled,dequeue_enabled from dba_queues;

If the queue is disabled, then start it with

begin
 dbms_aqadm.start_queue(queue_name => '<OWNER.QUEUE_NAME>');
end; /

I believe this should persist across restarts, I haven't tested though.

Related questions

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More
How can I get column names from a table in Oracle?

I need to query the database to get the column names, not to be confused with data in the table. For example, if I have a table named EVENT_LOG that contains eventID, eventType, eventDesc, and eventTime, then I would …

Read More