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"> <properties> <comment> Listener Administration Oracle SQL Developer 220.127.116.11.2212 Last Update: Wed Dec 18 13:25:48 CET 2019 </comment>
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
Over & Out