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
Will you share if it is not confidential.
From: linux-cluster-bounces@xxxxxxxxxx [mailto:linux-cluster-bounces@xxxxxxxxxx] On Behalf Of Marcelo Guazzardo
Sent: Sunday, May 15, 2011 7:03 PM
To: linux clustering
Subject: Re: 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.
Thanks2011/5/15 Sufyan Khan <sufyan.khan@xxxxxx>
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@xxxxxxxxxx [mailto:linux-cluster-bounces@xxxxxxxxxx] 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.https://www.redhat.com/mailman/listinfo/linux-clust! er2011/5/15 Sufyan! Khan < han@xxxxxx">sufyan.khan@xxxxxx>
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@xxxxxxxxxx [mailto:linux-cluster-bounces@xxxxxxxxxx] 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@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster
--
Marcelo Guazzardo
mguazzardo76@xxxxxxxxx
http://mguazzardo.blogspot.com
--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster
--
Marcelo Guazzardo
mguazzardo76@xxxxxxxxx
http://mguazzardo.blogspot.com
<?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@xxxxxxxxxxxxxxxxxxxxxxx" n ame="vbox" vm="Nodo1"/>
</method>
</fence>
</clusternode>
<clusternode name="nodo2" nodeid="2" votes="1">
<fence>
<method name="1">
<device host="marcelo@xxxxxxxxxxxxxxxxxxxxxxx" 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>
Attachment:
oracledb.sh
Description: Bourne shell script
-- Linux-cluster mailing list Linux-cluster@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/linux-cluster
