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

Marcelo Guazzardo mguazzardo76 at gmail.com
Mon May 16 23:17:14 UTC 2011


Hy Sufyan

Morning, I forgot nombrar the source that I 've followed to made a cluster
this is
http://people.redhat.com/lhh/oracle-rhel5-notes-0.6/oracle-notes.html
Good Luck!
Regards,

2011/5/16 Robert Hayden <rhayden.public at gmail.com>

> 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
>
> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster
>



-- 
Marcelo Guazzardo
mguazzardo76 at gmail.com
http://mguazzardo.blogspot.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20110516/5812e85a/attachment.htm>


More information about the Linux-cluster mailing list