This content has been marked as final. Show 2 replies
can anybody help me on this.ask local Postmaster (email administrator)
orza wrote:IP address is not needed - hostname can also be used.
SQL>alter system set smtp_out_server = '<ip-address:port' scope=Both;
In the above statement.i wants to know how i know 'ip-address:port'. say i have official mail id as 'firstname.lastname@example.org' where xyz is my company name.can anybody help me on this.
The standard hostname for a mail (smtp) server in most companies is mail.domain.com. You can confirm that by using ping mail.xyz.com to see if the hostname is valid, can resolve to an IP and is reachable (do this from the Oracle server).
If not, then try hostname smtp.xyz.com instead.
Some corporate mail servers use IP accept/deny lists - and will only accept mail from specific IP addresses. You can test this by attempting to manually send an e-mail via telnet from the Oracle server (make sure local echo is enabled when using Windows gunky telnet). E.g.
telnet mail.xyz.com 25
MAIL FROM: <email@example.com>
RCPT TO: <firstname.lastname@example.org>
Subject: Test mail
This is a test mail
(these commands only show your part of the conversation - not the server responses)
If this works, then SMTP via Oracle will also work.