MC/SG and Oracle

[Anthony Baldwin]

I am setting up MC/SG to failover an oracle DB between two nodes within a cluster. The database is located on a shared drive. The question is should a "shutdown abort" in the HALT_SCRIPT and a "startup pfile... " in the RUN_SCRIPT, be enough to bring down the database on one node and bring it up on the other, from a MC/SG perspective? Or would there be any other Oracle related command necessary to accomplish this?
I hope my question is clear. I thank you all for your responses in advance. Enjoy.

Anthony

[Ajay Sishodia]

NO, There is a HP oracle toolkit that you can buy for this.

regards
Ajay

[Russell Davy]

You are looking for :
B5139BJ Enterprise Cluster Master Toolkit.

Cheers
MND

[MARTINACHE · Accepted solution]

Hi,

You can use the oracle toolkit for start/stop your database.

But I suggest you to rewrite the monitoring script.

It only checks that oracle processes are running.
I think that it's bettet to do a right test with an sqlplus connexion.

Regards,

Patrice.

[Anthony Baldwin]

Thank you all. For some reason I am unable to assign points to Russell and Patrice. However, just for the record, they would be given as 6 and 9 respectively. Thank you again. Regards.

Anthony Baldwin