Tuesday, 29 December 2015



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