Configuring SMTP Connection in APEX Autonomous Database

[admin]

1. Loging to your OCI account.
2. Then Developer Services Under Application Integration, click Email Delivery.

email1.png

3. Now Under Email Delivery, click Configuration and the SMTP sending information panel displays the following information:

Public Endpoint: smtp.email.ap-singapore-1.oci.oraclecloud.com (this will be different for each region.
SMTP Ports: 587 (recommended) or 25
Security: TLS Required

emial2.png

4. Creating SMTP user,

domain1.png

5.

domain2.png

6.

domain3.png

7.

domain4.png

8. SMTP Credentials

smtp_cred1.png

9. Database tools to execute following code,

db_tools.png

Code: Select all

BEGIN
 APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_HOST_ADDRESS', 'smtp.email.ap-singapore-1.oci.oraclecloud.com');
APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_USERNAME', 'username');
APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_PASSWORD', 'Password');
COMMIT;
END;

BEGIN
    APEX_INSTANCE_ADMIN.VALIDATE_EMAIL_CONFIG;
END;

sql.png

Oracle Documentation