My Oracle Support Banner

404 When Accessing /ords/sql-developer Whereas /_sdw Works Fine (Doc ID 2668789.1)

Last updated on MARCH 13, 2024

Applies to:

Oracle SQL Developer Web - Version 19.4 and later
Oracle REST Data Services - Version 19.4 and later
Information in this document applies to any platform.

Goal

NOTE: The example(s) provided are for demonstration purposes only and represents fictitious data. Any similarity to actual data, web sites and / or persons, living or dead, is purely coincidental and not intended in any manner.

 

While accessing SQL Developer Web (SDW) using ORDS:  

http://machine:port/ords/demo/_/sdw --works perfectly

http://machine:port/ords/sql-developer  --doesn't work

When it is executed and after login, the following error is seen:

Error Message :->  
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
Debug Trace : -
[TE] GET /ords/edw_dim/sign-in?username=EDW_DIM&r=_sdw%2F start: 2020-05-05T10:48:23.082Z duration: 13ms
Please find below the Stack Trace output.
** Begin Stack Trace **
==============================================================================
URLMappingNotFoundException [statusCode=404, reasons=[The request could not be mapped to any database.

Settings done :
==============
BEGIN
ords_admin.enable_schema(
p_enabled => TRUE,
p_schema => 'DEMO',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'DEMO',
p_auto_rest_auth => NULL
);
commit;
END;

alter user DEMO grant connect through ords_public_user;


How do you resolve this error? 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


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