Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

network access denied by access control list (ACL)

3857119Feb 19 2019

I Have the following:

EXEC UTL_HTTP.SET_WALLET('file:/opt/oracle/admin/XE/https_wallet/', '<PASWORD>');

SELECT UTL_HTTP.REQUEST('https://cloud.iexapis.com/beta/stock/market/batch?symbols=AA,AAPL,F&types=quote&token=<TOKEN >') FROM DUAL;

Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

I get the following:

pastedImage_0.png

I set up the following:

BEGIN

DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(

host => 'cloud.iexapis.com',

ace => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),

                   principal\_name => 'investementclub',

                   principal\_type => xs\_acl.ptype\_db));

COMMIT;

END;

/

SELECT HOST, LOWER_PORT, UPPER_PORT,

   ACE\_ORDER, PRINCIPAL, PRINCIPAL\_TYPE,

   GRANT\_TYPE, INVERTED\_PRINCIPAL, PRIVILEGE,

   START\_DATE, END\_DATE

FROM (SELECT ACES.*,

DBMS_NETWORK_ACL_UTILITY.CONTAINS_HOST('cloud.iexapis.com',

                                                  HOST) PRECEDENCE

      FROM DBA\_HOST\_ACES ACES)

WHERE PRECEDENCE IS NOT NULL

ORDER BY PRECEDENCE DESC,

      LOWER\_PORT NULLS LAST,

      UPPER\_PORT NULLS LAST,

      ACE\_ORDER;

:pastedImage_1.png

select * from dba_host_acls;

pastedImage_2.png

Comments
Post Details
Added on Feb 19 2019
0 comments
507 views