have installed DB 11g XE, Apex and ORDS 20.2 with Tomcat 9 on Windows 7 machine.
through Tomcat Server (port 8090) it is showing error below but it is working properly in standalone mode http://localhost:8090/ords/
Apache Tomcat itself is running, checked with entering in browser url bar http://localhost:8090/
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.
most of the solutions are to unlock apex & ords public users, but it didn't resolved the problem.
when starting it in standalone mode, i saw one message as below:
Picked up JAVA_TOOL_OPTIONS: -Djava.vendor="Sun Microsystems Inc."
i don't know what it means.
note: as mentioned above, it is working fine in standalone mode using: http://localhost:8090/ords/
SQL> select username, expiry_date, lock_date, account_status from dba_users order by 1;
USERNAME EXPIRY_DA LOCK_DATE ACCOUNT_STATUS
------------------------------ --------- --------- --------------------------------
ANONYMOUS OPEN
APEX_040000 29-MAY-14 LOCKED
APEX_200200 11-OCT-22 11-OCT-22 EXPIRED & LOCKED
APEX_INSTANCE_ADMIN_USER OPEN
APEX_LISTENER OPEN
APEX_PUBLIC_USER OPEN
APEX_REST_PUBLIC_USER OPEN
APPQOSSYS 29-MAY-14 29-MAY-14 EXPIRED & LOCKED
CTXSYS 28-SEP-22 28-SEP-22 EXPIRED & LOCKED
DBSNMP 29-MAY-14 29-MAY-14 EXPIRED & LOCKED
DIP 29-MAY-14 29-MAY-14 EXPIRED & LOCKED
FLOWS_FILES 29-MAY-14 LOCKED
HR 28-SEP-22 28-SEP-22 EXPIRED & LOCKED
MDSYS 28-SEP-22 29-MAY-14 EXPIRED & LOCKED
ORACLE_OCM 29-MAY-14 29-MAY-14 EXPIRED & LOCKED
ORDS_METADATA 11-OCT-22 11-OCT-22 EXPIRED & LOCKED
ORDS_PUBLIC_USER OPEN
OUTLN 28-SEP-22 28-SEP-22 EXPIRED & LOCKED
SYS OPEN
SYSTEM OPEN
SYSWATCH OPEN
WEBUTIL OPEN
XDB 29-MAY-14 29-MAY-14 EXPIRED & LOCKED
XS$NULL 29-MAY-14 29-MAY-14 EXPIRED & LOCKED
24 rows selected.
please help.
regards