ORACLE_APEX_MAIL_QUEUE Job Is Not Sending Mail To Users In RAC Environment And the DBA_SCHEDULER_JOBS Shows the Job Is Disabled Even After Enabling It (Doc ID 2590989.1)

Last updated on NOVEMBER 20, 2024

Applies to:

Oracle Application Express (APEX) - Version 18.1 and later
Information in this document applies to any platform.
Checked for relevance on 04-Mar-2024

Symptoms

ORACLE_APEX_MAIL_QUEUE is not sending mail to users. It show no errors

APEX 18.1 installed in Database ("RAC") 12.2.
APEX was installed a year ago. Didn't have any problems with emails.

Encountered a problem with the ORACLE_APEX_MAIL_QUEUE job, it was broken.

Dropped the job and recreated it per --> Outbound Email Delivery From APEX Seems To Stall (Stuck) (Doc ID 2057872.1)
But the mail is not getting delivered and apex_mail_queue table shows messages in the queue.

The mail can be sent manually using utl_smtp package.

NOTE:
The DBA_SCHEDULER_JOBS shows that the ORACLE_APEX_MAIL_QUEUE is Not Enabled (ENABLED -> FALSE).

The query

result still the same:

OWNER JOB_NAME ENABL

APEX_180100 ORACLE_APEX_MAIL_QUEUE FALSE

--> The job is not getting enabled.

Changes

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

ORACLE_APEX_MAIL_QUEUE Job Is Not Sending Mail To Users In RAC Environment And the DBA_SCHEDULER_JOBS Shows the Job Is Disabled Even After Enabling It (Doc ID 2590989.1)

Applies to:

Symptoms

Changes

Cause

To view full details, sign in with your My Oracle Support account.

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