1 Reply Latest reply on Jun 11, 2019 7:41 PM by DraganT.

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

DraganT. Jun 2, 2019 9:29 PM

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

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

DraganT. Jun 11, 2019 7:41 PM (in response to DraganT.)

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
Like Show 0 Likes(0)

Actions