Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: utl_smtp error

Re: utl_smtp error

From: Joan Hsieh <joan.hsieh_at_tufts.edu>
Date: Thu, 27 Mar 2003 10:09:57 -0800
Message-ID: <F001.0057473E.20030327100957@fatcity.com>


Thanks Tom, I checked with stmp mail administrator, according to what she said, there is no maintenace and service outage going on recently. And she said she couldn't find any errors on the email log.

joan

"Mercadante, Thomas F" wrote:
>
> Joan,
>
> my experience with this error was that the email service (usually the
> Outlook server) was not available when you tried to send mail. If I were
> you, I would check with your Email Administrator to see if the service was
> running. Maybe they were doing some weekly maintenance or something and the
> email service went down. Could also be a network outage or something like
> that.
>
> Hope this helps.
>
> Tom Mercadante
> Oracle Certified Professional
>
> -----Original Message-----
> Sent: Thursday, March 27, 2003 9:14 AM
> To: Multiple recipients of list ORACLE-L
>
> Hi Dear List,
>
> Question again,
> We have 3 databases on test server and one instance on production
> server. 8.1.7.4 oracle;
> None of them had those problem before. The email always working and had
> been tested throughly.
> Recently we got ORA-20001: 421 Service not available
> ORA-06512: at "SYS.UTL_SMTP", line 83
> ORA-06512: at "SYS.UTL_SMTP", line 121
> ORA-06512: at line 5
> these errors. I noticed that some of ctxsys packages became invalid.
> After I
> recompiled all the objects, the errors are gone, it seems working.
> However, after
> 2 or 3 times success sent email, the errors showed up again. On
> production
> server, after I recompiled the packages, first time run successfully,
> then
> error out.
> I am not sure why it start to error out? It is not consistent,
> sometimes works and sometimes not; I checked all the related documents
> regarding these errors. Nothing really matches our case. Does anyone can
> point me where I should look into it?
>
> Thanks always,
>
> Joan
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
> INET: joan.hsieh_at_tufts.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Mar 27 2003 - 12:09:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US