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
382 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 250 total points
Comment Utility
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.
Comment Utility
Can I ask why a C grade?
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

728 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now