Cannot get a trigger working that sends data to our CRM system due to an ACL error. The following message is displayed Request_Failed: ORA-24247: network access denied by access control list (ACL).
ORA-24247: network access denied by access control list (ACL)
Indicates that this is a common issue after an upgrade to 11g database.
Oracle allows access to external network services using several PL/SQL APIs (UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP and UTL_INADDR), all of which are implemented using the TCP protocol. In previous versions of the database, access to external services was effectively an on/off switch based on whether a user was granted execute permissions on a specific package or not. Oracle 11g introduces fine grained access to network services using access control lists (ACL) in the XML DB repository, allowing control over which users access which network resources, regardless of package grants.
Check users granted following FTP_USER and EMAIL_USER roles
Contact Bentley TSG if need more information re: ACL information
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!