I'm able to access to APEX via ORDS after I've added one extra database. Now trying to add 3rd one: the only difference is that I have a fresh latest APEX version 5.1.1 on this database, no WORKSPACES yet.
I've configured the pool successfully, I DID RUN @apex_rest_config.sql successfully on this 3rd database and I can even see sessions under ORDS_PUBLIC_USER and APEX_LISTENER on this database connected from ORDS server.
Below is my url-mapping.xml
<?xml version="1.0" encoding="UTF-8"?>
<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
<pool name="db1" base-url=http://apexrep/apex/db1 workspace-id="INTERNAL" updated="2017-05-08T15:28:29.648Z"/>
<pool name="db1" base-url=http://apexrep:8080/apex/db1 workspace-id="WATER" updated="2017-05-08T15:35:28.876Z"/>
<pool name="votr" base-url="http://apexrep:8080/apex/votr/" workspace-id="INTERNAL" updated="2017-05-10T12:45:19.628Z"/>
</pool-config>
So http://apexrep:8080/apex/db1 works just fine.
However http://apexrep:8080/apex/votr does NOT work. Could it be related to the empty fresh APEX install ? But I can access to http://apexrep:8080/apex/db1/apex_admin Admin page despite providing a different workspace name above.
I did redeployed apex.war into /webapps for Apache Tomcat after I've made the change, the pool for votr is configured properly as I've mentioned I even can see sessions under APEX_LISTENER from this database.
I do use the latest 3.0.9 ORDS version, I've just downloaded: 3.0.9.348.07.16
I've read there was a bug with URL mapping before.
I did tried to enable debug on the screen but looks like I'm getting the same error for votr just like for any other URL's like http://apexrep:8080/apex/bububub/
404 Not Found
- requestThe request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured
Debug Trace
[TE] url-mapping start: 2017-05-10T13:57:05.972Z duration: 5ms [TE] GET /apex/votr/ start: 2017-05-10T13:57:05.972Z duration: 5ms
Stack Trace
URLMappingNotFoundException [statusCode=404, reasons=[The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured]] at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:119) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:83) 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:94) 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:47) at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:82) at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:49) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at oracle.dbtools.rt.web.HttpEndpointBase.dispatchableServices(HttpEndpointBase.java:116) at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:81) 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:169) 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:436) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078) 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(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Alex