Configure OEM Console in Oracle 19c - Exercise

To configure Oracle Enterprise Manager (OEM) Console in Oracle 19c to run batch jobs and send email alerts, follow these steps:
Step 1: Configure the Oracle Management Service (OMS) and Agent
Before scheduling batch jobs and sending email alerts, ensure that Oracle Enterprise Manager Cloud Control 19c is installed and properly configured.

1. Verify OEM Cloud Control Status
   

   emctl status oms
   

   
   If it's not running, start it with:
   

   emctl start oms
   

2. Ensure the Agent is Running
   

   emctl status agent
   

   If the agent is down, start it with:
   

   emctl start agent
   

Step 2: Configure Batch Jobs in OEM 19c

2.1: Create a Job

1. Login to Oracle Enterprise Manager Cloud Control 19c as an administrator.
2. Navigate to Enterprise → Job Activity.
3. Click on Create to define a new job.
4. Choose a predefined job type, such as:
   • SQL Script
   • Host Command
   • RMAN Backup
   • PL/SQL Block
5. Configure the Target (Database, Host, Listener, etc.).
6. Set the Job Parameters (such as script location, environment variables).
7. Define Execution Schedule (Once, Recurring, or On Demand).
8. Click Submit to save and activate the job.

2.2: Verify the Job

• Go to Enterprise → Job Activity and check the job execution status.
• Use this SQL to check job run history:

SELECT job_name, status, start_time, end_time 
FROM dba_scheduler_job_run_details 
WHERE job_name = 'YOUR_JOB_NAME';

Step 3: Configure Email Notifications in OEM 19c
3.1: Enable SMTP Settings

1. Log in to OEM Cloud Control.
2. Navigate to Setup → Notifications → Notification Methods.
3. Configure the Email Server (SMTP) settings:
   • SMTP Hostname: (e.g., smtp.example.com)
   • Port: Typically 25, 465 (SSL), or 587 (TLS)
   • Enable Authentication (if required)
   • Sender Email Address: (e.g., oem-alerts@example.com)
4. Click Test Mail to verify the settings.

3.2: Configure Email Notifications for Jobs

1. Navigate to Setup → Notifications → Rules.
2. Click Create to define a new notification rule.
3. Set Event Type (e.g., Job Failure, Job Success, Database Down).
4. Assign a Target Database or Host.
5. Configure Recipients by adding email addresses.
6. Save the configuration.

Step 4: Test the Configuration

1. Run a Test Job
   • Create a simple job that runs a SQL script.
   • Verify the job execution in the Job Activity tab.
2. Trigger an Email Alert
   • Simulate a job failure (e.g., incorrect SQL).
   • Check if the notification email is received.

Step 5: Automate the Batch Job Execution (Optional)
If you want to schedule a batch script outside of OEM, use DBMS_SCHEDULER:

BEGIN
  DBMS_SCHEDULER.create_job (
    job_name        => 'TEST_BATCH_JOB',
    job_type        => 'EXECUTABLE',
    job_action      => '/u01/app/oracle/scripts/myscript.sh',
    start_date      => SYSTIMESTAMP,
    repeat_interval => 'FREQ=DAILY; BYHOUR=2;',
    enabled         => TRUE);
END;
/

To check the job:

SELECT job_name, enabled, state FROM dba_scheduler_jobs WHERE job_name = 'TEST_BATCH_JOB';

Final Checks

• ✅ Verify SMTP settings in OEM
• ✅ Test an email alert
• ✅ Confirm batch jobs run on schedule