2 Replies Latest reply on Aug 19, 2010 6:20 AM by Billy~Verreynne

    smtp_out_server issue

    743848
      Hi All,

      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 'orz@xyz.com' where xyz is my company name.can anybody help me on this.
        • 1. Re: smtp_out_server issue
          sb92075
          can anybody help me on this.
          ask local Postmaster (email administrator)

          nslookup smtp.xyz.com

          port=25
          • 2. Re: smtp_out_server issue
            Billy~Verreynne
            orza wrote:

            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 'orz@xyz.com' where xyz is my company name.can anybody help me on this.
            IP address is not needed - hostname can also be used.

            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
            HELO <oracle_server_ip_address>
            MAIL FROM: <orz@xyz.com>
            RCPT TO: <orz@xyz.com>
            DATA
            Subject: Test mail

            This is a test mail
            .
            QUIT

            (these commands only show your part of the conversation - not the server responses)

            If this works, then SMTP via Oracle will also work.