Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

shall I create the database on the failsafe server oracle 10g created on the windows 2003 server (mscs) cluster?

Posted on 2009-05-19
2
Medium Priority
?
408 Views
Last Modified: 2013-12-18
I have created the 2 node cluster on windows server 2003. then I have downloaded the failsafe installation software 3.3.3 from oracle .com.Created the failsafe server of oracle 10g successfully.Now I want to create the database for my application, so
1) shall I install the oracle 10g software in each node on private disk?
2) should I create the databse manualy and kepp the database file.log file and control files on the shared disk.
0
Comment
Question by:ajayg161073
  • 2
2 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 24434897
Not sure on Oracle -- but with SQL you have to have the files on shared resources or else the cluster can't fire the SQL (and other services) up because the Node in the cluster can't access the other drive.

From my experience -- I can dump backup files to an L: drive which is local to each server -- but I can't do an automated restore or use the GUI to do it because the SQL node doesn't have a dependency/resource to access the L: drives directly.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 24611647
Can I ask why a C grade?
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question