APEX_MAIL.PUSH_QUEUE Results In ORA-30678: Too Many Open Connections
(Doc ID 2696366.1)
Last updated on FEBRUARY 09, 2023
Applies to:
Oracle Application Express (APEX) - Version 18.2.0.00.12 and laterInformation in this document applies to any platform.
Symptoms
On : 18.2.0.00.12 version
When attempting to run the APEX_MAIL.PUSH_QUEUE procedure,
the following error occurs.
ERROR
-----------------------
ORA-30678: too many open connections.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run:
APEX_MAIL.PUSH_QUEUE(
p_smtp_hostname IN VARCHAR2 DEFAULT NULL,
p_smtp_portno IN NUMBER DEFAULT NULL);
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot send e-mails that are stuck in the mail queue.
Changes
A large amount of e-mails were sent using the APEX_MAIL.SEND procedure.
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
Symptoms |
Changes |
Cause |
Solution |