I am getting the ORDS 404 Not Found - 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.
Windows 10
APEX 21.2
ORDS 21.4
Apache Tomcat 8.5 - gives the error.
when I run in standalone mode - all works fine.
I have checked the related database accounts, all are open and unlocked and not expired.
I have totally uninstalled and reinstalled ORDS, wiping out all configuration leftovers.
I have tried using TNS and Basic authentication during the ORDs config cycle. I can connect to all the accounts fine. And, all runs fine standalone.
What else can I look for an check? I am running out of ORDS 404 Not found entries to check.
Suggestions?
ORDS defaults.xml :
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Tue Feb 15 10:42:25 EST 2022</comment>
<entry key="database.api.enabled">true</entry>
<entry key="db.connectionType">tns</entry>
<entry key="db.tnsAliasName">TONGGOL</entry>
<entry key="db.tnsDirectory">C:\Oracle\WINDOWS.X64_193000_db_home\network\admin\</entry>
<entry key="feature.sdw">true</entry>
<entry key="instance.api.enabled">true</entry>
<entry key="restEnabledSql.active">true</entry>
<entry key="security.requestValidationFunction">wwv_flow_epg_include_modules.authorize</entry>
<entry key="security.validationFunctionType">plsql</entry>
<entry key="debug.debugger">true</entry>
<entry key="debug.printDebugToScreen">true</entry>
</properties>
Nothing odd there, or in the apex.xml:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Tue Feb 15 11:35:09 EST 2022</comment>
<entry key="db.password">@05746FF863A56A51F2C7576F1A9F7FF6D2B78D31DC9A5CEC49</entry>
<entry key="db.tnsAliasName">tonggol</entry>
<entry key="db.tnsDirectory">C:\Oracle\WINDOWS.X64_193000_db_home\network\admin\</entry>
<entry key="db.username">APEX_PUBLIC_USER</entry>
</properties>
Any suggestions on what to look at, for or check are welcome.
Thank you!
Karen