I have created the following systemd file. This works to stop/start/restart/status/reload xymon except for dbcheck.

I see this in the logs and dbcheck fails to connect to any DB instance:

Thu May 31 13:49:19 2018:ERROR: ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach)

I also created a global environment file which didn't help. /home/xymon/server/bin/xymon.sh always works, systemctl restart xymon always fails to have dbcheck.pl to work as expected.

Perhaps I should be using something else to monitor Oracle instances? The script is available here, if you are not aware of dbcheck.pl.

https://sourceforge.net/projects/hobbit-perl-cl/

Anyone using dbcheck.pl with a systemd stop/start file?

[xymon at xymon1 ext]$ cat /etc/profile.d/oracle_env.sh

ORACLE_HOME=/usr/lib/oracle/12.2/client64 TNS_ADMIN=/home/xymon/server/ext/impact/db/etc PATH=$ORACLE_HOME/bin:$PATH

if test "$LD_LIBRARY_PATH" = "" then LD_LIBRARY_PATH=$ORACLE_HOME/lib else LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH fi

export LD_LIBRARY_PATH ORACLE_HOME TNS_ADMIN PATH

[xymon at xymon1 tmp]$ cat /etc/centos-release CentOS Linux release 7.5.1804 (Core)

[xymon at xymon1 tmp]$ cat /etc/systemd/system/xymon.service

[Unit] Description=Xymon Monitoring Service After=network.target

[Service] Type=forking User=xymon ExecStart=/home/xymon/server/bin/xymon.sh start ExecStop=/home/xymon/server/bin/xymon.sh stop ExecReload=/home/xymon/server/bin/xymon.sh reload Restart=on-failure RestartSec=42s

[Install] WantedBy=multi-user.target

David W Gore Global Surveillance Production Support (GSPS) O: +1 919-378-3676 M: +1 919-200-3263 SMS: mailto:9192003263 at vzwpix.com email: gsps at verizon.com