Have you tried doing a tnsping from the command line? Can you connect via SQL plus to the oracle instance? Are you able to ping the oracle source...

That wouldn't be possible. The clustered instance would need to have disk that is only presented to the Windows cluster. The databases, logins, etc would need to them...

aruopna (5/14/2012)

---

I'm aware this is an old post, But I feel there may be a small error in the schema script section.

that section will result in an out put something...

Thanks guys! That join was where I had issues,and I really wanted to see where the computer names were different (where NULL that meant I had nothing to join...

SQLKnowItAll (2/20/2012)

---

Matt Miller (#4) (2/20/2012)

---

SQLKnowItAll (2/20/2012)

---

Matt Miller (#4) (2/20/2012)

---

So - no record is returned since you can't join to a record that doesn't match the join (at least not as...

LOL- Wasn't the cause.. ...

Whoops- Let me edit that.. Sorry for the confusion.

To your other question, yes, we are looking to join just the Server Name (Network Name) for the clustered instance.

The virtual servers...

veeresasai (1/3/2012)

---

Hi S. Kusen,

Thanks buddy. It helped to have quick fix.

How did you interpret the error message, when it said "script file can not load for execution"?

What are the...

For my company, when we move data centers, we usually don't have the option to add back in to the existing cluster, and I'm not sure how you're going to...

Therefore, they want the rest of the tables still replicated. Dropping the subscription would halt the replication.

The non-intuitive part is that sys.sp_dropsubscription accepts the article name. I was hoping...

It seems like the OP wants the replication to continue, but doesn't require the one specific article any longer to be replicated. Therefore, they want the rest of the...

I have not personally seen any issues with the DTC. I will say, however, that we have the DTC running as its own service in the cluster, and don't...

In 2008 and 2008 R2 (might only be enterprise), there is the change data capture configuration that could also be put in place.

http://msdn.microsoft.com/en-us/library/bb522489.aspx

Regards,

Steve

If you had a 2008 or above failover instance installed and then uninstalled everything, I would guess that there are portions of that install leftover that is causing issues installing...

Have you tried testing the mirroring in asynchronous mode without a witness? Same results?

You can then pull up the mirroring monitor, set thresholds for the unsent/unrestored log and you...