ORA-25226: dequeue failed, queue APPLSYS.AQ$_WF_NOTIFICATION_OUT_E is not enabled for dequeue

Issue:

ORA-25226: dequeue failed, queue APPLSYS.AQ$_WF_NOTIFICATION_OUT_E is not enabled for dequeue

Solution :

SQL>Conn as applsys

SQL> begin

2 dbms_aqadm.start_queue(‘AQ$_WF_NOTIFICATION_OUT_E’,FALSE,TRUE);

3 end;

4 /

PL/SQL procedure successfully completed..

Note : Above is only for exception queue .

For normal start up use below

SQL> begin

2 dbms_aqadm.start_queue(queue_name=>’WF_NOTIFICATION_OUT’);

3 end;

4 /

PL/SQL procedure successfully completed.

Rerference : 1322645.1,49718.1 and 1290221.1