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 <[email protected]> > Will you share if it is not confidential. > > > > *From:* [email protected] [mailto: > [email protected]] *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 <[email protected]> > > Thanks for the tips, > > > > I need only oracle database to be monitor by Cluster NOT OPMN ( application > server) > > Any clue > > > > sufyan > > > > *From:* [email protected] [mailto: > [email protected]] *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 < [email protected]">[email protected]> > > 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:* [email protected] <linux-clust%21+er-bounceank>[mailto: > [email protected]] *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 > [email protected] > https://www.redhat.com/mailman/listinfo/linux-cluster > > > > > -- > Marcelo Guazzardo > [email protected] > http://mguazzardo.blogspot.com > > </htm > -- > Linux-cluster mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/linux-clust! > er<https://www.redhat.com/mailman/listinfo/linux-cluster> > > > > -- > Marcelo Guazzardo > [email protected] > http://mguazzardo.blogspot.com > > > -- > Linux-cluster mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/linux-cluster > -- Marcelo Guazzardo [email protected] 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="[email protected]"
n
ame="vbox" vm="Nodo1"/>
</method>
</fence>
</clusternode>
<clusternode name="nodo2" nodeid="2" votes="1">
<fence>
<method name="1">
<device host="[email protected]"
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>
oracledb.sh
Description: Bourne shell script
-- Linux-cluster mailing list [email protected] https://www.redhat.com/mailman/listinfo/linux-cluster
