Using ACEs to Set Up ACLs on 12c (To Remedy ORA-24247 Errors) (Doc ID 2267848.1)

Last updated on MAY 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

After upgrading from Oracle Database 10g to 11g, or 12c, one may encounter the following:

We know from <Note 1209644.1> that it is required to create Access Control Lists, or ACLs, to enable the use of packages that communicate across the network, such as UTL_HTTP or UTL_SMTP, among others.  

In Oracle Database 12c, instead of directly configuring an ACL, you will set up an Access Control Entry (ACE).  The ACL will automatically be created.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms