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

Tue May 17 19:40:46 UTC 2011

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 at redhat.com
[mailto:linux-cluster-bounces at redhat.com] On Behalf Of Marcelo Guazzardo
Sent: Monday, May 16, 2011 3:20 PM
To: linux clustering
Subject: Re: [Linux-cluster] 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 hope that helps you
Regards,
Marcelo

2011/5/15 Sufyan Khan <sufyan.khan at its.ws>

Will you share if it is not confidential.

From: linux-cluster-bounces at redhat.com
[mailto:linux-cluster-bounces at redhat.com] On Behalf Of Marcelo Guazzardo
Sent: Sunday, May 15, 2011 7:03 PM

To: linux clustering
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 at its.ws>

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 at redhat.com
[mailto:linux-cluster-bounces at redhat.com] On Behalf Of Marcelo Guazzardo
Sent: Sunday, May 15, 2011 11:29 AM

To: linux clustering
Subject: Re: [Linux-cluster] 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 orauser, db_instance_name, and db_virtual name.

2011/5/15 Sufyan! Khan &lt han at its.ws">sufyan.khan at its.ws>

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 at redhat.com <mailto:linux-clust%21+er-bounceank>
[mailto:linux-cluster-bounces at redhat.com] On Behalf Of Rajagopal Swaminathan
Sent: Sunday, May 15, 2011 12:14 AM

To: linux clustering
Subject: Re: [Linux-cluster] 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 at redhat.com
https://www.redhat.com/mailman/listinfo/linux-cluster

-- 
Marcelo Guazzardo
mguazzardo76 at gmail.com
http://mguazzardo.blogspot.com

</htm 
--
Linux-cluster mailing list
Linux-cluster at redhat.com

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

-- 
Marcelo Guazzardo
mguazzardo76 at gmail.com
http://mguazzardo.blogspot.com

--
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/20110517/828b4acc/attachment.htm>