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!

Sending secure E-Mails using APEX_MAIL fails with ORA-29019: The protocol version is incorrect.

DraganT.Jun 2 2019 — edited Jun 11 2019

Hi

Sending secure E-Mails using APEX_MAIL from an Apex application fails with the error message "ORA-29019: The protocol version is incorrect".
On the other hand sending an email using UTL_SMTP is successful. In both cases we use the same SMTP settings.

We are using a Mail Server of Amazon Workmail/SES, and we configured these parameters under instance settings - Email:

SMTP Host Address: email-smtp.eu-west-1.amazonaws.com
SMTP Host Port: 587
SMTP Authentication Username: UserName
SMTP Authentication Password: Pw
Use SSL/TLS: Yes
Default Email From Address: mail@example.com
Maximum Emails per Workspace: 1000

We created a Wallet and added required certificate. Under instance settings - Wallet we set:

Wallet Path : file:C:\....
Wallet Password: Pw

We use Oracle Database 18c Express Edition Release 18.0.0.0.0 and Application Express 18.2.0.00.12.

Can someone please assist us to get this working. Any help is appreciated.

Thanks
Dragan

This post has been answered by DraganT. on Jun 11 2019
Jump to Answer

Comments

DraganT.
Answer

Hi

we got the problem solved by changing the port number from 587 to 465. 

Now we are also able to send E-Mails to Amazon WorkMail / SES using APEX_MAIL package.

 

Why it makes a difference we cannot explain yet, as the APEX_MAIL package is built upon the UTL_SMTP package according to Oracle documentation.

 

Our working settings now are: 

SMTP Host Address: email-smtp.eu-west-1.amazonaws.com

SMTP Host Port: 465

SMTP Authentication Username: UserName

SMTP Authentication Password: Pw

Use SSL/TLS: Yes

Default Email From Address: info@alytics.ch

Maximum Emails per Workspace: 1000

 

Thanks

Dragan

Marked as Answer by DraganT. · Sep 27 2020
1 - 1

Post Details

Added on Jun 2 2019
1 comment
271 views