Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-30678: too many open connections apex_mail email stuck in queue

tfaJul 30 2020 — edited Jul 30 2020

Currently using apex 18.2 on 11G database.

Issue I've encountered is we have a user that submitted a process that tried to send ~1000 emails via apex_mail.send procedure.  All emails in that batch and a few others encountered error:  ORA-30678: too many open connections.  Those emails are stuck in the queue and will not be sent regardless of APEX_MAIL.PUSH_QUEUE being executed to send them.

New emails arriving in queue are being sent but no emails that have had errors can be sent.  As I understand the error ORA-30678 it's a capacity error and not an error specific with the format or setup of the individual email records.

How can those emails that currently have the ORA-30678 error associated to them be retried and sent from queue?

Regards,

Todd
This post has been answered by jariola on Jul 30 2020
Jump to Answer

Comments

Post Details

Added on Jul 30 2020
#apex-discussions
6 comments
630 views