I am struggling to get Social Sign-In working (completely) with Google. I've done all the setup, can run my test application, which then goes to Google for an account and then returns to APEX. When it returns to APEX, I get "ORA-24247: network access denied by access control list (ACL)". I believe I have the ACLs setup correctly because I can run the following from SQL and get a result:
SELECT UTL_HTTP.REQUEST('https://accounts.google.com', wallet_path=>'file:/u01/oracle/https_wallet') FROM dual;
If I look at the session debug it oddly shows the following under Errors:
Error: ORA-24247: network access denied by access control list (ACL) (user=)
User: nobody
The null user has me perplexed.
I am on APEX 23.1.0, 21c database using ORDS under Tomcat. I keep thinking that it might be something with Tomcat running on 8443 and using the Linux firewall to redirect all 443 traffic to 8443 but not sure.
Any insight or help would be great.