6 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.


  4. Hi,
    I set up OKTA Integration.
    It’s working fine.

    Steps: When I login it’s login to apex but if we sign out from apex it’s again back to okta login screen, it’s fine but when we login again then it’s redirect to “Your session has ended” screen.


  5. Hi Plamen,

    App is showing “Your session has expired” message with “LOGIN AGAIN” and “CANCEL” button after it exceed the value given in “Maximum Session Idle Time in Seconds” attribute.

    Can we change the redirect location in “LOGIN AGAIN” button? currently it is redirecting to
    1) OKTA login page if OKTA is logged out
    2) Home page of application if OKTA is already logged in some other tab. In this case, I want to logout from my app and redirect to some XYZ URL.

    How can we achieve this ?

    Thanks in advance


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 )

Facebook photo

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

Connecting to %s