Skip to Main Content

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.

Email send count stuck at 0

Haytham AFeb 4 2025

I followed the steps here to setup my mail on my OCI Autonomous DB (free tier): https://medium.com/@cristina.varas98/configuring-email-in-oracle-apex-on-an-autonomous-database-adb-d46fa015be95

The emails are not being sent, and the count stayed at zero (even with force send).

A couple of questions:

  1. For the sender domain, I tried with fake domain (no-reply@my.email), and real domain I own. Does this have any impact? I am using this for dev only
  2. In this post, seems like setting up a wallet is required. Is that true? How to do that? I did not understand the steps there. None of the other guides mentioned the wallet part
  3. When I run this code, I get the error message below. What does that mean?

BEGIN
APEX_INSTANCE_ADMIN.VALIDATE_EMAIL_CONFIG;
END;
/

ORA-24263: Certificate of the remote server does not match the target address.
ORA-06512: at "SYS.UTL_TCP", line 63
ORA-06512: at "SYS.UTL_TCP", line 331
ORA-06512: at "SYS.UTL_SMTP", line 328
ORA-06512: at "SYS.UTL_SMTP", line 334
ORA-06512: at "APEX_240100.WWV_FLOW_MAIL", line 1314
ORA-06512: at "APEX_240100.WWV_FLOW_MAIL", line 2774
ORA-06512: at "APEX_240100.WWV_FLOW_INSTANCE_ADMIN", line 2152
ORA-06512: at line 2
24263. 00000 - "Certificate of the remote server does not match the target address."
*Cause: The server address on the public key certificate of the remote
server did not match the address used to access the target server.
*Action: Verify the identity of the remote server against fraudulent servers.
If the identity of the remote server is valid, access the server
again while providing the expected address to be matched against
the certificate of the remote server.

This is the code I use to send:

apex_mail.send (
p_to => i_email,
p_from => c_from_email,
p_body => l_body,
p_body_html => l_body,
p_subj => 'Reset password demo account');

apex_mail.push_queue;

This is my APEX instance email config:

This post has been answered by jariola on Feb 4 2025
Jump to Answer
Comments
Post Details
Added on Feb 4 2025
2 comments
67 views