[systemd-devel] starting Oracle with systemd

[Fisher, Charles J. (Top Echelon)]

-----Original Message-----


>> How about:
 
>> http://www.freedesktop.org/software/systemd/man/systemd.kill.html
 
>> Would setting KillMode=process for the listener service have the required
>> effect: on service stop, only kill the main process, leaving the child
>> processes and cgroup running?

>Yes, that probably will work around this problem. 

No, that's not how it works.

The listener is forked from the "listener control" utility, so a child process then spawns all database client children for all instances.

This is the procedure (at the risk of infuriating those with heightened sensitivities):




-bash-4.2$ export ORACLE_HOME=/home/oracle/Ora12c/db

-bash-4.2$ $ORACLE_HOME/bin/lsnrctl

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 31-OCT-2014 10:13:44

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL>

	-bash-4.2$ ps -ef | grep lsnr
	oracle   24564 24491  0 10:13 pts/0    00:00:00 /home/oracle/Ora12c/db/bin/lsnrctl
	oracle   24585 24534  0 10:15 pts/1    00:00:00 grep --color=auto lsnr

LSNRCTL> start
Starting /home/oracle/Ora12c/db/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Log messages written to /home/oracle/Ora12c/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                31-OCT-2014 10:15:34
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /home/oracle/Ora12c/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully
LSNRCTL>

	-bash-4.2$ ps -ef | egrep '(lsnr|tns)'
	root        26     2  0 Oct30 ?        00:00:00 [netns]
	oracle   24564 24491  0 10:13 pts/0    00:00:00 /home/oracle/Ora12c/db/bin/lsnrctl
	oracle   24599     1  0 10:15 ?        00:00:00 /home/oracle/Ora12c/db/bin/tnslsnr LISTENER -inherit