APEX on a 12.2 DB Configuring an Email Server with SSL/TLS gets ORA-24263: Certificate Of The Remote Server Does Not Match The Target

(Doc ID 2365964.1)

Last updated on MARCH 02, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle Application Express (APEX) - Version 5.0 to 5.1.4.00.08 [Release 5]
Information in this document applies to any platform.

Symptoms

APEX 5.x on 12.2.x  database.

When attempting to configure in APEX Instance setting an email server with SSL/TLS  (i.e Office365), the following error occurs:

ORA-24263: Certificate of the remote server does not match the target


Steps to Reproduce
The issue can be reproduced at will with the following steps:

1. Configure Email in APEX Instance with following options (using the sample of office365 but it could be any other mail server):

SMTP Host Address: smtp.office365.com
SMTP Host Port: 587
SMTP Authentication Username: x@x.com
SMTP Authentication Password: Password for x@x.com
Use SSL/TLS: After connection is established                          <<<<<<<<<Default Email From Address: x@x.com

 

2. Send an email from inside APEX and the error appears.




Changes

 Upgraded to or configured a new installation of APEX 5.x on a 12.2 database.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms