My Oracle Support Banner

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

Last updated on JULY 17, 2020

Applies to:

Portal - Version 10.1.4.2 to 11.1.1.6.0 [Release 10gR2 to FMW11g]
Information in this document applies to any platform.

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:


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.

Note:
Above mentioned PL/SQL network utility packages (UTL_*) are a part of the Oracle Server. As such, the network access error (ORA-24247) may be encountered while configuring OracleAS Portal 10g or Oracle Portal 11g in a Oracle 11g database.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
References

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