Following steps applied to avoid unnecessary OEM alerts
if there is network latency i.e if
network fluctuate for few seconds.
We need to increase the inactive time to 300 sec for the
target in OEM repository so that it waits 300 sec and check it aback.
We need to run the following statements in OEM repository
database as sysman user.
--it displays GUID for the given target agent.
$sqlplus
Sql>conn sysman/*******
select TARGET_GUID
from MGMT_TARGETS where TARGET_NAME='<Target agent name>' and
TARGET_TYPE='oracle_emd';
--it will display column with null value or 60
select
max_inactive_time from MGMT_EMD_PING where TARGET_GUID='<target GUID from
above query>';
--Run the below update statement to update the inactive time
to 300.
update MGMT_EMD_PING
set max_inactive_time=300 where TARGET_GUID='<target GUID from 1st query>';
commit;
--check whether updated or not.
select
max_inactive_time from MGMT_EMD_PING where TARGET_GUID='<target GUID from
above query>';
Example :
select TARGET_GUID
from MGMT_TARGETS where TARGET_NAME='ORACLEDBSER02:3872' and
TARGET_TYPE='oracle_emd';
TARGET_GUID
----------------------------------
E4E50946B11639C9AA59A842E4E03CD5
select
max_inactive_time from MGMT_EMD_PING where TARGET_GUID='E4E50946B11639C9AA59A842E4E03CD5>';
max_inactive_time
-----------------------------
update MGMT_EMD_PING
set max_inactive_time=300 where TARGET_GUID='E4E50946B11639C9AA59A842E4E03CD5';
1 row updated
commit;
select
max_inactive_time from MGMT_EMD_PING where TARGET_GUID='<target GUID from
above query>';
max_inactive_time
-----------------------------
300
No comments:
Post a Comment