RE: utl_smtp error

From: Chris Berry <compjma_at_hotmail.com>
Date: Thu, 27 Mar 2003 10:23:55 -0800
Message-ID: <F001.005747D2.20030327102355@fatcity.com>

>-----Original Message-----
>Sent: Thursday, March 27, 2003 9:14 AM
>To: Multiple recipients of list ORACLE-L
>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?

What MTA are you running?

Chris Berry
compjma_at_hotmail.com
Systems Administrator
JM Associates

"Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken." -- Duke Leto Atreides

---

Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chris Berry
  INET: compjma_at_hotmail.com

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:23:55 CST