CentOS - Jun 2008 - send mail problem on ORACLE/LInux

we have ORACLE 10.2.0.4 with CENTOS 4.4 on DELL server.? Recently we are test
"UTL_SMTP" on ORACLE PL?SQL program and tried to send MAIL to
customers.
?
The problem is this send MAIL program always one time work and second time not
work (loop).? I don't think problem come from ORACLE bug or any ORACLE
relate problem.? If I copy database and put on anyother server, it work
correctly.
?
Does anyone have suggestion?
?
====== sample event happen? ==?
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> @mailbody
?31? .
SQL> /
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 line 15

SQL> /
PL/SQL procedure successfully completed.
?
?
SQL> /
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 line 15
?


     
______________________________________________________________________________________________________
?????????Yahoo!??????2.0????????????? http://tw.mg0.mail.yahoo.com/dc/landing
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.centos.org/pipermail/centos/attachments/20080626/596b9383/attachment-0001.html>

mcclnx mcc wrote:
> The problem is this send MAIL program always one time work and second time
> not work (loop).?  I don't think problem come from ORACLE bug or any
ORACLE
> relate problem.?  If I copy database and put on anyother server, it work
> correctly.
> ?
> Does anyone have suggestion?
Seems like your local SMTP server is not functioning properly, check
the mail logs.

nate

[ re-sending as the original got munged I think one of the
  SMTP servers in-route(maybe mine) saw the period and stopped
  my mail there for some reason.. ]

mcclnx mcc wrote:
> I did NOT see anything wrong on /var/log/maillog.
>
Can you telnet to localhost 25 and send a mail that way ?

e.g.
 [aphro at portal:~]$ telnet localhost 25
 Trying 127.0.0.1...
 Connected to localhost.localdomain.
 Escape character is '^]'.
 220 portal.aphroland.org ESMTP Postfix (Debian/GNU)
 helo portal.aphroland.org
 250 portal.aphroland.org
 mail from: centos at linuxpowered.net
 250 2.1.0 Ok
 rcpt to: centos at linuxpowered.net
 250 2.1.5 Ok
 data
 354 End data with <CR><LF>.<CR><LF>
 Subject: hello there
 testing email
 (put a period here and hit enter)
 250 2.0.0 Ok: queued as B5F52808041
 quit
 221 2.0.0 Bye
 Connection closed by foreign host.

And see if the email arrives at the destination. It seems like
the mail server is not working right as Oracle says it's returning a 421
error code(temporary failure).

And if the telnet works, try it a second, and a third time to see
if it's consistent or not.

nate