Hello dears.
I am using for more than one year Oracle Apex 5.x with Oracle 11g and Apache Tomcat 7.0.
Since yesterday all has worked very well but this morning, if I try to connect to Oracle Apex, is being showed the message "Oracle REST Data Services - 404 Not found".
Then I enabled the tracing in ORDS by addind the following two rows in the file default.xml
<entry key="debug.debugger">true</entry>
<entry key="debug.printDebugToScreen">true</entry>
After restarning if I connect to APEX is being showed this:
Debug Trace
mapped request using: /* to: PLSQL:apex
Could not find any dispatcher to handle request:
--Attributes--
nanoStart = 1481013800241
apex.diagnostic.context = Attempting to process as a Dispatchable Service
ECID-Principal = ECIDPrincipal [ecid=1kmnaQIjAuZBvDVgoPyOoA..]
oracle.dbtools.http.ecid = U38PBxNhRzJmxG15MV65OQ..
oracle.dbtools.common.di.Services = Request Scope
--Attributes--
GET /ords/f?p=101:LOGIN_DESKTOP:::::: HTTP/1.1
Host: apex-prod
host: apex-prod:8080
connection: keep-alive
cache-control: max-age=0
upgrade-insecure-requests: 1
user-agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.99 Safari/537.36
accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
accept-encoding: gzip, deflate, sdch
accept-language: it-IT,it;q=0.8,en-US;q=0.6,en;q=0.4,pt;q=0.2
cookie: ORA_WWV_REMEMBER_UN=SAVERIO.MOLA:ws-segnalazioni; ORA_WWV_USER_103889354093289=ORA_WWV-EOC3FUYoeAgnxVngRn2nzydc; LOGIN_USERNAME_COOKIE=saverio.mola; ORA_WWV_APP_101=ORA_WWV-MzoB0yh1RqaFp7g_IVDWOCA-
org.apache.catalina.connector.CoyoteInputStream@6d07a441
Stack Trace
NotFoundException [statusCode=404, reasons=[]]
at oracle.dbtools.http.entrypoint.Dispatcher.choose(Dispatcher.java:82)
at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:92)
at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:123)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:73)
at oracle.dbtools.http.forwarding.QueryFilteringRewrite.doFilter(QueryFilteringRewrite.java:82)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.forwarding.ForwardingFilter.doFilter(ForwardingFilter.java:59)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.cors.CORSPreflightFilter.doFilter(CORSPreflightFilter.java:67)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.cookies.auth.CookieSessionCSRFFilter.doFilter(CookieSessionCSRFFilter.java:61)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.auth.AuthenticationFilter.authenticate(AuthenticationFilter.java:89)
at oracle.dbtools.http.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:62)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.url.mapping.db.PLSQLMapper.doFilter(PLSQLMapper.java:37)
at oracle.dbtools.url.mapping.URLMapping.doFilter(URLMapping.java:78)
at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:63)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.locale.LocaleFilter.doFilter(LocaleFilter.java:60)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:71)
at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:75)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.ecid.ECIDFilter.doFilter(ECIDFilter.java:35)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)
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:45)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.filters.Filters.filter(Filters.java:47)
at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:80)
at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:46)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at oracle.dbtools.rt.web.HttpEndpointBase.dispatchableServices(HttpEndpointBase.java:166)
at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Then in the instance of the database I wrote the following instruction:
select username, account_status, lock_date, expiry_date from dba_users where username like '%APEX%';
with the following result
USERNAME ACCOUNT_STATUS LOCK_DATE EXPIRY_DA
------------------------------ -------------------------------- --------- ---------
APEX_050000 EXPIRED & LOCKED 17-LUG-15 17-LUG-15
APEX_030200 EXPIRED & LOCKED 17-LUG-15 17-LUG-15
APEX_LISTENER EXPIRED 29-MAG-16
APEX_PUBLIC_USER EXPIRED 04-DIC-16
APEX_REST_PUBLIC_USER EXPIRED 06-GIU-16
Any suggestion will be appreciated. Thank you