Launch Oracle bypass at startup

Question

I got the following Oracle error,

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

And the following: Reason and Action for him from an official document:

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

But this error occurs every time the database is restarted, is there any configuration to set the start of the queue when the database starts?

thanks!

Answer 1

What is the queue status in dba_queues

 select owner,name,enqueue_enabled,dequeue_enabled from dba_queues; 

If the queue is disabled, start it with

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

I believe this should continue through reboots, I have not tested it yet.