The next sections explain how to configure circuit handlers for each command.
data. In this example, the Enterprise Gateway acts
steps:
The Enterprise Gateway provides support for Simple Mail Transfer Protocol (SMTP), which enables the
types:
1. for each of the following SMTP commands:
2. Commands
Oracle packages SYS.UTL_SMTP and SYS.UTL_TCP. steps:
Enterprise Gateway to receive email and to act as a mail relay.
To configure a policy circuit handler for the
The following example from the Enterprise Gateway trace shows the SMTP commands that occur.
Note that utl_mail is covered in more detail concerning its application for developers in Chapter 9 and utl_email and utl_smtp are both covered in more detail for DBAs in Chapter 6. – with consulting OPP log file shows ==> [UNEXPECTED] [51410:RT648550] oracle.apps.fnd.cp.opp.PostProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST.
When you have configured the outbound SMTP protocol, you must then set up an inbound
configuration:
Multiple servers may be specified, separated by commas.
On the Services tab on the left, select a Process tree node (for example, the default Oracle Enterprise Gateway).
email messages using the SMTP protocol, and then forward them on to a configured mail server. shows the possible authentication scenarios and actions based on the SMTP Services
If the first server in the list is unavailable, then UTL_MAIL tries the second server, and so on.. off non-secure, but can be upgraded during the SMTP conversation), a common configuration screen
Enter smtp.gmail.com for the Host. To configure an inbound interface, perform the following steps
successfully, the SMTP conversation resumes. Each separate body in the multi-part is checked for a Content-Transfer-Encoding, and the
The following matrix
Right-click, and select Add SMTP Services. You can use the Policy Studio to configure optional policy circuit handlers
SQL> SELECT UTL_INADDR.get_host_name('192.168.2.4') FROM dual; UTL_INADDR.GET_HOST_NAME('192.168.2.4') ----- bart SQL> The host name of the database server is returned if the specified IP address is NULL or omitted. In order to send emails you need to configure the mail program using the SMTP server IP address. To configure a policy circuit handler for the
perform the following steps in the Policy Studio:
Concurrent Request Delivery Option (Email) - Unable to determine SMTP server to use To configure a policy circuit handler for the
This topic shows how to configure SMTP services,
To configure a STARTTLS outgoing server in your Thunderbird client, perform the following
When an SMTP command is configured in the Policy Studio, each time the SMTP command is accepted
you must deploy the changes to the Enterprise Gateway.
The web addresses used for SMTP servers are like “mail.servername.com” or “smtp.servername.com“. in the Policy Studio:
The Enterprise Gateway can accept incoming
Oracle allows the use of the simpler utl_mail package rather than the utl_smtp package available in previous versions.
Because the SSL and STARTTLS interface types have the potential to be secure (STARTTLS starts
decoding/re-encoding is performed as appropriate. SMTP services using the Enterprise Gateway. by the Enterprise Gateway, the appropriate policy circuit is executed.
When the circuit completes
commands (for example,
The SMTP protocol supports Extended SMTP (ESMTP) PLAIN authentication. interface to accept client connections. marked in These authentication scenarios are described as follows:
Check SMTP access of database Linux server on mail server – Check whether you are able to contact the email gateway server via SMTP from the database Linux box: Check if Oracle packages SYS.UTL_SMTP and SYS.UTL_TCP are available on Oracle database and you have EXECUTE grants on them. To configure a STARTTLS outgoing server in your Thunderbird client, perform the following
Enter 587 for the Port. You can also use the Policy Studio to configure optional policy circuits for specific SMTP
SMTP_OUT_SERVER specifies the SMTP host and port to which UTL_MAIL delivers out-bound E-mail.
Select STARTTLS from the Connection Security drop-down list. For However, Base64 is the only encoding that results in decoding/re-encoding of the mail
If you know the name of the SMTP server you can easily retrieve the SMTP server IP address by following the below steps:- You can choose from the following interface
Multi-part MIME content, generally used for sending attachments in SMTP, is also supported.