Monitoring user SYS will expire in -32,799 hours

 

Modifying EM Metric Threshold in bulk

1. Login.

./emcli login -username=sysman

2. Select from oms repository.

select './emcli modify_threshold -target_name="'||A.target_name||'" -target_type="oracle_database" -metric="sizeOfOSAuditFiles" -column="FILE_SIZE" -warning_threshold="1000" -critical_threshold="2000" -force' from sysman.MGMT$METRIC_COLLECTION A
where A.target_type='oracle_database' and A.metric_name='sizeOfOSAuditFiles'

3. Execute the result.

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'