regenti88
regenti88

Reputation: 83

ORACLE-APEX 18.2 ORACLE XE 11g Keycloak Oauth2 - problem with ACL

currently I am developing an application based on Oracle ApplicationExpress 18.2 connected with (only for dev) Oracle 11g XE. One of requirements is to connect apex app with keycloack as openid provider. I configured my application (i was basing on this tutorial: http://dgielis.blogspot.com/2018/06/facebook-google-and-custom.html ) to connect with keycloak. The problem is: i am able to sign in (in keycloack i see new session and it is active) but apex is showing error page after redirect from keycloak. In debug log from apex i see that error: - ora_sqlerrm:

ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-24247: network access denied by access control list (ACL)

What am i doing wrong? Of cource i added some ACLs by calling oracle procedures but it doesnt work.

Result of the query select * from dba_network_acls; in attachment Query Result:

enter image description here

Really looking forward for any help from You.

Regards,

Cezary

Upvotes: 0

Views: 1397

Answers (0)

Related Questions