I'm using Apex 23.2 on a 21.c database on a Windows 11 platform. Several releases ago I developed a custom Windows Service to start ORDS. I get an error when I install ORDS 23.4. I am able to get through the configuration dialog as I did with prior releases of ORDS. The ORDS 23.4 install seems to complete OK, but when I start the ORDS service I receive the error: Windows could not start the Oracle_ORDS service on Local Computer. The service did not return an error. This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator.
By the way, in the Windows command prompt I start the install dialog with the command ords --config C:\app\product\ords\config install
The install creates the following C:\app\product\ords\config\global\settings.xml. But this generated file contains multiple errors.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Sat Apr 06 18:41:51 UTC 2024</comment>
<entry key="database.api.enabled">true</entry>
<entry key="standalone.context.path">/ords</entry>
<entry key="standalone.doc.root">C:\app\product\ords\config\global\doc_root</entry>
<entry key="standalone.https.cert">/C:/Certbot/live/my.host.com/fullchain.pem</entry>
<entry key="standalone.https.cert.key">/C:/Certbot/live/my.host.com/privkey.pem</entry>
<entry key="standalone.https.port">9090</entry>
<entry key="standalone.static.context.path">/i</entry>
<entry key="standalone.static.path">/C:/app/product/apex/images/</entry>
</properties>
- Note the slash (/) in front of the C: Each one of those three creates a problem. Once those slashes (/) before the C: are removed and the ORDS service is restarted, ORDS 23.4 works fine.
Another problem is that the ORDS 23.4 installation dialogue contains the text:
- Enter the path for the SSL Certificate:
- Enter the path for the SSL Certificates private key:
The problem is with the word “path”. It really should request the user for the full file name. Otherwise, if the user inputs only the path, that will generate another problem starting ORDS. In that case the settings.xml file will have to be edited to include the Certificate and Private Key filenames before ORDS will start properly.
- Also, this generated settings.xml file contains a non-existent path for the key “standalone.doc.root”.
That particular key is the only one using backslashes (\) and not slashes (/) like the other entry keys. The path C:\app\product\ords\config\global\doc_root isn't created with the install. Question: Should the path really be C:/app/product/ords/docs ? That path is generated through the ORDS install.
- Could the ORDS zip file be adjusted to contain the empty folder C:/app/product/ords/config ?
The user has to know in advance to add the folder “config” before running the install program.
Thanks for looking at this.