SYSMAN issue - ORA-25226: dequeue failed, queue SYSMAN.MGMT_ADMINMSG_BUS is not enabled for dequeue

SYSMAN issue:

java.sql.SQLException: ORA-25226: dequeue failed, queue SYSMAN.MGMT_ADMINMSG_BUS is not enabled for dequeue

ORA-06512: at "SYSMAN.EM_ADMINMSG_BUS", line 294

ORA-06512: at line 1

Solution:

Stop the OMS.

exec dbms_aqadm.start_queue('SYSMAN.EM_PC_TP',true,true);

exec dbms_aqadm.start_queue('SYSMAN.EM_LOADERJOB_QUEUE',true,true);

exec dbms_aqadm.start_queue('SYSMAN.MGMT_ADMINMSG_BUS',true,true);

exec dbms_aqadm.start_queue('SYSMAN.EM_GROUP_EVENT_Q',true,true);

exec dbms_aqadm.start_queue('SYSMAN.EM_JOB_STATUS_UPD_Q',true,true);

exec dbms_aqadm.start_queue('SYSMAN.MGMT_LOADER_Q',true,true);

exec dbms_aqadm.start_queue('SYSMAN.EM_EVENT_BUS',true,true);

exec dbms_aqadm.start_queue('SYSMAN.MGMT_TASK_Q',true,true);

exec dbms_aqadm.start_queue('SYSMAN.EM_CNTR_QUEUE',true,true);

exec dbms_aqadm.start_queue('SYSMAN.MGMT_HOST_PING_Q',true,true);

exec dbms_aqadm.start_queue('SYSMAN.MGMT_NOTIFY_INPUT_Q',true,true);

exec dbms_aqadm.start_queue('SYSMAN.MGMT_NOTIFY_Q',true,true);

exec dbms_aqadm.start_queue('SYSMAN.EM_NOTIFY_Q',true,true);

exec dbms_aqadm.start_queue('SYSMAN.EM_SYSTEM_EVENT_Q',true,true);

Start the OMS.

PS:

select 'exec dbms_aqadm.start_queue(''SYSMAN.'||name||''',true,true);' from all_queues 

where trim(enqueue_enabled) = 'NO' 

and owner='SYSMAN'

and queue_type='NORMAL_QUEUE'