Oracle ORDS - How to bypass 404 error on Standalone

Question

I have been trying to establish a connection to use ORDS and was successful once, but now I am receiving a 404 error when I try to connect to my database on ORDS.

When I first log onto http://127.0.0.1:1521/ords/sql-developer, I receive the following messages:

The service is disabled in this environment Stack Trace DisabledException [statusCode=404, reasons=[The service is disabled in this environment]]

---

This is what I've tried:

java -Doracle.net.tns_admin=C:\Users\ip4169\Desktop\ORDS\ords -jar ords.war validate

-> Completed validating Oracle REST Data Services version 19.4.0.r3521226. Elapsed time: 00:00:15.700[CHECK]

java -Doracle.net.tns_admin=C:\Users\ip4169\Desktop\ORDS\ords -jar ords.war standalone enter image description here-> oejs.Server:main: Started @8299ms [CHECK]

---

I've checked my TNSORA.net files and see my database information is included inside.

Here is the ORDS error page: If someone could please assist me through this I would be very grateful!

Answer 1

The 404 was happening at login time while trying to access SQL Developer Web for a user.

Two things to check:

• the database connection pool is correctly configured

• the schema is rest enabled

In this case the pool wasn't being established at startup because the ORDS_PUBLIC_USER password wasn't correct - ORDS couldn't create database connections.

Once the database user password was reset to what was defined in the pool config XML file, an ords restart showed the pool being established. Check the stdout when starting ords for errors!

If on the other hand you're getting errors trying to access the App in general at the /ords/sql-developer url, then -

You need to ensure SQL Developer Web is enabled.

Add these lines to your defaults.xml file and restart ords

<entry key="feature.sdw">true</entry>
<entry key="restEnabledSql.active">true</entry>