Enterpise Manager Grid Control Does Not Send any Email Notifications (Doc ID 1083983.1)

Last updated on MARCH 14, 2012

Applies to:

Enterprise Manager Base Platform - Version: 10.2.0.2 to 11.1.0.1 - Release: 10.2 to 11.1
Information in this document applies to any platform.
The troubleshooting steps in have been carried out, but email notifications are not being received.

Diagnosis
~~~~~~~~
1. The following query (run at sql*plus in the repository database) shows that the 'last run' date is in the past.

set pagesize 80
ttitle -
center 'List Submitted Jobs' skip 2

col jid format 999 heading 'Id'
col subu format a10 heading 'Submitter' trunc
col secd format a10 heading 'Security' trunc
col proc format a20 heading 'Job' word_wrapped
col lsd format a5 heading 'Last|Ok|Date'
col lst format a5 heading 'Last|Ok|Time'
col nrd format a5 heading 'Next|Run|Date'
col nrt format a5 heading 'Next|Run|Time'
col fail format 999 heading 'Errs'
col ok format a2 heading 'Ok'

select
job jid,
log_user subu,
priv_user secd,
what proc,
to_char(last_date,'MM/DD') lsd,
substr(last_sec,1,5) lst,
to_char(next_date,'MM/DD') nrd,
substr(next_sec,1,5) nrt,
failures fail,
decode(broken,'Y','N','Y') ok
from
sys.dba_jobs
/

2. job_queue_processes > 0

3. ps -ef | grep cjq

This should return the job queue coordinator process
oracle 15319 1 0 Mar24 ? 00:00:52 ora_cjq0_EMREP

In this case no process is returned.

4. If "EMD_NOTIFICATION.CHECK_FOR_SEVERITIES();" is manually ran, emails are received.

SQL> show user
USER is "SYSMAN"
SQL> execute EMD_NOTIFICATION.CHECK_FOR_SEVERITIES();

PL/SQL procedure successfully completed.

Symptoms

Enterprise Manager internal repository jobs are not running
Enterprise Manager Emails are not received

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms