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

[Munish <munishdh@xxxxxxxxx>]

Where was the problem ? What has been done to fix it? 

Cheers!!!

Munish

On May 18, 2011, at 3:40 AM, Sufyan Khan <sufyan.khan@xxxxxx> wrote:

Hi Marcelo

 

I am succeeded to run oracle DB and its restarting automatically with killing  pmon process.

 

Thanks to all.

 

I have another question (sorry I am new to RHEL cluster) my oracle application server and DB  server has different HOME directory, if I used oracledb.sh , service fails in startup because in the oracledb.sh the HOME directory is same for PMON and OPMN process.

What could be the solution , I am using ricci and luci.

 

sufyan

From: linux-cluster-bounces@xxxxxxxxxx [mailto:linux-cluster-bounces@xxxxxxxxxx] On Behalf Of Marcelo Guazzardo
Sent: Monday, May 16, 2011 3:20 PM
To: linux clustering
Subject: Re: oracle DB is not failing over on killin PMON deamon

 

Hy sufyan

I sent two files. First, is cluster.conf, second, is the oracledb.sh , this file must be placed in /usr/share/cluster in both nodes. (Or if you have more nodes, in all nodes).
In oracledb.sh I 've changed oracle_user, oracle_sid, type of database, I used base (for monitor and listener), and virtual ip,

If you have any doubt, just let me know
I h! ope that Marcelo

2011/5/15 Sufyan Khan <sufyan.khan@xxxxxx>

Will you share if it is not confidential.

 

From: linux-cluster-bounces@xxxxxxxxxx [mailto:linux-cluster-bounces@xxxxxxxxxx] On Behalf Of Marcelo Guazzardo
Sent: Sunday, May 15, 2011 7:03 PM

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

 

ok, this script checks the listener a! nd db , i uot; in database type.

I 've worked with oracle10g r2 , and it worked fine for me.
Thanks

2011/5/15 Sufyan Khan <sufyan.khan@xxxxxx>

Thanks for the tips,

 

I need only oracle database to be monitor by Cluster NOT OPMN ( application server)

Any clue

 

sufyan

 

From: linux-cluster-bounces@xxxxxxxxxx] On Behalf Of Marcelo Guazzardo
Sent: Sunday, May 15, 2011 11:29 AM

To: linux clustering
Subject: Re: oracle DB is not failing over on killin PMON deamon

 

HI sufyan

Maybe is irrelevant, but, do you try with oracledb.sh script?.
I use that script and all work fine for me....

Regards,
Marcelo
PS: that script is placed in /usr/share/cluster/oracledb.sh, you must modify the oracle settings,! like ora nd db_virtual name.

2011/5/15 Sufyan! Khan &lt han@xxxxxx">sufyan.khan@xxxxxx>

There is writing mistake, I cannot see the script is running in background.!  

Off course I stop the cluster then I run the manual script.

 

 

  

From: linux-cluster-bounces@xxxxxxxxxx [mailto:linux-cluster-bounces@xxxxxxxxxx] On Behalf Of Rajagopal Swaminathan
Sent: Sunday, May 15, 2011 12:14 AM

To: linux clustering
Subject: Re: oracle DB is not failing over on killin PMON deamon

 

Greetings,

I ca nd 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

a stupid question: Have you used chkconfig to switchoff all the cluster controlled services?

! IMHO, The >Regards,

! Rajagopal v>

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

-- Marcel ailto:mguazzardo76@xxxxxxxxx" target="_blank">mguazzardo76@xxxxxxxxx
http://mguazzardo.blogspot.com

</htm
--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx

https://www.redhat.com/mailman/listinfo/linux-clust! er

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

--
Linux-cluster mailing list
Linu! x-cluster f="https://www.redhat.com/mailman/listinfo/linux-cluster" target="_blank">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

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