RE: ORA-29278: SMTP transient error: 421 Service not available

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 27 Jul 2006 08:40:12 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF681477@EXCNYSM0A1AJ.nysemail.nyenet>

Xiaoyezi,  

What everyone is telling you is that you need to find a Microsoft Exchange Email server in your organization. Use that IP address as the Smtp Server address and 25 as the port number.  

Tom  

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of xiaoyan Sent: Thursday, July 27, 2006 8:17 AM
To: Stefan Knecht
Cc: oracle-l
Subject: Re: ORA-29278: SMTP transient error: 421 Service not available  

Does the smtp server in the Internet Information Server of Windows xp work?after start that smtp server,I add the following line:  

SMTP_OUT_SERVER=localhost  

at the end of the file init.ora ,am i correct adding the SMTP_OUT_SERVER parameter in this way?  

But it still does not work! Any idea?

• Original Message -----

        From: Stefan Knecht <mailto:knecht.stefan_at_gmail.com>

        To: xiaoyan <mailto:xiaoyezi.xyz_at_163.com>

        Cc: oracle-l <mailto:oracle-l_at_freelists.org>

        Sent: Thursday, July 27, 2006 7:51 PM

        Subject: Re: ORA-29278: SMTP transient error: 421 Service not available          

        Well you need some service capable of sending out emails - i dont know, but i doubt windows xp comes with such a service.         

        Then you can set the init.ora parameter smtp_out_server to the ip address (and optionally :port if you change the default of 25 during installation of your service) of that smtp service         

        Stefan

        On 7/27/06, xiaoyan <xiaoyezi.xyz_at_163.com> wrote:

          Are you referencing to the smtp_out_server parameter in the init.ora?Do I have to setup another smtp server software and set the the ip address of my computer as the value of smtp_out_server parameter or just set the ip address of another smtp server?            

• Original Message -----

        From: Stefan Knecht <mailto:knecht.stefan_at_gmail.com>

        To: xiaoyezi.xyz_at_163.com

        Cc: oracle-l_at_freelists.org         

        Sent: Thursday, July 27, 2006 7:02 PM

        Subject: Re: ORA-29278: SMTP transient error: 421 Service not available          

        Try to set smtp_out_server parameter to a valid smtp server         

        Stefan                           

        On 7/27/06, xiaoyan <xiaoyezi.xyz_at_163.com <mailto:xiaoyezi.xyz_at_163.com+> > wrote:

        Hi,all

        When I try to use UTL_SMTP package to send mail,I got the following error:         

        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 "SEC_SYSTEM.DEMO_MAIL", line 240
	ORA-06512: at "SEC_SYSTEM.DEMO_MAIL", line 118
	ORA-06512: at "SEC_SYSTEM.DEMO_MAIL", line 104
	ORA-06512: at "SEC_SYSTEM.MAILTEST", line 3
	ORA-06512: at line 2

	 

	Then,where is the problem? Thank you in advance!

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 27 2006 - 07:40:12 CDT