Re: [ClusterLabs] Oralsnr/Oracle resources agents
[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 case. [JM] According to the dba, it could lead some memory issue when the listener serves many instances at the same time (in my experience, I have never faced this issue). Let's take a case when the listener is serving multiple instance, and one of the instance fails => ocf:heartbeat:oracle will relocate it to another node, the listener should follow (especially, when we use collocation constraint between RA oracle and oralsnr) this will have a bad impact on the rest of instances. One of the option is to have two listeners (one per node) and configured outside the cluster to host the all instance. But, I keep looking for a better solution. [DM] Hmm, what should then the RA do? Skip the instance and report it started? I'm not sure I follow. [JM] The DBA use a flag Y/N to tell if this instance should run or no. It could be better, for RA to use this flag too: when it's Y start the instance and when It's N, the RA should not start the instance and suitable message in log will be usefull to describe the situation. Now, the challenge is how to monitor this flag. One of the issue that I faced when the DBA when to shutdown the listener and the instance (for launch the cold backup) but, the RA keep pushing them ON. -- Note the dba team usually don't have an access to pcs to disable the resource during this type of operation. I wish my reply could make sense... Thanks, Jihed MSELMI On Sat, Feb 25, 2017 at 8:31 PM Dejan Muhamedagic <deja...@fastmail.fm> wrote: > Hi, > > On Fri, Feb 24, 2017 at 10:09:28AM +0000, 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: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 case. > > > 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 try to bring it UP. Any thoughts ? > > Hmm, what should then the RA do? Skip the instance and report it > started? I'm not sure I follow. > > Thanks, > > Dejan > > > Cheers, > > > > On Thu, Feb 23, 2017, 5:01 PM emmanuel segura <emi2f...@gmail.com> > wrote: > > > > > 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 : # OCF_RESKEY_listener (optional; defaults to LISTENER) > > > > > > Why don't use one listener per instance? > > > > > > 2017-02-23 16:37 GMT+01:00 Jihed M'selmi <jihed.mse...@gmail.com>: > > > > 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 take in account the flag y/n in the oratab in > order > > > to > > > > start the database or no ? > > > > > > > > Cheers, > > > > > > > > -- > > > > > > > > > > > > Jihed MSELMI > > > > RHCE, RHCSA, VCP4 > > > > 10 Villa Stendhal, 75020 Paris France > > > > Mobile: +33 (0) 753768653 <+33%207%2053%2076%2086%2053> > > > > > > > > ___ > > > > Users mailing list: Users@clusterlabs.org > > > > http://lists.clusterlabs.org/mailman/listinfo/users > > > > > > > > Project Home: http://www.clusterlabs.org > > > > Getting started: > http://www.clusterlabs.org/doc/Cluster_fr
Re: [ClusterLabs] Oralsnr/Oracle resources agents
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 try to bring it UP. Any thoughts ? Cheers, On Thu, Feb 23, 2017, 5:01 PM emmanuel segura <emi2f...@gmail.com> wrote: > 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 : # OCF_RESKEY_listener (optional; defaults to LISTENER) > > Why don't use one listener per instance? > > 2017-02-23 16:37 GMT+01:00 Jihed M'selmi <jihed.mse...@gmail.com>: > > 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 take in account the flag y/n in the oratab in order > to > > start the database or no ? > > > > Cheers, > > > > -- > > > > > > Jihed MSELMI > > RHCE, RHCSA, VCP4 > > 10 Villa Stendhal, 75020 Paris France > > Mobile: +33 (0) 753768653 > > > > ___ > > Users mailing list: Users@clusterlabs.org > > http://lists.clusterlabs.org/mailman/listinfo/users > > > > Project Home: http://www.clusterlabs.org > > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > Bugs: http://bugs.clusterlabs.org > > > > > > -- > .~. > /V\ > // \\ > /( )\ > ^`~'^ > > ___ > Users mailing list: Users@clusterlabs.org > http://lists.clusterlabs.org/mailman/listinfo/users > > Project Home: http://www.clusterlabs.org > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > Bugs: http://bugs.clusterlabs.org > -- Jihed MSELMI RHCE, RHCSA, VCP4 10 Villa Stendhal, 75020 Paris France Mobile: +33 (0) 753768653 ___ Users mailing list: Users@clusterlabs.org http://lists.clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
[ClusterLabs] Oralsnr/Oracle resources agents
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 take in account the flag y/n in the oratab in order to start the database or no ? Cheers, -- Jihed MSELMI RHCE, RHCSA, VCP4 10 Villa Stendhal, 75020 Paris France Mobile: +33 (0) 753768653 ___ Users mailing list: Users@clusterlabs.org http://lists.clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
Re: [ClusterLabs] Fence agent for VirtualBox
Yeah, I see your point. :) On Mon, Feb 6, 2017, 3:40 PM Klaus Wenninger <kwenn...@redhat.com> wrote: > On 02/06/2017 03:35 PM, Jihed M'selmi wrote: > > > > So do you suggest to used the sdb ? > > The virtualbox was installed above Windows. > > > > Just wanted to give you an option if you don't have > a working fence-agent directly talking to the hypervisor - > which I would always prefer. > > > > > On Mon, Feb 6, 2017, 3:20 PM Klaus Wenninger <kwenn...@redhat.com > > <mailto:kwenn...@redhat.com>> wrote: > > > > No experience with fencing vbox-VMs on my side either ... > > But as always when there is no physical fencing-device > > available sbd might be a way to go - either with just > > a watchdog (guess vbox offers a virtual watchdog that > > is supported by the linux-kernel or at least if you install > > the guest-support for vbox) or with shared block-devices > > on top. > > > > Regards, > > Klaus > > > > On 02/06/2017 02:22 PM, Jihed M'selmi wrote: > > > > > > Not really, I found something in some google group but, it's not > > > documented (if I am not wrong). > > > > > > > > > On Mon, Feb 6, 2017, 2:21 PM Marek Grac <mg...@redhat.com > > <mailto:mg...@redhat.com> > > > <mailto:mg...@redhat.com <mailto:mg...@redhat.com>>> wrote: > > > > > > Hi, > > > > > > I don't have one. But I see a lot of question about > > fence_vbox in > > > last days, is there any new material that references it? > > > > > > m, > > > > > > On Mon, Feb 6, 2017 at 1:56 PM, Jihed M'selmi > > > <jihed.mse...@gmail.com <mailto:jihed.mse...@gmail.com> > > <mailto:jihed.mse...@gmail.com <mailto:jihed.mse...@gmail.com>>> > > wrote: > > > > > > Hi, > > > > > > I want set up a pcmk/corosync cluster using couple vbox > > nodes. > > > > > > Anyone could.share how to install/configure a fence agent > > > fence_vbox ? > > > > > > Cheers > > > JM > > > -- > > > > > > J.M > > > > > > > > > ___ > > > Users mailing list: Users@clusterlabs.org > > <mailto:Users@clusterlabs.org> > > > <mailto:Users@clusterlabs.org > > <mailto:Users@clusterlabs.org>> > > > http://lists.clusterlabs.org/mailman/listinfo/users > > > > > > Project Home: http://www.clusterlabs.org > > > Getting started: > > > http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > > Bugs: http://bugs.clusterlabs.org > > > > > > > > > ___ > > > Users mailing list: Users@clusterlabs.org > > <mailto:Users@clusterlabs.org> > > > <mailto:Users@clusterlabs.org <mailto:Users@clusterlabs.org>> > > > http://lists.clusterlabs.org/mailman/listinfo/users > > > > > > Project Home: http://www.clusterlabs.org > > > Getting started: > > > http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > > Bugs: http://bugs.clusterlabs.org > > > > > > -- > > > > > > J.M > > > > > > > > > > > > ___ > > > Users mailing list: Users@clusterlabs.org > > <mailto:Users@clusterlabs.org> > > > http://lists.clusterlabs.org/mailman/listinfo/users > > > > > > Project Home: http://www.clusterlabs.org > > > Getting started: > > http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > > Bugs: http://bugs.clusterlabs.org > > > > > > > > ___ > > Users mailing list: Users@clusterlabs.org > > <mailto:Users@clusterlabs.org> > > http://lists.clusterlabs.org/mailman/listinfo/users > > > > Project Home: http://www.clusterlabs.org > > Getting started: > > http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > Bugs: http://bugs.clusterlabs.org > > > > -- > > > > J.M > > > > > ___ > Users mailing list: Users@clusterlabs.org > http://lists.clusterlabs.org/mailman/listinfo/users > > Project Home: http://www.clusterlabs.org > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > Bugs: http://bugs.clusterlabs.org > -- J.M ___ Users mailing list: Users@clusterlabs.org http://lists.clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
Re: [ClusterLabs] Fence agent for VirtualBox
So do you suggest to used the sdb ? The virtualbox was installed above Windows. On Mon, Feb 6, 2017, 3:20 PM Klaus Wenninger <kwenn...@redhat.com> wrote: > No experience with fencing vbox-VMs on my side either ... > But as always when there is no physical fencing-device > available sbd might be a way to go - either with just > a watchdog (guess vbox offers a virtual watchdog that > is supported by the linux-kernel or at least if you install > the guest-support for vbox) or with shared block-devices > on top. > > Regards, > Klaus > > On 02/06/2017 02:22 PM, Jihed M'selmi wrote: > > > > Not really, I found something in some google group but, it's not > > documented (if I am not wrong). > > > > > > On Mon, Feb 6, 2017, 2:21 PM Marek Grac <mg...@redhat.com > > <mailto:mg...@redhat.com>> wrote: > > > > Hi, > > > > I don't have one. But I see a lot of question about fence_vbox in > > last days, is there any new material that references it? > > > > m, > > > > On Mon, Feb 6, 2017 at 1:56 PM, Jihed M'selmi > > <jihed.mse...@gmail.com <mailto:jihed.mse...@gmail.com>> wrote: > > > > Hi, > > > > I want set up a pcmk/corosync cluster using couple vbox nodes. > > > > Anyone could.share how to install/configure a fence agent > > fence_vbox ? > > > > Cheers > > JM > > -- > > > > J.M > > > > > > ___ > > Users mailing list: Users@clusterlabs.org > > <mailto:Users@clusterlabs.org> > > http://lists.clusterlabs.org/mailman/listinfo/users > > > > Project Home: http://www.clusterlabs.org > > Getting started: > > http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > Bugs: http://bugs.clusterlabs.org > > > > > > ___ > > Users mailing list: Users@clusterlabs.org > > <mailto:Users@clusterlabs.org> > > http://lists.clusterlabs.org/mailman/listinfo/users > > > > Project Home: http://www.clusterlabs.org > > Getting started: > > http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > Bugs: http://bugs.clusterlabs.org > > > > -- > > > > J.M > > > > > > > > ___ > > Users mailing list: Users@clusterlabs.org > > http://lists.clusterlabs.org/mailman/listinfo/users > > > > Project Home: http://www.clusterlabs.org > > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > Bugs: http://bugs.clusterlabs.org > > > > ___ > Users mailing list: Users@clusterlabs.org > http://lists.clusterlabs.org/mailman/listinfo/users > > Project Home: http://www.clusterlabs.org > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > Bugs: http://bugs.clusterlabs.org > -- J.M ___ Users mailing list: Users@clusterlabs.org http://lists.clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
Re: [ClusterLabs] Fence agent for VirtualBox
Not really, I found something in some google group but, it's not documented (if I am not wrong). On Mon, Feb 6, 2017, 2:21 PM Marek Grac <mg...@redhat.com> wrote: > Hi, > > I don't have one. But I see a lot of question about fence_vbox in last > days, is there any new material that references it? > > m, > > On Mon, Feb 6, 2017 at 1:56 PM, Jihed M'selmi <jihed.mse...@gmail.com> > wrote: > > Hi, > > I want set up a pcmk/corosync cluster using couple vbox nodes. > > Anyone could.share how to install/configure a fence agent fence_vbox ? > > Cheers > JM > -- > > J.M > > ___ > Users mailing list: Users@clusterlabs.org > http://lists.clusterlabs.org/mailman/listinfo/users > > Project Home: http://www.clusterlabs.org > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > Bugs: http://bugs.clusterlabs.org > > > ___ > Users mailing list: Users@clusterlabs.org > http://lists.clusterlabs.org/mailman/listinfo/users > > Project Home: http://www.clusterlabs.org > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > Bugs: http://bugs.clusterlabs.org > -- J.M ___ Users mailing list: Users@clusterlabs.org http://lists.clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
[ClusterLabs] Fence agent for VirtualBox
Hi, I want set up a pcmk/corosync cluster using couple vbox nodes. Anyone could.share how to install/configure a fence agent fence_vbox ? Cheers JM -- J.M ___ Users mailing list: Users@clusterlabs.org http://lists.clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
Re: [ClusterLabs] How to change the name of one cluster resource and resource group ?
The only thing that I found is to create a backup with pcs config Modify it and then restore. I was hoping to use a simple command On Wed, Feb 1, 2017, 4:05 PM Kristoffer Grönlund <kgronl...@suse.com> wrote: > Jihed M'selmi <jihed.mse...@gmail.com> writes: > > > Thanks for reply, > > I don't have crm command. It's corosync version 2.3.4.el7_2.1. > > > > crmsh is a separate project, you can install it in parallel with > corosync/pacemaker. There are packages on OBS: > > > http://download.opensuse.org/repositories/network:/ha-clustering:/Stable/RedHat_RHEL-7/ > > Otherwise if you have pcs it should have something similar to crm > configure rename. > > Cheers, > Kristoffer > > > On Wed, Feb 1, 2017, 3:38 PM Kristoffer Grönlund <kgronl...@suse.com> > wrote: > > > >> Jihed M'selmi <jihed.mse...@gmail.com> writes: > >> > >> > Hello, > >> > > >> > I need update the name of one resource group with a new name. Any > >> thoughts? > >> > > >> > >> crmsh has the crm configure rename command, which tries to update any > >> constraint references atomically as well. > >> > >> Cheers, > >> Kristoffer > >> > >> > Cheers, > >> > JM > >> > -- > >> > > >> > J.M > >> > ___ > >> > Users mailing list: Users@clusterlabs.org > >> > http://lists.clusterlabs.org/mailman/listinfo/users > >> > > >> > Project Home: http://www.clusterlabs.org > >> > Getting started: > http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > >> > Bugs: http://bugs.clusterlabs.org > >> > >> -- > >> // Kristoffer Grönlund > >> // kgronl...@suse.com > >> > > -- > > > > J.M > > -- > // Kristoffer Grönlund > // kgronl...@suse.com > -- J.M ___ Users mailing list: Users@clusterlabs.org http://lists.clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
Re: [ClusterLabs] How to change the name of one cluster resource and resource group ?
Thanks for reply, I don't have crm command. It's corosync version 2.3.4.el7_2.1. On Wed, Feb 1, 2017, 3:38 PM Kristoffer Grönlund <kgronl...@suse.com> wrote: > Jihed M'selmi <jihed.mse...@gmail.com> writes: > > > Hello, > > > > I need update the name of one resource group with a new name. Any > thoughts? > > > > crmsh has the crm configure rename command, which tries to update any > constraint references atomically as well. > > Cheers, > Kristoffer > > > Cheers, > > JM > > -- > > > > J.M > > ___ > > Users mailing list: Users@clusterlabs.org > > http://lists.clusterlabs.org/mailman/listinfo/users > > > > Project Home: http://www.clusterlabs.org > > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > Bugs: http://bugs.clusterlabs.org > > -- > // Kristoffer Grönlund > // kgronl...@suse.com > -- J.M ___ Users mailing list: Users@clusterlabs.org http://lists.clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
[ClusterLabs] How to change the name of one cluster resource and resource group ?
Hello, I need update the name of one resource group with a new name. Any thoughts? Cheers, JM -- J.M ___ Users mailing list: Users@clusterlabs.org http://lists.clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
Re: [ClusterLabs] Can't create a resource for ocf:heartbeat:oracle and oraclsnr.
I wish I could :-/ All I am asking about the requirement to use the Resource Agent OCF:heartbeat:oracle and ocf:heartbeat:orclsnr. Thanks Jihed M’SELMI Mobile: +21658433664 http://about.me/jihed.mselmi On Tue, Jan 31, 2017 at 12:16 AM, emmanuel segura <emi2f...@gmail.com> wrote: > please, if you need help, the first thing is show, your cluster > configuration. > > 2017-01-30 23:15 GMT+01:00 Jihed M'selmi <jihed.mse...@gmail.com>: > > I tried to install two resources: a resource for oracle database and > oracle > > listener: but the pcmk can't install the resource (red hat 7.3) usint hte > > ocf:heartbeat:oracle and oraclsnr > > > > On the log,ti shows that the sqlplus was not installed. > > > > I installed it, but, I keep getting the same message and the resources > were > > not installed. > > > > Is there any requirement to use OCF:HEARTBEAT:ORACLE and ORACLSNR ? > > > > In my resource group, I have One rsc for IP, Three rsc for filesystems > > where I have the oracle binary, db and backup and I should have Two more > rsc > > for database and listener. > > > > Could anyone share how to configure a peacemaker and corosync to host an > > Oracle database on two nodes ? (or more). > > > > Thanks in advance. > > Cheers, > > JM > > > > ___ > > Users mailing list: Users@clusterlabs.org > > http://lists.clusterlabs.org/mailman/listinfo/users > > > > Project Home: http://www.clusterlabs.org > > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > Bugs: http://bugs.clusterlabs.org > > > > > > -- > .~. > /V\ > // \\ > /( )\ > ^`~'^ > > ___ > Users mailing list: Users@clusterlabs.org > http://lists.clusterlabs.org/mailman/listinfo/users > > Project Home: http://www.clusterlabs.org > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > Bugs: http://bugs.clusterlabs.org > ___ Users mailing list: Users@clusterlabs.org http://lists.clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org