Database Administration (MOSC)

MOSC Banner

How to configure Network ACL/ACE at Autonomous Transaction Processing Always Free

edited Dec 15, 2019 10:38PM in Database Administration (MOSC) 2 commentsAnswered

Hello,

I'm migrating now to Autonomous Transaction Processing Database from OCI-C Database.

My Database Application uses UTL_HTTP Package in PL/SQL Procedures/Functions .

Network ACE/ACL configuration is needed to kick UTL_HTTP Get/Post.

I invoked DBMS_NETWORK_ACL_ADMIN as admin user.

I faced Error PLS-00201.

It's seems admin user don't have enough permissions.

I can't connect as SYSDBA to Autonomous Transaction Processing Database.

How to configure Network ACL/ACE to use UTL_HTTP ?

---------------------------

BEGIN

DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(

  host       => '*.xxxxx.com',

  lower_port => '443',

  upper_port => '443',

  ace        =>  xs$ace_type(privilege_list => xs$name_list('http','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