[ClusterLabs] Oralsnr/Oracle resources agents

2017-02-23 Thread Jihed M'selmi
I was reading the oralsnr script, I found that to stop a listener the agent uses the lsnrctl to stop the instances. My questions, how to configure this agent for an oracle listener attached the multiple instance ? My 2nd quest, is it possible to enhance the ora-common.sh and resource.d/oracle to

Re: [ClusterLabs] Oralsnr/Oracle resources agents

2017-02-23 Thread emmanuel segura
I think no, in /usr/lib/ocf/resource.d/heartbeat/oralsnr start function, oralsnr_start = "output=`echo lsnrctl start $listener | runasdba`" stop function, oralsnr_stop = "output=`echo lsnrctl stop $listener | runasdba`" Where listener variable is the resource agent parameter given by pacemaker :

Re: [ClusterLabs] Oralsnr/Oracle resources agents

2017-02-24 Thread Jihed M'selmi
Hi, Using one instance per service leads to a memory issues espacially when we have many instance per node. Regarding the 2nd point, I think it's better to read the flag on Y/N in the oratab. I see some issue/missbehavior, when, some db has N in oratab (the instance shouldn't run), the cluster t

Re: [ClusterLabs] Oralsnr/Oracle resources agents

2017-02-25 Thread Dejan Muhamedagic
Hi, On Fri, Feb 24, 2017 at 10:09:28AM +, Jihed M'selmi wrote: > Hi, > > Using one instance per service leads to a memory issues espacially when we > have many instance per node. Complain to oracle? ;-> I thought that oracle listener is not consuming that many resources. At any rate, ocf:he

Re: [ClusterLabs] Oralsnr/Oracle resources agents

2017-02-25 Thread Jihed M'selmi
[DM] I thought that oracle listener is not consuming that many resources. At any rate, ocf:heartbeat:oralsnr doesn't support single listener for multiple instances. Do you have an idea how to do that? How to deal with the tnsping then? Maybe you're better off with the system start script in this ca

Re: [ClusterLabs] Oralsnr/Oracle resources agents

2017-02-25 Thread Andrei Borzenkov
25.02.2017 23:18, Jihed M'selmi пишет: > [DM] I thought that oracle listener is not consuming that many resources. > At any rate, ocf:heartbeat:oralsnr doesn't support single listener for > multiple instances. Do you have an idea how to do that? How to deal with > the tnsping then? Maybe you're bet

Re: [ClusterLabs] Oralsnr/Oracle resources agents

2017-03-01 Thread Dejan Muhamedagic
Hi, On Sun, Feb 26, 2017 at 09:51:47AM +0300, Andrei Borzenkov wrote: > 25.02.2017 23:18, Jihed M'selmi пишет: > > [DM] I thought that oracle listener is not consuming that many resources. > > At any rate, ocf:heartbeat:oralsnr doesn't support single listener for > > multiple instances. Do you hav