Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not being able to start ORDS as part of Tomcat Service on Oracle Linux

myluismDec 11 2023

Hi All.

I´m hoping to get some help even if maybe this may not be the most appropiate forum.

I have an OL box: Oracle Linux Server release 7.7. On this box an Oracle Database: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production.

I have also successfully deployed Apex / ORDS and Tomcat: Apex 21.2.0, ORDS 20.4.3, Tomcat 9.

Currently Tomcat service start successfully:

Redirecting to /bin/systemctl status tomcat.service
● tomcat.service - Apache Tomcat service
Loaded: loaded (/usr/lib/systemd/system/tomcat.service; enabled; vendor preset: disabled)
Active: active (running) since sáb 2023-12-09 18:20:22 -03; 1 day 14h ago
Process: 2249 ExecStart=/bin/bash /u02/tomcat/latest/bin/startup.sh (code=exited, status=0/SUCCESS)
Main PID: 2309 (java)
Tasks: 73
CGroup: /system.slice/tomcat.service
└─2309 /u02/java/latest/bin/java -Djava.util.logging.config.file=/u02/config/instance1/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManage...

dic 09 18:20:22 srv-calderon-02 systemd[1]: Starting Apache Tomcat service...
dic 09 18:20:22 srv-calderon-02 systemd[1]: Started Apache Tomcat service.
[root@srv-calderon-02 ~]#

Database service also starts successfully.

Only issue I have is ORDS is not starting or failing to start on boot. One have to enter Tomcat and restart ORDS and then ORDS is finally available to users.

This is my actual tomcat.service:

[root@srv-calderon-02 system]# cat tomcat.service
[Unit]

Description=Apache Tomcat service

After=dbora.service syslog.target network.target nfs.service nfs-mountd.service local-fs.target rpc-statd.service remote-fs.target

[Service]

Type=forking

RemainAfterExit=yes

User=tomcat

Group=tomcat

Environment=JAVA_HOME=/u02/java/latest
Environment=CATALINA_HOME=/u02/tomcat/latest
Environment=CATALINA_BASE=/u02/config/instance1

SyslogIdentifier=tomcat
Restart=always
RestartSec=30
TimeoutStartSec=30
TimeoutStopSec=30

ExecStart=/bin/bash /u02/tomcat/latest/bin/startup.sh

ExecStop=/bin/bash /u02/tomcat/latest/bin/shutdown.sh

StandardOutput=syslog

[Install]

WantedBy=multi-user.target

[root@srv-calderon-02 system]#

I have set Tomcat to start after dbora.service. I have tried several options, like doing a sleep as a ExecPrestart:

TimeoutStartSec=infinity
ExecStartPre=/bin/sleep 120

But none of this have worked so far.

So in short I don't know why ORDS is failing to start on boot and why it has to be started manually.

Could anyone please provide some feedback to fix or troubleshoot this issue?

Thanks so much in advance !!!

Comments
Post Details
Added on Dec 11 2023
14 comments
1,331 views