<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
h1
{mso-style-priority:9;
mso-style-link:"Heading 1 Char";
margin-top:24.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:0in;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:14.0pt;
font-family:"Cambria","serif";
color:#365F91;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;
color:black;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Heading1Char
{mso-style-name:"Heading 1 Char";
mso-style-priority:9;
mso-style-link:"Heading 1";
font-family:"Cambria","serif";
color:#365F91;
font-weight:bold;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Interestingly, placing the Oracle database listener in its own service propagates this cgroup to all client connections into all databases.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Stopping the listener service kills these connections for all instances handled by the listener, which is not the normal/expected behavior.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:8.0pt;font-family:"Courier New";color:#1F497D'>[root@localhost system]# psc | grep lsnr<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:8.0pt;font-family:"Courier New";color:#1F497D'>8619 oracle 1:name=systemd:/system.slic /home/oracle/Ora12c/db/bin/tnslsnr LISTENER -inherit<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:8.0pt;font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:8.0pt;font-family:"Courier New";color:#1F497D'>[root@localhost system]# ps xawf -eo args,cgroup | tail<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:8.0pt;font-family:"Courier New";color:#1F497D'>…<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:8.0pt;font-family:"Courier New";color:#1F497D'>ora_q002_orcl 1:name=systemd:/system.slice/oracle-orcl.service<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:8.0pt;font-family:"Courier New";color:#1F497D'>ora_q003_orcl 1:name=systemd:/system.slice/oracle-orcl.service<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:8.0pt;font-family:"Courier New";color:#1F497D'>oracleorcl (LOCAL=NO) 1:name=systemd:/system.slice/oracle-listener.service<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:8.0pt;font-family:"Courier New";color:#1F497D'>ora_j000_orcl 1:name=systemd:/system.slice/oracle-orcl.service<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:8.0pt;font-family:"Courier New";color:#1F497D'>ora_j001_orcl 1:name=systemd:/system.slice/oracle-orcl.service<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>The dbstart script (supplied by Oracle) also likely should not be used, since it will place all instances in the same cgroup.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> systemd-devel [mailto:systemd-devel-bounces@lists.freedesktop.org] <b>On Behalf Of </b>"Jóhann B. Guðmundsson"<br><b>Sent:</b> Tuesday, October 28, 2014 2:43 PM<br><b>To:</b> systemd-devel@lists.freedesktop.org<br><b>Subject:</b> EXT: Re: [systemd-devel] starting Oracle with systemd<o:p></o:p></span></p></div></div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in'>On 10/28/2014 07:08 PM, Fisher, Charles J. (Top Echelon) wrote:<br><br><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'>Is this the best way to start Oracle?<o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'> <o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><br>No and unfortunately for you Oracle is not open source and has a bad track record taking code submissions which is probably why nobody has written a proper systemd unit for it and pushed it upstream.<br><br><snip><br>( you need to post to the original initscript along with any startup scripts in conjuction with that init script to so the proper course of action can be taken when migrating it to native systemd unit(s) use something like fpaste if you intent on doing that )<br><br><br><o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'> <o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'>I may have several instances on a machine; I’d like one service to start/stop everything if possible (maybe with dbstart/dbshut), but I also want granular control over each Oracle instance.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><br>You would do so by creating an specific oracledb.target followed by new oracle instance units. <br><br>I'm not sure how much we should be involved with migrating that since it's closed source and we cant be held countable if our migration breaks your support contract hence it's probably best that you requesting new units and targets from Oracle support directly. ( which is probably not what you want to hear but meh )<br><br>JBG<o:p></o:p></span></p></div></body></html>