This discussion is archived
2 Replies Latest reply: Jan 30, 2013 3:09 AM by Rob_J RSS

SMTP Mail sending Utility failure

Madesh Newbie
Currently Being Moderated
I have a scheduled procedure that trigger mails to user using SMTP packages. It was working fine quite a period when we were with Oracle 10g and its not working now when we upgrade to oracle 11g. It throws the below error when we execute the procedure.

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 127
ORA-06512: at "SYS.UTL_SMTP", line 150

Would like to have experts advise. Thanks in Advance
  • 1. Re: SMTP Mail sending Utility failure
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl post OS details and exact versions of "10g" and "11g" - were all of the post-upgrade steps completed ?

    http://docs.oracle.com/cd/E11882_01/server.112/e23633/afterup.htm#CEGDGAHJ

    Pl see these MOS Docs

    How To Verify Current ACL Settings For Network Resources [ID 1364026.1]
    Ora-24247: Network Access Denied By Access Control List (Acl) Using localhost as SMTP Server Name [ID 1348855.1]
    FAQ and Known Issues While Using UTL_SMTP and UTL_MAIL [ID 730746.1]

    HTH
    Srini
  • 2. Re: SMTP Mail sending Utility failure
    Rob_J Journeyer
    Currently Being Moderated
    Hi,

    I had this same problem and you can find some notes here about the [url http://www.ora00600.com/scripts/11g/UTL_SMTP_ORA-06512.html]ORA-24247: network access denied by access control list (ACL) and how to solve it.

    Hope that helps,
    Rob

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points