[Linux-cluster] oracledb.sh

Fri Mar 19 09:56:09 UTC 2010

This is the log messages related to restarting oracle.
to simulate oracle problems I kill pmon and removed initSCAPA1.ora
after that it gets on this loop, executing oracledb.sh over and over
perhaps there's a param Im missing on cluster.conf? ( its pasted after )

Mar 18 15:52:05 dc1-x6250-a oracledb.sh: Restarting Oracle Database...
Mar 18 15:52:05 dc1-x6250-a cat:
Mar 18 15:52:05 dc1-x6250-a cat: SQL*Plus: Release 11.1.0.7.0 - Production
on Thu Mar 18 15:52:05 2010
Mar 18 15:52:05 dc1-x6250-a cat:
Mar 18 15:52:05 dc1-x6250-a cat: Copyright (c) 1982, 2008, Oracle.  All
rights reserved.
Mar 18 15:52:05 dc1-x6250-a cat:
Mar 18 15:52:05 dc1-x6250-a cat: Connected to an idle instance.
Mar 18 15:52:05 dc1-x6250-a cat:
Mar 18 15:52:05 dc1-x6250-a cat: SQL> ORACLE instance shut down.
Mar 18 15:52:05 dc1-x6250-a cat: SQL> Disconnected
Mar 18 15:52:05 dc1-x6250-a cat:
Mar 18 15:52:05 dc1-x6250-a cat: SQL*Plus: Release 11.1.0.7.0 - Production
on Thu Mar 18 15:52:05 2010
Mar 18 15:52:05 dc1-x6250-a cat:
Mar 18 15:52:05 dc1-x6250-a cat: Copyright (c) 1982, 2008, Oracle.  All
rights reserved.
Mar 18 15:52:05 dc1-x6250-a cat:
Mar 18 15:52:05 dc1-x6250-a cat: Connected to an idle instance.
Mar 18 15:52:05 dc1-x6250-a cat:
Mar 18 15:52:05 dc1-x6250-a cat: SQL> ORA-01078: failure in processing
system parameters
Mar 18 15:52:05 dc1-x6250-a cat: LRM-00109: could not open parameter file
'initSCAPA1.ora'
Mar 18 15:52:05 dc1-x6250-a cat: SQL> Disconnected
Mar 18 15:52:35 dc1-x6250-a oracledb.sh: Restarting Oracle Database...

cluster.conf
<?xml version="1.0"?>
<cluster alias="oracle_prod" config_version="40" name="oracle_prod">
	<fence_daemon clean_start="1" post_fail_delay="100" post_join_delay="-1"/>
	<clusternodes>
		<clusternode name="dc2-x6250-a-cl.lux.eib.org" nodeid="1" votes="1">
			<fence>
				<method name="1">
					<device name="fence_dc2-x6250-a"/>
				</method>
			</fence>
		</clusternode>
		<clusternode name="dc1-x6250-a-cl.lux.eib.org" nodeid="2" votes="1">
			<fence>
				<method name="1">
					<device name="fence_dc1-x6250-a"/>
				</method>
			</fence>
		</clusternode>
	</clusternodes>
	<cman expected_votes="2" two_node="0"/>
	<fencedevices>
		<fencedevice agent="fence_ipmilan" ipaddr="172.26.240.3" login="root"
name="fence_dc1-x6250-a" passwd="no7+WaYs"/>
		<fencedevice agent="fence_ipmilan" ipaddr="172.26.240.4" login="root"
name="fence_dc2-x6250-a" passwd="no7+WaYs"/>
	</fencedevices>
	<rm>
		<failoverdomains>
			<failoverdomain name="scapa_failover_domain" nofailback="0" ordered="0"
restricted="1">
				<failoverdomainnode name="dc2-x6250-a-cl.lux.eib.org" priority="1"/>
				<failoverdomainnode name="dc1-x6250-a-cl.lux.eib.org" priority="1"/>
			</failoverdomain>
			<failoverdomain name="jura_failover_domain" nofailback="0" ordered="1"
restricted="1">
				<failoverdomainnode name="dc2-x6250-a-cl.lux.eib.org" priority="1"/>
				<failoverdomainnode name="dc1-x6250-a-cl.lux.eib.org" priority="2"/>
			</failoverdomain>
		</failoverdomains>
		<resources>
			<lvm lv_name="" name="scapa_resource" vg_name="vg_ora_scapa"/>
			<fs device="/dev/vg_ora_scapa/lv_ora_scapa_arch" force_fsck="0"
force_unmount="0" fsid="2069" fstype="ext3"
mountpoint="/app/oracle/scapa/archive" name="ora_scapa_arch"
self_fence="0"/>
			<fs device="/dev/vg_ora_scapa/lv_ora_scapa_redo" force_fsck="0"
force_unmount="0" fsid="2070" fstype="ext3"
mountpoint="/app/oracle/scapa/redo" name="ora_scapa_redo"
self_fence="0"/>
			<fs device="/dev/vg_ora_scapa/lv_ora_scapa_data" force_fsck="0"
force_unmount="0" fsid="2071" fstype="ext3"
mountpoint="/app/oracle/scapa/data" name="ora_scapa_data"
self_fence="0"/>
			<fs device="/dev/vg_ora_scapa/lv_ora_scapa_export" force_fsck="0"
force_unmount="0" fsid="2072" fstype="ext3"
mountpoint="/app/oracle/scapa/export" name="ora_scapa_export"
self_fence="0"/>
			<lvm lv_name="" name="jura_resource" vg_name="vg_ora_jura"/>
			<fs device="/dev/vg_ora_jura/lv_ora_jura_arch" force_fsck="0"
force_unmount="0" fsid="2073" fstype="ext3"
mountpoint="/app/oracle/jura/archive" name="ora_jura_arch"
self_fence="0"/>
			<fs device="/dev/vg_ora_jura/lv_ora_jura_redo" force_fsck="0"
force_unmount="0" fsid="2074" fstype="ext3"
mountpoint="/app/oracle/jura/redo" name="ora_jura_redo"
self_fence="0"/>
			<fs device="/dev/vg_ora_jura/lv_ora_jura_data" force_fsck="0"
force_unmount="0" fsid="2075" fstype="ext3"
mountpoint="/app/oracle/jura/data" name="ora_jura_data"
self_fence="0"/>
			<fs device="/dev/vg_ora_jura/lv_ora_jura_export" force_fsck="0"
force_unmount="0" fsid="2076" fstype="ext3"
mountpoint="/app/oracle/jura/export" name="ora_jura_export"
self_fence="0"/>
			<ip address="172.26.18.35" monitor_link="1"/>
			<ip address="172.26.18.37" monitor_link="1"/>
			<oracledb home="/app/oracle/u02/product/11.1.0.7"
listener_name="listener_JURA1" name="JURA1" type="base" user="oracle"/>
			<oracledb home="/app/oracle/u02/product/11.1.0.7"
listener_name="listener_SCAPA1" name="SCAPA1" type="base"
user="oracle"/>
		</resources>
		<service autostart="0" domain="scapa_failover_domain" exclusive="0"
name="scapa" recovery="relocate">
			<ip ref="172.26.18.35">
				<lvm ref="scapa_resource">
					<fs ref="ora_scapa_arch"/>
					<fs ref="ora_scapa_redo"/>
					<fs ref="ora_scapa_data"/>
					<fs ref="ora_scapa_export"/>
					<oracledb ref="SCAPA1"/>
				</lvm>
			</ip>
		</service>
		<service autostart="1" domain="jura_failover_domain" exclusive="0"
name="jura" recovery="relocate">
			<ip ref="172.26.18.37">
				<lvm ref="jura_resource">
					<fs ref="ora_jura_arch"/>
					<fs ref="ora_jura_redo"/>
					<fs ref="ora_jura_data"/>
					<fs ref="ora_jura_export"/>
					<oracledb ref="JURA1"/>
				</lvm>
			</ip>
		</service>
	</rm>
	<totem consensus="4800" join="60" token="15000"
token_retransmits_before_loss_const="20"/>
        <quorumd interval="2" label="OracleQuorum" tko="20"
upgrade_wait="2" master_wait="2" votes="1" log_level="7"
min_score="1" reboot="0" allow_kill="0" stop_cman="0"
status_file="/tmp/QdiskStatus">
        </quorumd>
</cluster>

> Could you post the full cluster.conf file?, and cluster logs in
> /var/log/messages....
>
>
>
>
>
> -----Original Message-----
> From: linux-cluster-bounces at redhat.com
> [mailto:linux-cluster-bounces at redhat.com] On Behalf Of jose nuno neto
> Sent: Thursday, March 18, 2010 6:14 PM
> To: linux clustering
> Subject: [Linux-cluster] oracledb.sh
>
> Hellos
>
> I'm setting up oracle has a failover service ( not RAC ) on rhcs
> Set up seems ok, I can switch from one node to the other
> But now I'm simulating failures and the /user/share/cluster/oracledb.sh
> detects the fail but keeps trying to restart the service on the same node.
>
> To simulate fail e kill pmon and removed a conf file initSID.ora
>
> Dont have any special options for restarting service:
>
> <service autostart="0" domain="scapa_failover_domain" exclusive="0"
> name="scapa" recovery="relocate">
>
> How can I set it so It'll fail and relocate to the other node?
>
> Thanks
> Jose
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster
>
> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.