troubleshooting Question

Creating an oracle database on a windows cluster failover node, using data files on shared drive.

Avatar of andrewfx
andrewfx asked on
Oracle Database
3 Comments1 Solution720 ViewsLast Modified:
I have 2 windows machines that are set up as a cluster.  Both of them have oracle installed.  Both of them have a network drive D setup.  When the cluster fails over to node2, drive D is mounted on that machine and all oracle files are available there.

I have created a database on Node1.  All files (redo logs, control files, data files) are stored on the shared D drive.  For easiness sake, lets call this database catdb.  Catdb works fine and perfect on node1.  

What I need to do is create that database on Node2 of the cluster so that it uses the control files, redo logs, data files that are stored on shared drive D.

What would be the best way to do this?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros