ORA-24067: exceeded maximum number of subscribers for queue ADMIN.SMS_MT_QUEUE

本文主要是介绍ORA-24067: exceeded maximum number of subscribers for queue ADMIN.SMS_MT_QUEUE，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

临时处理办法：

delete from aq$_ss_MT_tab_D;
delete from aq$_ss_MT_tab_g;
delete from aq$_ss_MT_tab_h;
delete from aq$_ss_MT_tab_i;
delete from aq$_ss_MT_tab_p;
delete from aq$_ss_MT_tab_s;
delete from aq$_ss_MT_tab_t;
commit;

 

根本处理办法：

重建aq：admin用户操作--1.停止和删除aqexec dbms_aqadm.stop_queue('sms_mt_queue'); exec dbms_aqadm.drop_queue('sms_mt_queue'); exec dbms_aqadm.drop_queue_table('ss_mt_tab'); /--2.创建队列表begin dbms_aqadm.create_queue_table(queue_table=>'ss_mt_tab', queue_payload_type=>'SYS.AQ$_JMS_TEXT_MESSAGE',multiple_consumers => true); end;/--3.创建队列exec dbms_aqadm.create_queue(queue_name=>'sms_mt_queue', queue_table=>'ss_mt_tab');/--4.启动队列EXECUTE DBMS_AQADM.START_QUEUE (Queue_name => 'SMS_MT_QUEUE');

相关参考：
https://blog.csdn.net/jycjyc/article/details/93617814

这篇关于ORA-24067: exceeded maximum number of subscribers for queue ADMIN.SMS_MT_QUEUE的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---