Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Ibrahim.

Asked: February 28, 2024 - 8:22 am UTC

Last updated: March 11, 2024 - 1:36 am UTC

Version: Oracle 19c 19.3

Viewed 1000+ times

You Asked

ORDS Landing Page Shows "ok" For Apex And Sql Developer Instead of "GO" button. I can't access to apex workspace page.when i click on the "ok" it toke me to apage shwing "not found http status code :404
Impossible to meet the requirement with a database. Verify that the IURL of the request is correct and that the corresponding URL-database Have been correctly configured"
I am working on windows 10 pro and
I installed the following:
Oracle 19c
Apex 23.2
Ords 23.4
Tomcat 9. 0.86

and Connor said...

That normally means you APEX pool is not set up correctly, and the ORDS logs will show that.

For example, I locked my APEX_PUBLIC_USER account, and clicked "Go" on the APEX button. My ORDS log shows

ServiceUnavailableException [statusCode=503, logLevel=SEVERE, reasons=[ORDS was unable to make a connection to the database. ORDS is not able to proxy to the target user because that user is locked. The connection pool named: |default|lo| had the following error(s): ORA-28000: The account is locked.
]]
        at oracle.dbtools.http.errors.ServletResponseExceptionMapper.mapError(ServletResponseExceptionMapper.java:55)
        at oracle.dbtools.http.errors.ErrorLogger.log(ErrorLogger.java:27)
        at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:114)
        at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
        at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
        at oracle.dbtools.http.secure.ForceHttpsFilter.doFilter(ForceHttpsFilter.java:74)
        at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
        at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
        at oracle.dbtools.http.auth.ForceAuthFilter.doFilter(ForceAuthFilter.java:44)
        at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
        at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
        at oracle.dbtools.http.filters.Filters.filter(Filters.java:67)
        at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:70)
        at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:130)
        at oracle.dbtools.entrypoint.WebApplicationRequestEntryPoint.service(WebApplicationRequestEntryPoint.java:50)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)


So check your ORDS logs - they should give you the answers.