[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

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



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 its ws>

Will you share if it is not confidential.

 

From: linux-cluster-bounces redhat com [mailto:linux-cluster-bounces 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 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 redhat com [mailto:linux-cluster-bounces 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 its ws">sufyan khan 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 redhat com [mailto:linux-cluster-bounces 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>

</htm
--
Linux-cluster mailing list
Linux-cluster redhat com
https://www.redhat.com/mailman/listinfo/linux-clust! er


--
Linux-cluster mailing list
Linux-cluster redhat com
https://www.redhat.com/mailman/listinfo/linux-cluster



--
Marcelo Guazzardo
mguazzardo76 gmail com
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 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 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>

Attachment: oracledb.sh
Description: Bourne shell script


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]