We have a functioning Apache Tomcat 9 server hosting ORDS and two APEX connection pools:
When we start Tomcat at the commandline, ORDS.war initializes, reads the ORDS configuration, and initializes the two pools as follows:
18-Sep-2024 10:37:22.710 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
2024-09-18T15:37:31.715Z INFO Configuration properties for: |default|lo|
…
2024-09-18T15:37:32.724Z INFO Configuration properties for: |x09|lo|
…
However, when I followed the Tomcat instructions of using Tomcat\bin\service.bat to configure startup as a Windows Service, everything broke when I started the service. Neither Tomcat nor ORDS would load.
I managed to use Tomcat\bin\Tomcat9w.exe GUI tool to modify the Windows service configuration to actually start Tomcat and ORDS, but now it does not pick up our ORDS configuration, and therefore does not start the connection pools and APEX:
INFO: Deploying web application archive [D:\Tomcat\webapps\ords.war]
Sep 17, 2024 6:19:31 PM org.apache.jasper.servlet.TldScanner scanJars
INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
<<< ORDS connection pools should be displayed here but are not when launched as windows service >>
2024-09-17T23:19:36.324Z INFO Oracle REST Data Services initialized
Oracle REST Data Services version : 23.2.3.r2421937
Oracle REST Data Services server info: Apache Tomcat/9.0.90
Oracle REST Data Services java info: OpenJDK 64-Bit Server VM 11.0.24+8-LTS
I granted the Local Service account full control on the ORDS config directory, and I'm specifying the ORDS config directory path in the service setup as follows:
But it still does not read the ORDS connection pool information.
Anyone know what the problem is? Thanks!