After installing „Oracle 23ai free“ with APEX, ORDS and Tomcat on a Linux machine I have the problem, that I can’t connect to APEX as ORDS can’t connect to the database after a restart of the computer. It always says:
„Database Connection Error HTTP Status Code: 571 […] ORA-12541: […] No Listener on host localhost at port 1521. […]“
After restarting Tomcat with „sudo systemctl restart tomcat.service” everything is fine and I can connect to APEX in a browser, so the general configuration seems to be OK.
My Linux knowledge is not very comprehensive, and I’m still learning. I tried some hints, that I found on the internet, to make the tomcat service wait for the listener like adding
ExecStartPost=/usr/bin/timeout 30 sh -c 'while ! ss -H -t -l -n sport = :1521 | grep -q "^LISTEN.*:1521"; do sleep 1; done'
in the file /etc/systemd/system/tomcat.service, but without success.
The versions are completely up-to-date:
- Alma Linux 9.5
- Oracle 23ai free 23.7
- Tomcat 9.0.100
- ORDS 24.4.0.345
- APEX 24.2.2
Does anyone have a clue as to what is causing my problem?