I was missing an easy-to-use tool that would be able to administrate and provide statistics of my ORDS installation. I found out that this was already implemented within SQL Developer. The configuration is quite straightforward to get it up and running.

First of we need to create a ORDS administrator that SQL Developer/ORDS Administration can use.

java -jar ords.war user adminlistener "Listener Administrator"
Enter a password for user adminlistener:
Confirm password for user adminlistener:
Dec 18, 2019 11:00:17 AM oracle.dbtools.standalone.ModifyUser execute
INFO: Created user: adminlistener in file: /home/oracle/ordsinst/ordsconfig/ords/credentials

Now that we have created the admin user, from SQL Developer.

The ORDS Administration windows pops up. Choose create “New Administration”

Save it. Now you can right-click. On Rest Data Services and choose “Connect” to access your administration account.

Sign in with the ORDS admin. Which was set up earlier.

SQL Developer reads the ords configuration . In my case I have 5 different environments. Which all will be picked up as shown below.

Provided that you have configured logging/error tracking you can now see that information directly from the ORDS administration. Now you can push or pull ORDS changes to the server directly from SQL Developer.

When a change is made via SQL Developer a backup is performed on your config files and comments are added to the changed file. Example from the default.xml file in ORDS

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">

   Listener Administration
   Oracle SQL Developer
   Last Update: Wed Dec 18 13:25:48 CET 2019

The only problem that I had was that I didn’t get the statistics back even thou I had it enabled via SQL Developer.

The solution was to add a line in default.xml

 <entry key="debug.debugger">true</entry>

Over & Out