Home » Infrastructure » Windows » Connect Tow Server Of The Same DataFile (4 Merged)
Connect Tow Server Of The Same DataFile (4 Merged) [message #482261] Wed, 10 November 2010 11:49 Go to next message
raul33
Messages: 26
Registered: October 2008
Location: jordan
Junior Member
Dear All

I have Tow Virtual Servers (Connect As Cluster) in the Same Computer The Files In the Drive C Different (of the Tow Servers) And Others Like (e,f,q) The Same Files

And There is Database of both Servers That Have Same Name Let say orcl and both database Have same Schema let Say sch
How I can Share The Data when i am insert to table. in the schema sch in the server A i can see Same Data That I have Inserted In the Schema sch in the server B

Can I Connect To The Same Datafile Of Both Servers

Thanks In Advance.
Re: Connect Tow Server Of The Same DataFile [message #482265 is a reply to message #482261] Wed, 10 November 2010 11:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/install.102/b14207/toc.htm

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Connect Tow Server Of The Same DataFile [message #482278 is a reply to message #482265] Wed, 10 November 2010 15:19 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
It is important to be precise in your use of words when discussing Oracle. Perhaps I can help by explaining some terminology?
An Oracle instance is memory structures and processes: it exists in your RAM and CPU. An Oracle database is files on disc. An Oracle server is a database opened by one (or more) instances. I think that what you are asking is whether two instances, on two machines, can open one database on a shared disc. The answer is "yes": this is called a RAC database.
However, a RAC is not something that a novice DBA can manage easily, and you probably do not want to do that.
Re: Connect Tow Server Of The Same DataFile [message #482310 is a reply to message #482278] Thu, 11 November 2010 00:33 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
<off-topic>

The OP repeated (three times!) the word "tow". Once, it is a typo. Another time, OK - typo again. But three times saying "tow" instead of "two"? Do "Tow Virtual Servers" really exist? Google suggests that I, actually, want "two", not "tow".

</off-topic>
Re: Connect Tow Server Of The Same DataFile (4 Merged) [message #482415 is a reply to message #482261] Thu, 11 November 2010 05:17 Go to previous message
raul33
Messages: 26
Registered: October 2008
Location: jordan
Junior Member
Thanks For All
Previous Topic: Oracle 9i R2 download
Next Topic: Installation of Oracle Database 10g or more
Goto Forum:
  


Current Time: Thu Mar 28 09:23:41 CDT 2024