How to use ORDS deployed in Tomcat/WLS when the type connection is a TNS alias (Doc ID 2709783.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Symptoms

When attempting to access APEX with a mapping URL while using a tns alias as connection
the following error occurs.

ERROR
-----------------------
Could not find any dispatcher to handle request:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Change the connection type form default to use a TNS alias
2. Try http://host:port//ords/<mapping>      -- using the web_server URL

Changes

 Switch from a default jdbc default type connection to use a tns alias

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.