[ClusterLabs] Oralsnr/Oracle resources agents

[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 try to bring it UP. Any thoughts ?

Cheers,

On Thu, Feb 23, 2017, 5:01 PM emmanuel segura <emi2fast at 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.mselmi at 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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20170224/f8705849/attachment-0003.html>