Database Administration (MOSC)

MOSC Banner

Port Range Limitation in 19c when assigning ACL via dbms_network_acl_admin.assign_acl

edited Sep 9, 2020 6:04AM in Database Administration (MOSC) 4 commentsAnswered

Hi All,


We're doing some upograde testing in Oracle 19.3 on RHel7. We're going to it straight from 11.2.4 and we're hitting an issue when creating acceess control lists, ACL. Previously, we would assgn a particular rule with a range of lower => 80  and higher => 65535. In 11.2.4 this all works without issue.

However it doesn't appear to work in 19.3, the spread between lower and upper is much smaller but I can't find any mention of a limitation in the documentation: https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_NETWORK_ACL_ADMIN.html

An example of a smaller spread in 19.3:

SQL> exec DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('DUMMY.xml', 'Allow  network access', 'USERA', TRUE, 'connect');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center