Configuring Email Settings

To enable Oracle Application Express to send mail, an Oracle Application Express administrator must configure email settings

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" for your configuration scenario in Oracle Application Express Installation Guide.

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".

Topics:

Configuring Email in a Full Development Environment
Configuring Email in a Runtime Environment
Determining Email Settings in a Runtime Environment

Configuring Email in a Full Development Environment

To configure Oracle Application Express to send mail in a full development environment:

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.

Configuring Email in a Runtime Environment

To configure Oracle Application Express to send mail in a runtime environment:

Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:
- On Windows:
```
SYSTEM_DRIVE:\ sqlplus /nolog
connect sys as sysdba
```
- On UNIX and Linux:
```
$ sqlplus /nolog
connect sys as sysdba
```
When prompted enter the appropriate password.

Run the following statement:

ALTER SESSION SET CURRENT_SCHEMA = APEX_030200

Run the following statement:

BEGIN
   APEX_INSTANCE_ADMIN.GET_PARAMETER(PARAMETER_NAME, PARAMETER_VALUE);
END;

For a description of email parameters, see Table: Email Parameters.

Email Parameters

Parameter Name Description

Parameter Name	Description
`SMTP_FROM`	Defines the "from" address for administrative tasks that generate email, such as approving a provision request or resetting a password. Enter a valid email address, for example: `someone@somewhere.com`
`SMTP_HOST_ADDRESS`	Defines the server address of the SMTP server. If you are using another server as an SMTP relay, change this parameter to that server's address. Default setting: localhost
`SMTP_HOST_PORT`	Defines the port the SMTP server listens to for mail requests. Default setting: 25

SMTP_FROM

Defines the "from" address for administrative tasks that generate email, such as approving a provision request or resetting a password.

Enter a valid email address, for example:

someone@somewhere.com

SMTP_HOST_ADDRESS

Defines the server address of the SMTP server. If you are using another server as an SMTP relay, change this parameter to that server's address.

Default setting:

localhost

SMTP_HOST_PORT

Defines the port the SMTP server listens to for mail requests.

Default setting:

Determining Email Settings in a Runtime Environment

To determine email settings in runtime environment:

Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:
- On Windows:
```
SYSTEM_DRIVE:\ sqlplus /nolog
connect sys as sysdba
```
- On UNIX and Linux:
```
$ sqlplus /nolog
connect sys as sysdba
```
When prompted enter the appropriate password.

Run the following statement:

ALTER SESSION SET CURRENT_SCHEMA = APEX_030200

Run the following statement:
```
SELECT 
APEX_INSTANCE_ADMIN.GET_PARAMETER(PARAMETER_NAME)
FROM DUAL;
```
For a description of email parameters, see Table: Email Parameters.