I am trying to set up a small Rest API and connect to it from an OCI Autonomous DB. But I am stuck.

This request works:

SELECT apex_web_service.make_rest_request(
p_url => 'https://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson'||CHR(38)||'limit=100',
p_http_method => 'GET') JSON
FROM DUAL;

This is a call to an existing public Rest-API (not mine).

This does not work:

SELECT apex_web_service.make_rest_request(
p_url => 'https://raspi.brima.dynv6.net:1880/gettest',
p_http_method => 'GET') JSON
FROM DUAL;

This is my own API. It’s only a “Hello World!” example.
For this call, I get:

ORA-29273: HTTP request failed
ORA-06512: at "APEX_210200.WWV_FLOW_WEB_SERVICES", line 1182
ORA-06512: at "APEX_210200.WWV_FLOW_WEB_SERVICES", line 782
ORA-01031: insufficient privileges
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1209

The same happens when I try to do the request via UTL_HTTP.

I setup an ACE for Host ‘*.brima.dynv6.net’ for my currecnt DB user with privilege CONNECT, but that did not change anything.
Also, why is the first example working without a special ACL configuration?

I don’t understand the problem.
I already looked at this question, but it wasn’t really answered.

Can anyone point me in the right direction?

Thanks & Regards,
Nadine