ords database not mapped an database

tomcat oracle-apex oracle-ords
deys picture deys · May 24, 2016 · Viewed 19.4k times · Source

I'm trying to configure Oracle Apex 5 and ORDS to work with Tomcat. I managed to complete all steps as per the Oracle docs instruction, however when I try to access ORDS using http://localhost:8080/ords/ it gives me the error:

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

Please support, standalone is working.

Oracle: 11g
OS: Linux
Tomcat: 7 (running)

Answer

jingwenxxx picture jingwenxxx · Oct 9, 2018

I solved my problem by performing the following steps when I found that the ORDS suddenly stops working and encounter 404 error on the login page. Hope it might help!

When you have 404, it could happen to be that there's a problem with the user password expiration.

  1. Check if you have any user that’s expired/lock:

    SELECT username, account_status, created, lock_date, expiry_date FROM dba_users WHERE account_status != 'OPEN';

  2. Then perform a bunch of “alter user xxx identified as xxxx account unlock”.

  3. After you have open every necessary user account, perform the following in your console as administrator:

    Java -jar ords.war setup

    Net stop tomcat8

    Net start tomcat8

Related questions

Oracle Apex or ORDS not recognizing images folder

I've installed Oracle Apex 5 and configured ORDS through Tomcat however I'm getting the error as below: There is a problem with your environment because the Application Express files have not been loaded. Please verify that you have copied the images …

Read More
How to deploy a war file in Tomcat 7

I have copied the sample.war file into the webapps directory of Tomcat, and I can access localhost:8080. Now how will Tomcat deploy it, I mean do I need to open it in browser? How can I access the application?

Read More
Several ports (8005, 8080, 8009) required by Tomcat Server at localhost are already in use

I'm getting the following error when I try to run a simple JSP program on Tomcat in Eclipse. Several ports (8005, 8080, 8009) required by Tomcat v6.0 Server at localhost are already in use. The server may already be running in another process, …

Read More