[Linux-cluster] oracle DB is not failing over on killin PMON deamon

[Marcelo Guazzardo]

Hy sufyan

I sent two files. First, is cluster.conf, second, is the oracledb.sh , this
file must be placed in /usr/share/cluster in both nodes. (Or if you have
more nodes, in all nodes).
In oracledb.sh I 've changed oracle_user, oracle_sid, type of database, I
used base (for monitor and listener), and virtual ip,

If you have any doubt, just let me know
I hope that helps you
Regards,
Marcelo


2011/5/15 Sufyan Khan <sufyan.khan at its.ws>

> Will you share if it is not confidential.
>
>
>
> *From:* linux-cluster-bounces at redhat.com [mailto:
> linux-cluster-bounces at redhat.com] *On Behalf Of *Marcelo Guazzardo
> *Sent:* Sunday, May 15, 2011 7:03 PM
>
> *To:* linux clustering
> *Subject:* Re: [Linux-cluster] oracle DB is not failing over on killin
> PMON deamon
>
>
>
> ok, this script checks the listener a! nd db , i uot; in database type.
>
> I 've worked with oracle10g r2 , and it worked fine for me.
> Thanks
>
> 2011/5/15 Sufyan Khan <sufyan.khan at its.ws>
>
> Thanks for the tips,
>
>
>
> I need only oracle database to be monitor by Cluster NOT OPMN ( application
> server)
>
> Any clue
>
>
>
> sufyan
>
>
>
> *From:* linux-cluster-bounces at redhat.com [mailto:
> linux-cluster-bounces at redhat.com] *On Behalf Of *Marcelo Guazzardo
> *Sent:* Sunday, May 15, 2011 11:29 AM
>
>
> *To:* linux clustering
> *Subject:* Re: [Linux-cluster] oracle DB is not failing over on killin
> PMON deamon
>
>
>
> HI sufyan
>
>
>
> Maybe is irrelevant, but, do you try with oracledb.sh script?.
> I use that script and all work fine for me....
>
> Regards,
> Marcelo
> PS: that script is placed in /usr/share/cluster/oracledb.sh, you must
> modify the oracle settings, like orauser, db_instance_name, and db_virtual
> name.
>
> 2011/5/15 Sufyan! Khan &lt han at its.ws">sufyan.khan at its.ws>
>
> There is writing mistake, I *cannot* see the script is running in
> background.!
>
> Off course I stop the cluster then I run the manual script.
>
>
>
>
>
>
>
> *From:* linux-cluster-bounces at redhat.com <linux-clust%21+er-bounceank>[mailto:
> linux-cluster-bounces at redhat.com] *On Behalf Of *Rajagopal Swaminathan
> *Sent:* Sunday, May 15, 2011 12:14 AM
>
>
> *To:* linux clustering
> *Subject:* Re: [Linux-cluster] oracle DB is not failing over on killin
> PMON deamon
>
>
>
> Greetings,
>
> I ca nd as root, but do see the script is running in background as  a
> daemon,
>
>
>
>
>
> Mohammad Raza Sufyan Khan
> Team Leader (Technology&Infrastructure Group)
>
> Telco development
>
>
>
> a stupid question: Have you used chkconfig to switchoff all the cluster
> controlled services?
>
> ! IMHO, The >Regards,
>
> ! Rajagopal v>
>
>
> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster
>
>
>
>
> --
> Marcelo Guazzardo
> mguazzardo76 at gmail.com
> http://mguazzardo.blogspot.com
>
> </htm
> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-clust! er<https://www.redhat.com/mailman/listinfo/linux-cluster>
>
>
>
> --
> Marcelo Guazzardo
> mguazzardo76 at gmail.com
> http://mguazzardo.blogspot.com
>
>
> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster
>



-- 
Marcelo Guazzardo
mguazzardo76 at gmail.com
http://mguazzardo.blogspot.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20110516/11c70a79/attachment.htm>
-------------- next part --------------
<?xml version="1.0"?>
<cluster config_version="17" name="Labo">
        <fence_daemon post_fail_delay="0" post_join_delay="3"/>
        <clusternodes>
                <clusternode name="nodo1" nodeid="1" votes="1">
                <fence>
                        <method name="1">
                                <device host="marcelo at consolas.balinux.com.ar" n                                                                             ame="vbox" vm="Nodo1"/>
                        </method>
                </fence>
                </clusternode>
                <clusternode name="nodo2" nodeid="2" votes="1">
                <fence>
                        <method name="1">
                                <device host="marcelo at consolas.balinux.com.ar" n                                                                             ame="vbox" vm="Nodo2"/>
                        </method>
                </fence>
                </clusternode>
        </clusternodes>
        <cman expected_votes="1" two_node="1"/>
        <fencedevices>
                <fencedevice agent="fence_vbox" name="vbox"/>
        </fencedevices>
        <rm>
                <failoverdomains/>
        <service name="oracleha">
                <fs device="/dev/sdb1" force_unmount="1" fstype="ext3" mountpoin                                                                             t="/mnt/oracle" name="Oracle Mount"/>
                <oracledb name="orcl" user="oracle" home="/mnt/oracle/product/10                                                                             .2.0/db_1" type="10g" vhost="oracleha.balinux.com.ar"/>
                <ip address="192.168.0.90"/>
        </service>
        </rm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: oracledb.sh
Type: application/x-sh
Size: 21744 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20110516/11c70a79/attachment.sh>