Re: oracle DB is not failing over on killin PMON deamon

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx>
On Sat, May 14, 2011 at 2:21 PM, Sufyan Khan <sufyan.khan@xxxxxx> 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@xxxxxxxxxx [mailto:linux-cluster-bounces@xxxxxxxxxx] On Behalf Of Parvez Shaikh
> Sent: Saturday, May 14, 2011 6:37 PM
> To: linux clustering
> Subject: Re: 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@xxxxxx> 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@xxxxxxxxxx
>
> [mailto:linux-cluster-bounces@xxxxxxxxxx] 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@xxxxxxxxxx
> [mailto:linux-cluster-bounces@xxxxxxxxxx] On Behalf Of Sufyan Khan
> Sent: Thursday, 12 May 2011 16:27
> To: 'linux clustering'
> Subject: 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@xxxxxxxxxx
> https://www.redhat.com/mailman/listinfo/linux-cluster
>
> --
> Linux-cluster mailing list
> Linux-cluster@xxxxxxxxxx
> https://! www.redha nux-cluster
>
>
>
> --
> Linux-cluster mailing list
> Linux-cluster@xxxxxxxxxx
> https://www.redhat.com/mailman/listinfo/linux-cluster

--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster



--
Marcelo Guazzardo
mguazzardo76@xxxxxxxxx
http://mguazzardo.blogspot.com


--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster

[Index of Archives]     [Corosync Cluster Engine]     [GFS]     [Linux Virtualization]     [Centos Virtualization]     [Centos]     [Linux RAID]     [Fedora Users]     [Fedora SELinux]     [Big List of Linux Books]     [Yosemite Camping]

  Powered by Linux