Resolving ORA-24247 Errors in Oracle Portal Configured in Oracle Server 11g (Doc ID 1316035.1)

Last updated on APRIL 07, 2025

Applies to:

Purpose

Oracle Server 11g offers fine-grained access control for database users that need access to the network beyond the realm of the database. Prior to the usage of any of the packages below, it is required that an ACL for the application/schema user is in place:

UTL_TCP
UTL_SMTP
UTL_MAIL
UTL_HTTP
UTL_INADDR

Lack of proper ACLs can result in an error similar to the one below or with slight variations depending on the context:

ORA-24247: network access denied by access control list (ACL)

Scope

Oracle Portal makes use of some of the packages mentioned above. As such, the schema in which the Portal repository resides (eg. <PREFIX>_PORTAL) requires that ACLs be appropriately set to allow network access.

Additionally, in lieu of appropriate ACLs, you may encounter errors during any of the following tasks:

• Configuration of Oracle Portal.
• Upgrade of Oracle Portal.
• Consumption of remote Producers/Providers in Oracle Portal.
• Enterprise deployment.

Lack of proper ACLs usually results in an error similar to the one below or with slight variations depending on the context:

ORA-24247: network access denied by access control list (ACL)

Above error may also be encountered if ACL(s) pre-exist and newly created ACLs have lower precedence. For example, an ACL assigned to a host computer, a domain, or an IP subnet with a port range takes precedence over one without an explicitly defined port range.

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.