Configuring SMTP Connection in APEX Autonomous Database

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2071
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Configuring SMTP Connection in APEX Autonomous Database

Post by 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
You do not have the required permissions to view the files attached to this post.
Malik Sikandar Hayat
Oracle ACE Pro
info@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests