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

[Robert Hayden]

On Sat, May 14, 2011 at 2:21 PM, Sufyan Khan <sufyan.khan at its.ws> wrote:
>
> Yes , you can see in attached script

I can very well be miss reading the script, but with the status
function, you are returning a "0" or a "1" appropriately, but I am not
sure that return value is the return value for the script_db.sh.
Isn't that just the return value for the status function?  Meaning,
you need to set the RETVAL variable in the status function to be then
returned at the end of the bash script.  I don't code in bash much, so
RETVAL may be a special variable.  I attempted to boil down the script
to test.

#!/bin/bash
. /etc/rc.d/init.d/functions

status() {
return 1
}

case "$1" in
status)
   status
   ;;
*)
   echo $" Not Applicable"
   exit 1
esac

When I run the above, I see the "0" being returned.
[root ~]# ./status.ksh
 Not Applicable
[root ~]# ./status.ksh status
exiting script with
[root ~]# echo $?
0


echo "exiting script with $RETVAL"
exit $RETVAL




>
>
>
> From: linux-cluster-bounces at redhat.com [mailto:linux-cluster-bounces at redhat.com] On Behalf Of Parvez Shaikh
> Sent: Saturday, May 14, 2011 6:37 PM
> To: linux clustering
> Subject: Re: [Linux-cluster] oracle DB is not failing over on killin PMON deamon
>
>
>
> Hi Sufyan
>
> Does your status function r! eturn 0 o down respectively (i.e. have you tested it works outside script_db.sh) when run as "root"?
>
> On Thu, May 12, 2011 at 12:52 PM, Sufyan Khan <sufyan.khan at its.ws> wrote:
>
> First of all thanks for you quick response.
>
> Secondly please note:  the working "cluster.conf" file is attached here, the
> previous file was not correct.
> Yes the  orainfra is the user name.
>
> Any othere clue please.
>
> sufyan
>
>
>
>
>
> -----Original Message-----
> From: linux-cluster-bounces at redhat.com
>
> [mailto:linux-cluster-bounces at redhat.com] On Behalf Of Jankowski, Chris
> Sent: Thursday, May 12, 2011 9:44 AM
> To: linux clustering
> Subject: Re: [! Linux-clu iling over on killin PMON
>
> deamon
>
> Sufyan,
>
> What username does the instance of Oracle DB run as? Is this "orainfra" or
> some other username?
>
> The scripts assume a user named "orainfra".
> If you use a different username then you need to modify the scripts
> accordingly.
>
> Regards,
>
> Chris Jankowski
>
>
> -----Original Message-----
> From: linux-cluster-bounces at redhat.com
> [mailto:linux-cluster-bounces at redhat.com] On Behalf Of Sufyan Khan
> Sent: Thursday, 12 May 2011 16:27
> To: 'linux clustering'
> Subject: [Linux-cluster] oracle DB is not failing over on killin PMON deamon
>
> Dear All
>
> I need to setup HA cluster for mu oracle dabase.
> I have setup two node cluster using "System-Config-Cluster .." on RHEL 5.5 I
> created RG a  shared fil! e system shared IP and DB script to
> monitor the DB.
> My cluster starts perfectly and fail over on shutting down primary node,
> also stopping shared IP  fails node to failover node.
> But on kill PMON , or LSNR process the node does not fails and keep showing
> the status services running on primary node.
>
> I JUST NEED TO KNOW WHERE IS THE PROBLEM.
>
> ATTACHED IS DB scripts and "cluster.conf" file.
>
> Thanks in advance for help.
>
> Sufyan
>
>
>
>
> --
> 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.redha nux-cluster
>
>
>
> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster