Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2007-07-20 : 07:35:37
|
| Hi All,Can I use a single shared drive to configure 2 cluster of Oracle and SQL server?Let me explain my question a little but.1) I have 2 Servers attached to a SAN box configured on Cluster (Active-Passive). 2) I have installed SQL and Oracle servers on each Server attached to the SAN box.3) Lets say SQL server fails on Server A but Oracle is still working fine on Server A, Will there be a Failover? Thanks in AdvanceSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-20 : 09:17:07
|
| for as far i know stuff about clustering an automatic failover is caused only when there is a problem with your node, not due to a failure in SQL server.Need an SQLDB consultant?check www.veeningsengineering.nl |
 |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2007-07-20 : 09:19:59
|
| Thanks for ur reply.But is it possible to have 2 cluster on the same SAN?Thanks,SachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-20 : 10:46:43
|
| If you have sql and Oracle share same SAN array, they have to be in same resource group. If either of them caused failover, while group will failover. So you are better to put them on separate SAN arrays and let them owned by different node. |
|
|
|
|
|
|
Cluster