Hi,

I am running RHEL3u8 two node cluster,which is running oracle 9i
database.I am facing problem while rebooting second node causing my
oracle database get stopped in the active node 1 which is running my
database.so i checked below probabilities to find out when the
database get stopped.

Version
clumanager-1.2.31-1.x86_64.rpm

I stopped both the node.

started first node

when the clumanager started during boot cycle on node 2 database
running on node 1 get stopped(checked my oracle alert log telling
the database get stopped exactly at the same time clumanager started
on node 2)

After that When i run clustat on node 1 its telling the
service(database) is running.

I am using /etc/init.d/scriptdb.sh in my cluster config file which is
having both start.stop and status check.

test 2:

I stopped both the node and started the node 2 first and waited for 30 minutes.

oracle was up and running by default on node 2 (clumanger started
oracle service)

started node 1 after 20 minutes

when the clumanager started during boot cycle on node 1 database
running on node 2 get stopped(checked my oracle alert log telling
the database get stopped exactly at the same time clumanager started
on node 1)

After that When i run clustat on node 2 its telling the
service(database) is running.

Test2:

If cluster relocate the service automatically by itself form node 1
to node 2 or node 2 to node 1 for some reason during the critical day
time my database is not getting up during fail over on both the nodes.

Test 3:

If i manually relocate the service from node 1 to node 2 and vice
versa my database is not getting stopped and it is working fine.

Please some one help me to fix out this issue ,it is my critical
production database.

Below is my cluster config file

cluster.xml

<?xml version="1.0"?>
<cluconfig version="3.0">
<clumembd broadcast="yes" interval="1000000" loglevel="5"
multicast="no" multicast_ipaddress="" thread="yes" tko_count="25"/>
<cluquorumd loglevel="7" pinginterval="5" tiebreaker_ip=""/>
<clurmtabd loglevel="7" pollinterval="4"/>
<clusvcmgrd loglevel="7"/>
<clulockd loglevel="7"/>
<cluster config_viewnumber="4"
key="6672bc0a71be2ec9486f6a2f5846c172" name="DBCLUSTER"/>
<sharedstate driver="libsharedraw.so" rawprimary="/dev/raw/raw1"
rawshadow="/dev/raw/raw2" type="raw"/>
<members>
<member id="0" name="cluster1" watchdog="yes"/>
<member id="1" name="cluster2" watchdog="yes"/>
</members>
<services>
<service checkinterval="10" failoverdomain="oracle_db" id="0"
maxfalsestarts="0" maxrestarts="0" name="database"
userscript="/etc/init.d/script_db.sh">
<service_ipaddresses>
<service_ipaddress broadcast="None" id="0"
ipaddress="20.2.135.35" monitor_link="1" netmask="255.255.0.0"/>
</service_ipaddresses>
<device id="0" name="/dev/cciss/c0d0p1" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol1"
options="rw"/>
</device>
<device id="1" name="/dev/cciss/c0d0p2" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol2"
options="rw"/>
</device>
<device id="2" name="/dev/cciss/c0d0p5" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol3"
options="rw"/>
</device>
<device id="3" name="/dev/cciss/c0d0p6" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol4"
options="rw"/>
</device>
<device id="4" name="/dev/cciss/c0d0p7" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol5"
options="rw"/>
</device>
<device id="5" name="/dev/cciss/c0d0p8" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol6"
options="rw"/>
</device>
<device id="6" name="/dev/cciss/c0d0p9" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol7"
options="rw"/>
</device>
<device id="7" name="/dev/cciss/c0d0p10" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol8"
options="rw"/>
</device>
</service>
</services>
<failoverdomains>
<failoverdomain id="0" name="oracle_db" ordered="no" restricted="yes">
<failoverdomainnode id="0" name="cluster1"/>
<failoverdomainnode id="1" name="cluster2"/>
</failoverdomain>
</failoverdomains>
</cluconfig>



Regards,
crazy pap

--
redhat-list mailing list
unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list

Hi,

I am running RHEL3u8 two node cluster,which is running oracle 9i
database.I am facing problem while rebooting second node causing my
oracle database get stopped in the active node 1 which is running my
database.so i checked below probabilities to find out when the
database get stopped.

Version
clumanager-1.2.31-1.x86_64.rpm

I stopped both the node.

started first node

when the clumanager started during boot cycle on node 2 database
running on node 1 get stopped(checked my oracle alert log telling
the database get stopped exactly at the same time clumanager started
on node 2)

After that When i run clustat on node 1 its telling the
service(database) is running.

I am using /etc/init.d/scriptdb.sh in my cluster config file which is
having both start.stop and status check.

test 2:

I stopped both the node and started the node 2 first and waited for 30 minutes.

oracle was up and running by default on node 2 (clumanger started
oracle service)

started node 1 after 20 minutes

when the clumanager started during boot cycle on node 1 database
running on node 2 get stopped(checked my oracle alert log telling
the database get stopped exactly at the same time clumanager started
on node 1)

After that When i run clustat on node 2 its telling the
service(database) is running.

Test2:

If cluster relocate the service automatically by itself form node 1
to node 2 or node 2 to node 1 for some reason during the critical day
time my database is not getting up during fail over on both the nodes.

Test 3:

If i manually relocate the service from node 1 to node 2 and vice
versa my database is not getting stopped and it is working fine.

Please some one help me to fix out this issue ,it is my critical
production database.

Below is my cluster config file

cluster.xml

<?xml version="1.0"?>
<cluconfig version="3.0">
<clumembd broadcast="yes" interval="1000000" loglevel="5"
multicast="no" multicast_ipaddress="" thread="yes" tko_count="25"/>
<cluquorumd loglevel="7" pinginterval="5" tiebreaker_ip=""/>
<clurmtabd loglevel="7" pollinterval="4"/>
<clusvcmgrd loglevel="7"/>
<clulockd loglevel="7"/>
<cluster config_viewnumber="4"
key="6672bc0a71be2ec9486f6a2f5846c172" name="DBCLUSTER"/>
<sharedstate driver="libsharedraw.so" rawprimary="/dev/raw/raw1"
rawshadow="/dev/raw/raw2" type="raw"/>
<members>
<member id="0" name="cluster1" watchdog="yes"/>
<member id="1" name="cluster2" watchdog="yes"/>
</members>
<services>
<service checkinterval="10" failoverdomain="oracle_db" id="0"
maxfalsestarts="0" maxrestarts="0" name="database"
userscript="/etc/init.d/script_db.sh">
<service_ipaddresses>
<service_ipaddress broadcast="None" id="0"
ipaddress="20.2.135.35" monitor_link="1" netmask="255.255.0.0"/>
</service_ipaddresses>
<device id="0" name="/dev/cciss/c0d0p1" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol1"
options="rw"/>
</device>
<device id="1" name="/dev/cciss/c0d0p2" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol2"
options="rw"/>
</device>
<device id="2" name="/dev/cciss/c0d0p5" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol3"
options="rw"/>
</device>
<device id="3" name="/dev/cciss/c0d0p6" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol4"
options="rw"/>
</device>
<device id="4" name="/dev/cciss/c0d0p7" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol5"
options="rw"/>
</device>
<device id="5" name="/dev/cciss/c0d0p8" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol6"
options="rw"/>
</device>
<device id="6" name="/dev/cciss/c0d0p9" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol7"
options="rw"/>
</device>
<device id="7" name="/dev/cciss/c0d0p10" sharename="">
<mount forceunmount="yes" fstype="ext3" mountpoint="/vol8"
options="rw"/>
</device>
</service>
</services>
<failoverdomains>
<failoverdomain id="0" name="oracle_db" ordered="no" restricted="yes">
<failoverdomainnode id="0" name="cluster1"/>
<failoverdomainnode id="1" name="cluster2"/>
</failoverdomain>
</failoverdomains>
</cluconfig>



Regards,
crazy pap
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos

Linux-crazy wrote on Sun, 23 Nov 2008 20:31:37 +0530:

> I am running RHEL3u8 two node cluster,

Bored of naming yourself whoami or lingu? Or just realized that you posted
a few off-topic questions too many with these names?
Please stop abusing this list for your RHEL3 cluster problems. Thanks.

Kai

--
Kai Schätzl, Berlin, Germany
Get your web at Conactive Internet Services: http://www.conactive.com



_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos