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