Configuring SMTP Connection in APEX Autonomous Database
Posted: Sun Jun 23, 2024 5:00 am
1. Loging to your OCI account.
2. Then Developer Services Under Application Integration, click Email Delivery.
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
4. Creating SMTP user,
5.
6.
7. 8. SMTP Credentials 9. Database tools to execute following code,
Oracle Documentation
2. Then Developer Services Under Application Integration, click Email Delivery.
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
4. Creating SMTP user,
5.
6.
7. 8. SMTP Credentials 9. Database tools to execute following code,
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;