Oracle-L: RE: utl

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Thu, 27 Mar 2003 06:54:06 -0800
Message-ID: <F001.0057432E.20030327065406@fatcity.com>

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
---------------------------------------------------------------------

RE: utl_smtp error