Thursday, September 29, 2011

Unable to recieve Grid Control Alerts in Email

Please make sure that you have setup the notifications as per the following documents:

Note 429426.1:Configuring Email Notification Method in EM - Steps and Troubleshooting
Note 429422.1: How To Configure Notification Rules in Enterprise Manager Grid Control?

If still the issue is there then proceed with the following


- Stop the OMS:

cd /opmn/bin
./opmnctl stopall


- Login to the Repository Database as the SYSMAN user and execute:

BEGIN
emd_maintenance.remove_em_dbms_jobs();
emd_maintenance.submit_em_dbms_jobs();
commit;
end;

- Check the schedule of the dbms_jobs using:

SELECT p.display_name
FROM (SELECT display_name, dbms_jobname
FROM mgmt_performance_names
WHERE is_dbmsjob = 'Y') p,
user_jobs j
WHERE UPPER(j.what) LIKE '%'||UPPER(p.dbms_jobname)||'%'
AND (
j.broken != 'N'
OR
j.failures > 0
OR
(j.next_date < SYSDATE-1/48 AND j.this_date IS NULL)
OR
(j.next_date < SYSDATE-1/6 AND j.this_date IS NOT NULL)
);

This query should NOT return any rows.

- Re-start the OMS:

cd /opmn/bin
./opmnctl startall

- Wait for sometime and check whether you are receiving the email notifications.

No comments:

Post a Comment