ORDS 18.4 deployed to Tomcat as apex2.war. Configdir set to d:\apex with defaults.xml and conf\ folder containing apex.xml, apex_rt.xml, apex_pu.xml and apex_al.xml with corresponding usernames and passwords. java -jar apex2.war validate & schema commands works fine, no errors
http://server:8080/apex2 brings up APEX login screen so this means APEX is setup correctly.
Ran ORDS.ENABLE_SCHEMA for schema TESTAPEX
url-mapping.xml added to configdir with all variations like this
<?xml version="1.0" encoding="UTF-8"?>
<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
<pool name="apex2" base-path="/apex2" />
<pool name="apex2" base-path="/apex2" schema-name="testapex" />
<pool name="apex" base-path="/apex" />
<pool name="apex" base-path="/apex" schema-name="testapex" />
</pool-config>
But no matter what I do, ORDS throws a 404 or 503 with Could not find dispatcher to handle request for http://server:8080/apex2/testapex/metadata-catalog
Also, what is the recommended configuration when working with multiple databases, use the same ORDS instance (i.e. WAR file) to connect to all of them using the folder structure shown here or use multiple WAR files all pointing to the same configdir but with sub-folders corresponding to each WAR e.g. d:\apex\apex => apex.war, d:\apex\apex2 => apex2.war and so on. I am doing the latter, is that the issue?
What am I missing? Thanks