AQ adapter is failing with ORA-25226 error

Issue –> AQ adapter is failing with dequeue failed. 

Error –> ORA-25226: dequeue failed, queue xx.XX_XX_Q is not enabled for dequeue

Solution –> Execute the below query in respective database.

begin
dbms_aqadm.start_queue(queue_name=>’XX_XX_Q’);
end;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s