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

    Like

  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):
    https://tedstruik-oracle.nl/ords/f?p=25384:1058::::::
    … or
    https://oracle-base.com/articles/12c/fine-grained-access-to-network-services-enhancements-12cr1

    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.

    Like

  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.

    Like

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 )

Google photo

You are commenting using your Google 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