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