3 Replies Latest reply: Jan 25, 2009 8:46 AM by Charles Hooper RSS

    ORA-29279: SMTP permanent error: 550 5.7.1

    mwz
      Dear All,
           I am trying to send a mail from my database server but getting this following error:
      ORA-29279: SMTP permanent error: 550 5.7.1
      My database server IP is :192.168.10.242
      And I set the SMTP_OUT_SERVER parameter : 192.168.10.242.
      Please help me, how can I solve this problem?
        • 1. Re: ORA-29279: SMTP permanent error: 550 5.7.1
          153119
          Mwz,

          Obviously this is NOT an Oracle error and shouldn't get even posted here.

          Many questions can be resolved by using Google.
          I did a little bit of Googling on your behalf. I just searched for 'SMTP error 550' and came up with
          http://www.answersthatwork.com/Download_Area/ATW_Library/Networking/Network__3-SMTP_Server_Status_Codes_and_SMTP_Error_Codes.pdf

          Hth
          -----
          Sybrand Bakker
          Senior Oracle DBA
          • 2. Re: ORA-29279: SMTP permanent error: 550 5.7.1
            289595
            Please check with your SMTP server admin if relays have got any restriction.
            • 3. Re: ORA-29279: SMTP permanent error: 550 5.7.1
              Charles Hooper
              mwz wrote:
              Dear All,
                   I am trying to send a mail from my database server but getting this following error:
              ORA-29279: SMTP permanent error: 550 5.7.1
              My database server IP is :192.168.10.242
              And I set the SMTP_OUT_SERVER parameter : 192.168.10.242.
              Please help me, how can I solve this problem?
              I wonder if this error message was followed by "554 5.0.0 Service unavailable"? Do you have an email server with a SMTP receive connector on the same server as the Oracle instance? SMTP_OUT_SERVER should point to the remote SMTP (email) server which will receive and route the email message. The documentation could have made that point a little more clear, see:
              http://download.oracle.com/docs/cd/B14117_01/server.101/b10755/initparams198.htm

              If you are able to resolve the above configuration problem, and are still having trouble, you may need to talk with the person responsible for the SMTP (email) server. That person may need to review the SMTP logging (if enabled) to determine the exact problem, and offer suggestions to you and/or modify the configuration of the SMTP server to permit delivery of email messages from the Oracle server. The SMTP log might look something like this one:
              http://playground.sun.com/mobile-ip/WG-archive/current/msg01660.html

              Charles Hooper
              IT Manager/Oracle DBA
              K&M Machine-Fabricating, Inc.