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.
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