Configuring Email Settings

To enable Oracle Application Express to send mail, an Oracle Application Express administrator must configure a email settings on the Instance Settings page.

Additionally, if you are running Oracle Application Express with Oracle Database 11g release 1 (11.1), you need to enable outbound mail. In Oracle Database 11g release 1 (11.1), the ability to interact with network services is disabled by default. For more information, see "Enabling Network Services in Oracle Database 11g".

Tip:

You can configure Oracle Application Express to automatically email users their login credentials when a new workspace request has been approved. To learn more, see "Specifying a Provisioning Mode".

To configure Oracle Application Express to send mail:

Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".
Click Manage Service.
Under Manage Environment Settings, click Instance Settings.
Under Email, enter the following:
1. SMTP Host Address - Defines the server address of the SMTP server. By default on installation, this is set to localhost. If you are using another server as an SMTP relay, change this parameter to that server's address.
2. SMTP Host Port - Defines the port the SMTP server listens to for mail requests. The default setting is 25.
3. Administration Email Address - Defines the "from" address for administrative tasks that generate email, such as approving a provision request or resetting a password.
Click Apply Changes.