[systemd-devel] starting Oracle with systemd

[Fisher, Charles J. (Top Echelon)]

-----Original Message-----
From: Andrei Borzenkov [mailto:arvidjaar at gmail.com] 


> I know. So define service that starts listener, use "lsnrctl start" as
> ExecStart, "lsnrctl stop" as ExecStop and set KillMode=process (or
> "none"). What exactly does not work in this case?

Reading this, "none" is the right choice, so the child connections don't die.

For some reason, the iptables didn't happen. Maybe it needs to be fully qualified.



[root at localhost system]# cat oracle-listener.service
[Unit]
Description=oracle listener
After=syslog.target

[Service]
Environment='ORACLE_HOME=/home/oracle/Ora12c/db'
ExecStart=/home/oracle/Ora12c/db/bin/lsnrctl start
ExecStop=/home/oracle/Ora12c/db/bin/lsnrctl stop
KillMode=none
ExecStartPost=iptables -I INPUT -p tcp --dport 1521 --syn -j ACCEPT
Type=forking
User=oracle
Group=dba

[Install]
WantedBy=multi-user.target

#This file should be placed in /etc/systemd/system
#enable for start at boot by: systemctl enable oracle-listener.service