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

[Sufyan Khan]

I can run the script by command as root, but do see the script is running in
background as  a daemon,  

 

 

Mohammad Raza Sufyan Khan 
Team Leader (Technology&Infrastructure Group)

Telco development

Description: Description: ITS Logo.pngT.    + (965) 22409100 ext. 379

M.   + (965) 99871684
F.    + (965) 22405201

                                      E.    sufyan.khan at its.ws

 

Description: Description: degital signeture.png

 

 

 

 

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 return 0 or 1 if database is up or 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-cluster] oracle DB is not failing 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 file system "/emc01" ext3 , 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.redhat.com/mailman/listinfo/linux-cluster

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20110514/ee7e56d2/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 130 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20110514/ee7e56d2/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 175 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20110514/ee7e56d2/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 5748 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20110514/ee7e56d2/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 8941 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20110514/ee7e56d2/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 3350 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/linux-cluster/attachments/20110514/ee7e56d2/attachment.jpg>