I have a completely NEW installation of Apex 24.2 on my PC (running with ORDS).
I have created a workspace with owner: BAU
I have configured ACLs for all hosts (*) for users: BAU, APEX_240200, APEX_PUBLIC_USER
I am trying to create an REST Data Source from a popular URL: http://jsonplaceholder.typicode.com/posts/1
However, I keep getting ORA-24247: network access denied by access control list (ACL) error on the screen while trying to add the data source.
Strangely enough, when I try it out from SQL Workshop via custom PL/SQL script - this works fine!
ACL PRINCIPAL PRIVILEGE
------------------------------ -------------------- --------------------
/sys/acls/bau_acl.xml BAU resolve
/sys/acls/bau_acl.xml APEX_240200 resolve
/sys/acls/bau_acl.xml APEX_PUBLIC_USER resolve
/sys/acls/bau_acl.xml BAU connect
/sys/acls/bau_acl.xml APEX_240200 connect
/sys/acls/bau_acl.xml APEX_PUBLIC_USER connect
HOST LOWER_PORT UPPER_PORT ACL
------------------------------ ---------- ---------- ------------------------------
* /sys/acls/bau_acl.xml
This is extremely frustrating as I was able to get similar setup to work on a different machine at work!
What else can check or verify where the issue is?