6 Replies Latest reply: Jun 21, 2012 10:41 PM by Sunthar Tharmalingam RSS

    email_alert

    919719
      Hello Friends,
      How to configure mail configuration in linux server 10g. Give me the steps or commands to execute.

      Thanks.
        • 1. Re: email_alert
          hitgon
          Hi,

          http://docs.oracle.com/cd/B14117_01/server.101/b10742/montune.htm#CBBGDIBJ

          http://www.dba-oracle.com/t_email_mailing_messages_plsql.htm

          Please share the oracle version

          Regards
          Hitgon
          • 2. Re: email_alert
            934264
            I got the smtp error. what can i do and how can i configure smtp in my system.
            • 3. Re: email_alert
              hitgon
              please past the error messages
              • 4. Re: email_alert
                919719
                SQL> DECLARE
                2 vSender VARCHAR2(30) := 'vkesov@gmail.com';
                3 vRecip VARCHAR2(30) := 'manislvn@gmail.com';
                4 vSubj VARCHAR2(50) := 'Enter the subject here';
                5 vMesg VARCHAR2(4000) := 'Enter the body';
                6 vMType VARCHAR2(30) := 'text/plain; charset=us-ascii';
                7 BEGIN
                8 utl_mail.send
                9 (vSender, vRecip, NULL, NULL, vSubj, vMesg, vMType,NULL);
                10 END;
                11 /
                DECLARE
                *
                ERROR at line 1:
                ORA-29278: SMTP transient error: 421 Service not available
                ORA-06512: at "SYS.UTL_SMTP", line 21
                ORA-06512: at "SYS.UTL_SMTP", line 97
                ORA-06512: at "SYS.UTL_SMTP", line 139
                ORA-06512: at "SYS.UTL_MAIL", line 405
                ORA-06512: at "SYS.UTL_MAIL", line 594
                ORA-06512: at line 8
                • 5. Re: email_alert
                  JustinCave
                  This doesn't appear to be a security question.

                  The problem appears to be that you've configured a SMTP_OUT_SERVER that either does not exist, that is temporarily down, or that is listening on a different port than the one you specified. This is not an Oracle error. It's an error message coming from whatever SMTP server you're trying to use.

                  Justin
                  • 6. Re: email_alert
                    Sunthar Tharmalingam
                    you can setup the smtp by following the steps here.
                    http://oracletechnologistblog.wordpress.com/2011/11/15/resolving-ora-29278-smtp-transient-error-421-service-not-available/