4 thoughts on “OKTA authentication for APEX in 5 minutes

  1. hi I am getting an error after adding the certificate to the ssl cert… i logged into okta via the social and got error processing request … i checked the error log and saw that

    – ora_sqlerrm: ORA-29273: HTTP request failed
    ORA-06512: at “APEX_200200.WWV_FLOW_WEB_SERVICES”, line 1157
    ORA-06512: at “APEX_200200.WWV_FLOW_WEB_SERVICES”, line 757
    ORA-24247: network access denied by access control list (ACL)
    ORA-06512: at “SYS.UTL_HTTP”, line 380
    ORA-06512: at “SYS.UTL_HTTP”, line 1148
    ORA-06512: at “APEX_200200.WWV_FLOW_WEB_SERVICES”, line 735
    ORA-06512: at “APEX_200200.WWV_FLOW_WEB_SERVICES”, line 998
    ORA-06512: at “APEX_200200.WWV_FLOW_WEB_SERVICES”, line 1346
    ORA-06512: at “APEX_200200.WWV_FLOW_WEBSERVICES_API”, line 608
    ORA-06512: at “APEX_200200.WWV_FLOW_AUTHENTICATION_SOCIAL”, line 85
    ORA-06512: at “APEX_200200.WWV_FLOW_AUTHENTICATION_SOCIAL”, line 459
    ORA-06512: at “APEX_200200.WWV_FLOW_AUTHENTICATION_SOCIAL”, line 651
    ORA-06512: at “APEX_200200.WWV_FLOW_AUTHENTICATION_NATIVE”, line 422
    ORA-06512: at “APEX_200200.WWV_FLOW_AUTHENTICATION_NATIVE”, line 1259
    ORA-06512: at “APEX_200200.WWV_FLOW_PLUGIN”, line 3213
    ORA-06512: at “APEX_200200.WWV_FLOW_PLUGIN”, line 3810

    can u help me fix this


  2. Hi Jay,

    Did you try the part with the ACL setup (https://pretius.com/configuration-of-oracle-database-and-apex-application-use-of-google-service-account-the-google-workspace-friendly-application-series/) ?

    You could also try to modify your ACL with any of the two methods described in the following articles (depending on your database version):
    … or

    You probably already know, but for those settings you will need some admin privileges, so you might need to reach out to your DBA if you are in a corporate environment.


  3. In APEX 19.2, Oracle has restricted the number of calls made to web service to default 1000 on a 24 hour rolling count. If this is exceeded then APEX can’t reach out to Okta web service.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s