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!

When sending mail from APEX, a problem occurs in which there is no response from the mail queue.

Lee JonghoApr 19 2024

I completed the settings to send mail from APEX.

However, when sending an email, the message 'Success' appears, but there is no response.

The mail send count does not increase, and an error message does not occur.

Can you help me with what I should check?

1. First, I registered the information of the mail and wallet tabs in the internal instance. The smtp server I use requires SSL authentication.

2. ACL registered in DB.

begin 
dbms_network_acl_admin.append_host_ace( 
	host => 'mail.nlcbiz.co.kr', 
	lower_port => 465, 
	ace => xs$ace_type( privilege_list => xs$name_list('connect'), 
						principal_name => 'APEX_230200', 
						principal_type => xs_acl.ptype_db)); 
end;

3. A wallet was also created.

mkstore -wrl /home/oracle/wallets -create

4. After completing all the setup and performing many tests, the problem was not solved. However, the part I don't understand is that when executing validation of the server settings, the following results appear.

I doubt this error is causing the problem, but I haven't found any workarounds or references for the error.

I showed all my work. However, it is difficult to understand why this error occurs, and it is difficult to find a reference for this error.
Do you happen to know how to solve this problem?

Comments
Post Details
Added on Apr 19 2024
2 comments
377 views