Me using amazon simple email service .Previously i had sucesffuly set smtp email for mailgun and also mandrill mail chimp.. But we having issue while using amazon ses ..smtp server.
I am using apex 21.1 on ec2 amazon instance with oracle xe 18 .windows environment.I send the email but the email wont be delivered.When i query
select LOG_DATE,job_name,output from dba_scheduler_job_run_details where job_name like '%MAIL%' order by log_date desc
I see following error.
--------------------------------------------------------------------------------
12-MAY-22 11.00.00.6 ORACLE_APEX_MAIL_QUE
73000 AM +00:00 UE
12-MAY-22 10.55.00.4 ORACLE_APEX_MAIL_QUE
17000 AM +00:00 UE
# APEX|WRN|Exception in "":
# APEX| |Error Stack: ORA-29019: The protocol version is incorrect.
# APEX| |ORA-06512: at "SYS.UTL_TCP", line 63
LOG_DATE JOB_NAME
-------------------- --------------------
OUTPUT
--------------------------------------------------------------------------------
# APEX| |ORA-06512: at "SYS.UTL_TCP", line 314
# APEX| |ORA-06512: at "SYS.UTL_SMTP", line 177
# APEX| |ORA-06512: at "SYS.UTL_SMTP", line 201
# APEX| |ORA-06512: at "APEX_210100.WWV_FLOW_MAIL", line 1031
# APEX| |Backtrace: ORA-06512: at "SYS.UTL_TCP", line 63
# APEX| |ORA-06512: at "SYS.UTL_TCP", line 314
# APEX| |ORA-06512: at "SYS.UTL_SMTP", line 177
# APEX| |ORA-06512: at "SYS.UTL_SMTP", line 201
# APEX| |ORA-06512: at "APEX_210100.WWV_FLOW_MAIL", line 1031
LOG_DATE JOB_NAME
-------------------- --------------------
OUTPUT
--------------------------------------------------------------------------------
# APEX| |ORA-06512: at "APEX_210100.WWV_FLOW_MAIL", line 1652
# APEX| |
12-MAY-22 10.50.01.1 ORACLE_APEX_MAIL_QUE
43000 AM +00:00 UE
# APEX|WRN|Exception in "":
# APEX| |Error Stack: ORA-29279: SMTP permanent error: 530 Must issue a STARTT
LS command first
This is how my email instance settign looks likei have changed ssl tls as yes..If i set it to no
then i only recive the START LS Command first error.
